Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. __________ is a contiguous group of blocks allocated for use as part of a table, index,and so forth.
a. Tablespace
b. Segment
c. Extent
d. Block
Q. ________ is the smallest unit of allocation in an Oracle database.
a. Database
b. Instance
c. Tablespace
d. Database Block
Q. An Oracle __________ is a set of tables and views that are used as a read-onlyreference about the database.
a. Database dictionary
b. Dictionary table
c. Data dictionary
d. Dictionary
Q. A data dictionary is created when a __________ created.
a. Instance
b. Segment
c. Database
d. Dictionary
Q. An Oracle object type has two parts the _________ and__________
a. Instance and body
b. Segment and blocks
c. Specification and body
d. Body and segment
Q. A(n) _________ can be used to preserve the integrity of a document or a message.
a. Message digest
b. Message summary
c. Encrypted message
d. None of the mentioned
Q. What is the main limitation of Hierarchical Databases?
a. Limited capacity (unable to hold much datA:)
b. Limited flexibility in accessing data
c. Overhead associated with maintaining indexes
d. The performance of the database is poor
Q. The property (or set of properties) that uniquely defines each row in a table is called the:
a. Identifier
b. Index
c. Primary key
d. Symmetric key
Q. The separation of the data definition from the program is known as:
a. Data dictionary
b. Data independence
c. Data integrity
d. Referential integrity
Q. The traditional storage of data that is organized by customer, stored in separate foldersin filing cabinets is an example of what type of ‘database’ system?
a. Hierarchical
b. Network
c. Object oriented
d. Relational
Q. The database design that consists of multiple tables that are linked together throughmatching data stored in each table is called
a. Hierarchical database
b. Network database
c. Object oriented database
d. Relational database
Q. The association role defines:
a. How tables are related in the database
b. The relationship between the class diagram and the tables in the database
c. The tables that each attribute is contained
d. Which attribute is the table’s primary key
Q. The purpose of an N-Ary association is:
a. To capture a parent-child relationship
b. To deal with one to many relationships
c. To deal with relationships that involve more than two tables
d. To represent an inheritance relationship
Q. In ordered indices the file containing the records is sequentially ordered, a___________ is an index whose search key also defines the sequential order of the file.
a. Clustered index
b. Structured index
c. Unstructured index
d. Nonclustered index