Question # 1

While recovering data, which of the following files does a recovery manager examines at first?

Choose an answer

A system file

Log file

Data dictionary

Metadata

GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION; What does this SQL statement do?

Choose an answer

Grant permission to Amali,only to retrieve data from Employee table and grant permission to Hiruni, only to update the designation from Employee table.

Grant permission to Hiruni in order to grant, select and update permission to Amali.

Grant permission to Amali & Hiruni to update designation of employees in the Employee table

Grant permission to Amali and Hiruni to update all data except designation in Employee table

Which of the following SQL commands deletes a record of an employee with the employee_id 12345, from a table named PERSON.

Choose an answer

DELETE FROM person WHERE employee_id = ‘12345’

DELETE WHERE person FROM employee_id = 12345

DROP FROM person WHERE employee_id = 12345

DELETE WHERE person WHERE employee_id = 12345

Which of the given techniques is/are used to improve query performance in database?

Choose an answer

Good File organization

Indexing

Both Indexing and Good File organization

Select only one record per query

Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of the following gives all the information of the customers in the table whose last name is ALI?

Choose an answer

SELECT * FROM CUST WHERE last_name='ALI';

SELECT * FROM CUST WHERE last_name=ALI;

SELECT * FROM CUSTOMER WHERE name=ALI;

SELECT * FROM CUSTOMER WHERE last_name=ALI;

Which of the following is NOT a feature of a good interface?

Choose an answer

Consistency

Process based

Data structure based

User friendly

Which of following is not the feature of Indexes?

Choose an answer

consume storage space

must be refreshed when the data in their master tables changes

improve the performance of SQL execution when they are used for query rewrites

can be accessed directly using a SELECT statement

How many clustered index(es) do each database table have?

Choose an answer

2

3

4

1

Which of the following enforces a relation into 1st normal form?

Choose an answer

The domain of attribute must include only atomic values.

Every non-key attribute is fully functionally dependent on primary key

non-key attribute is non-transitively dependent on primary key.

Every non-key attribute is partially dependent on super key

Which of the following are the general activities, which are performed during the development of application programs?

Choose an answer

Data input programs

Editing

Display

All of given

Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?

Choose an answer

Join

Union

Cartesian Product

Set Difference

More Classes

Other Links

CS-403 Final Term Exams Preparation Virtual University MCQs With Answers

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer