DBMS MCQs Test 5

This Test will cover complete DBMS with very important questions, starting off from basics to advanced level.

Q. If a relational schema is in BCNF, then it is also in __________.
Q. A Binary relation is in __________.
Q. Normalization of database is used to __________.
Q. Functional dependencies are a generalization of __________.

Q. Every Boyce-Codd Normal Form (BCNF) decomposition is __________.
Q. A record in the 3rd Normal Form is better than a record in 1st Normal Form by Relational Mathematics viewpoint. True or False?
Q. Which of the following statements can be used to List all the rows of a table?
Q. A Relational database which is in 3NF form, may still have undesirable data redundancy because there may exist __________.
Q. An Access path is provided by __________.

Q. Which of the following is true about an Indexing Operation?
Q. The Master list of an indexed file __________.
Q. Index consists of __________?
Q. To have a file, hold a list, it is necessary to __________.
Q. If a Numeric field has a width of 5.2, then value of the field could be __________.
Q. Versatile report generators can provide __________.

SUBMIT TEST