Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Which is relation calculus:
a. Tuple relational calculus
b. Domain relational calculus
c. Both
d. None
Q. Which calculus is based on specifying a number of tuple variables:
a. Tuple relation calculus
b. Domain relational calculus
c. Both
d. None
Q. If a piece of data is stored in two places in the database, then
a. Storage space is wasted
b. Changing the data in one spot will cause data inconsistency
c. In can be more easily accessed
d. Storage space is wasted & Changing the data in one spot will cause data inconsistency
Q. An audit trail ___________
a. Is used to make backup copies
b. Is the recorded history of operations performed on a file
c. Can be used to restore lost information
d. None of the mentioned
Q. Which of the following hardware component is the most important to the operation of adatabase management system?
a. High resolution video display
b. Printer
c. High speed, large capacity disk
d. Mouse
Q. Which of the following is not true of the traditional approach to information processing
a. There is common sharing of data among the various applications
b. It is file oriented
c. Programs are dependent on the file
d. It is inflexible
Q. The information about data in a database is called _______
a. Metadata
b. Hyper data
c. Tera data
d. None of the mentioned
Q. A data dictionary is a special file that contains?
a. The names of all fields in all files
b. The data types of all fields in all files
c. The widths of all fields in all files
d. All of the mentioned
Q. A relational database system needs to maintain data about the relations, such as theschema of the relations. This is called
a. Metadata
b. Catalog
c. Log
d. Dictionary
Q. Relational schemas and other metadata about relations are stored in a structure calledthe ____________
a. Metadata
b. Catalog
c. Log
d. Data Dictionary
Q. ___________ is the collection of memory structures and Oracle background processesthat operates against an Oracle database.
a. Database
b. Instance
c. Tablespace
d. Segment
Q. A ________ is a logical grouping of database objects, usually to facilitate security,performance, or the availability of database objects such as tables and indexes.
a. Tablespace
b. Segments
c. Extents
d. Blocks