Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. One approach to standardization storing of data?
a. codasyl specification
b. none of the options
c. mis
d. structured programming
Q. Report generators are used to
a. store data input by a user
b. answer queries
c. both retrieve information from files and answer queries
d. retrieve information from files
Q. Which of the following is true of a network structure?
a. it will be dominant data base of the future
b. it allows a many-to-many relationship
c. it is a physical representation of the data
d. it is conceptually simple
Q. A record management system
a. can handle many files of information at a time
b. always uses a list as its model
c. both can handle many files of information at a time and always uses a list as its model
d. can be used to extract information stored in a computer file
Q. The function of a database is ...
a. to check all input data
b. to output data
c. to collect and organize input data
d. to check all spelling
Q. A command that lets you change one or more fields in a record is
a. none of the options
b. modify
c. insert
d. lookup
Q. What is the language used by most of the DBMSs for helping their users to access data?
a. high level language
b. 4gl
c. query language
d. sql
Q. Information can be transferred between the DBMS and a
a. spreadsheet program
b. word processor program
c. graphics program
d. all of the options
Q. The relational database environment has all of the following components except
a. users
b. database
c. query languages
d. separate files
Q. The ascending order of a data hirerchy is:
a. bit-byte-file-record-field-database
b. bit-byte-field-record-file-database
c. bit-byte-record-field-file-database
d. byte-bit-field-record-file-database
Q. The magnetic storage chip used to provide non-volatile direct access storage of data and that have no moving parts are known as
a. magnetic core memory
b. magnetic tape memory
c. magnetic disk memory
d. magnetic bubble memory
Q. The ALU of a computer normally contains a number of high speed storage element called
a. semiconductor memory
b. registers
c. hard disks
d. magnetic disk
Q. A dump of the database contents is also referred to as an dump.
a. archival
b. fuzzy
c. sql
d. all of the mentioned
Q. dump schemes have been developed that allow transactions to be active while the dump is in progress.
a. archival
b. fuzzy
c. sql
d. all of the mentioned