Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Indices whose search key specifies an order different from the sequential order of thefile are called ___________ indices.
a. Nonclustered
b. Secondary
c. All of the mentioned
d. None of the mentioned
Q. An ____________ consists of a search-key value and pointers to one or more recordswith that value as their search-key value.
a. Index entry
b. Index hash
c. Index cluster
d. Index map
Q. In a __________ index, an index entry appears for only some of the search-key values.
a. Dense
b. Sparse
c. Straight
d. Continuous
Q. Incase the indices values are larger, index is created for these values of the index. Thisis called
a. Pointed index
b. Sequential index
c. Multilevel index
d. Multiple index
Q. A search key containing more than one attribute is referred to as a _________ searchkey.
a. Simple
b. Composite
c. Compound
d. Secondary
Q. Insertion of a large number of entries at a time into an index is referred to as__________ of the index.
a. Loading
b. Bulk insertion
c. Bulk loading
d. Increase insertion
Q. While inserting the record into the index, if the search-key value does not appear in theindex.
a. The system adds a pointer to the new record in the index entry
b. The system places the record being inserted after the other records with the same searchkey values
c. The system inserts an index entry with the search-key value in the index at the appropriate position
d. None of the mentioned
Q. A collection of data designed to be used by different people is called a/an
a. Organization
b. Database
c. Relationship
d. Schema
Q. Which of the following is the oldest database model?
a. Relational
b. Deductive
c. Physical
d. Network
Q. Primitive operations common to all record management system include
a. look-up
b. all of the options
c. print
d. sort
Q. Which of the following is not a relational database?
a. dbase iv
b. foxpro
c. reflex
d. 4th dimension
Q. A top-to-bottom relationship among the items in a database is established by a
a. hierarchical schema
b. all of the options
c. network schema
d. relational schema
Q. Choose the RDBMS which supports full fledged client server application development
a. dbase v
b. ingress
c. oracle 7.1
d. foxpro 2.1
Q. The highest level in the hierarchy of data organization is called
a. data base
b. data record
c. data bank
d. data file