Database Management System MCQs

Our Database Management System (DBMS) questions and answers focus on all areas of Database Management System subject covering 100+ topics in Database Management System. These topics are chosen from a collection of the most authoritative and best reference books on Database Management System (DBMS). One should spend 1 hour daily for 2-3 months to learn and assimilate Database Management System comprehensively. This way of systematic learning will prepare anyone easily for Database Management System interviews, online tests, examinations and certifications.

Q: ;Conceptual design ?

A. Is a documentation technique.
B. Needs data volume and processing frequencies to determine the size of the database.
C. Involves modelling independent of the DBMS
D. Is designing the relational model.


View Answer

Q: The relational model feature is that there ?

A. Is no need for primary key data
B. Is much more data independence than some other database models
C. Are explicit relationships among records
D. Are tables with many dimensions


View Answer

Q: A relational database developer refers to a record as ?

A. A criteria.
B. A relation.
C. A tuple.
D. An attribute.


View Answer

Q: The property / properties of a database is / are : ?

A. It is an integrated collection of logically related records.
B. It consolidates separate files into a common pool of data records.
C. Data stored in a database is independent of the application programs using it
D. All of the above


View Answer

Q: A report generator is used to ?

A. Update files.
B. Print files on paper
C. Data entry.
D. Delete files.


View Answer

Q: The way a particular application views the data from the database that the application ;uses is a ?

A. Module.
B. Relational model.
C. Schema.
D. Sub schema.


View Answer

Q: The database environment has all of the following components except: ?

A. Users.
B. Separate files
C. Database.
D. Database administrator


View Answer

Q: Related fields in a database are grouped to form a ?

A. Data file
B. Data record.
C. Menu.
D. Bank.


View Answer

Q: ;A logical schema ?

A. Is the entire database.
B. describe data in terms of relational tables and columns, object-oriented classes, and XML tags.
C. Describes how data is actually stored on disk.
D. Both (A) and (C)


View Answer

Q: In tuple relational calculus P1 → P2 is equivalent to ?

A. ¬ P1  ∨ P2
B. P1 ∨ P2
C. P1  ∧ P2
D. P1  ∧ ¬P2


View Answer