DBMS

1. The ______________ database is the most widely used database structure.

A. Hierarchical B. General C. Standard D. Relational Ans: D

2. Which normal form is considered adequate for relational database design?

A. 2NF B. 3NF C. 4NF D. BCNF Ans: B

3. In SQL, which command is used to remove rows from a table?

A. Truncate B. Delete C. Remove D. Both (A) and (B) Ans: D

4. In relational database, the natural join of two tables is

A. cartesian product always

B. combination of union and filtered cartesian product

C. combination of selection and filtered cartesian product

D. combination of projection and filtered cartesian product Ans: D

5. 3NF is preferred than BCNF because

(i) we normally choose to retain dependency preservation.

(ii) a high penalty in system performance is to be paid or risk the integrity of the data in out database.

(iii) there is not any problem of repetition of information

(iv) Given statement is wrong

A. Only (iv) is true B. (ii) and (iii) are true C. (i) and (ii) are true D. Only (iii) is true Ans: C

6. Null values in SQL indicate

(i) Zero value (ii) Value in unknown (iii) Value does not exist

A. Only (iii) B. (ii) and (iii) C. (i) and (ii) D. All of these Ans: B

7. The __________ operator is used to compare a value to a list of literals values that have been specified.

A. Between B. Any C. In D. All Ans: A

8. To discard all pending data changes

A. Commit B. Rollback C. Savepoint D. Lock Ans: B

9. A function that has no partial functional dependencies are in

A. 3NF B. 2NF C. 4NF D. BCNF Ans: B

10. In SQl, which command is used to change a table's storage characteristics?

A. Change table B. Modify table C. Alter table D. None Ans: C