Top 150+ Solved Basics of Database Management System (DBMS) MCQ Questions Answer
Q. An identification field in a record. Select the best fit for answer
a. Record
b. File
c. Database
d. Key field
Q. What is part of database that holds all of the information about one item or subject?
a. Record
b. File
c. Query
d. Chart
Q. RDBMS stands for
a. Relational Database Management System
b. Relation Data Module System
c. Right Data Base Management System
d. None of the above
Q. Pack command is used to
a. Remove records permanently
b. Remove records temporarily
c. Restore records permanently
d. Restore records temporarily
Q. Modules are
a. selection of commands used to automate repetitive tasks
b. programs written in Visual C++
c. Object tabs
d. Group of records
Q. APPEND command is used to
a. Add record to the end of active database file and starts full screen data entry
b. Add Record to the start of active database file
c. Add record to the start of active database file and starts full screen data entry
d. Add record to the end of database file
Q. Append from command is used to
a. Add records from information in an array
b. Adds records from a file
c. Add records from a variable
d. Add records from stock
Q. Examples of centralized multi-user databases are
a. Barclays’ Bank customer accounts
b. Supermarket stock control, organ donor database, client database
c. Airline reservations and other national global booking systems
d. None of above
Q. New record is added using
a. Append record from browse menu
b. Append record into from browse menu
c. Add record from edit menu
d. All of above
Q. When a customer makes an online hotel booking, the database is updated in
a. Batch mode
b. Pseudo real-time
c. One month
d. All of above
Q. A database that contains tables linked by common fields is called a
a. Centralized database
b. Flat file database
c. Relational database
d. None of above
Q. The use of integrated collections of database records and files for data storage and processing. The best fit for answer:
a. Database management approach
b. DBMS uses
c. Database administrator
d. Query language
Q. DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer
a. Database management approach
b. DBBMS uses
c. Database administrator
d. Query language
Q. A specialist in charge of the database of anorganization select the best fit for answer
a. Database management approach
b. DBMS uses
c. Database administrator
d. Query language