Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. The management information system (MIS) structure with one main computer system is called a
a. decentralized mis structure
b. centralized mis structure
c. hierarchical mis structure
d. distributed mis structure
Q. In the DBMS approach, application programs perform the
a. storage function
b. access control
c. all of the options
d. processing functions
Q. Which of the following is not true of the traditional approach to information processing
a. it is file oriented
b. it is inflexible
c. there is common sharing of data among the various applications
d. programs are dependent on the file
Q. Batch processing is appropriate if
a. only a few transactions are involved
b. none of the options
c. large computer system is available
d. only a small computer system is avilbale
Q. A transparent DBMS
a. both can not hide sensitive information from users and keeps its logical structure hidden from users
b. keeps its physical structure hidden from users
c. can not hide sensitive information from users
d. keeps its logical structure hidden from users
Q. A file produced by a spreadsheet
a. none of the options
b. is generally stored on disk in an ascii text fromat
c. can be used as is by the dbms
d. both is generally stored on disk in an ascii text fromat and can be used as is by the dbms
Q. The model for a record management system might be
a. all of the options
b. a business form
c. handwritten list
d. a rolodex card file
Q. Database management systems are intended to
a. eliminate data redundancy
b. establish relationship among records in different files
c. manage file access and maintain data integrity
d. all of the options
Q. The language used application programs to request data from the DBMS is referred to as the
a. ddl
b. all of the options
c. dml
d. query language
Q. A set of programs that handle a firm's database responsibilities is called
a. database management system (dbms)
b. data management system (dms)
c. all of the options
d. database processing system (dbps)
Q. In a large DBMS
a. each subschema contains every field in the logical schema
b. each user can access every subschema
c. none of the options
d. each user can "see" only a small part of the entire database
Q. In a large DBMS
a. none of the options
b. each user can "see" only a small part of the entire database
c. each subschema contains every field in the logical schema
d. each user can access every subschema
Q. A Database Management System (DBMS) is
a. collection of interrelated data
b. collection of programs to access data
c. collection of data describing one particular enterprise
d. all of the above
Q. Which of the following is not a level of data abstraction?
a. physical level
b. critical level
c. logical level
d. view level