Top 150+ Solved Basics of Database Management System (DBMS) MCQ Questions Answer
Q. The following command is used for inserting records
a. INSERT
b. ADD
c. Both of the above
d. None of the above
Q. The Query is a statement requesting for
a. Insertion of information
b. Deletion of information
c. Update of information
d. Retrieval of information
Q. The activity of a file
a. Is a low percentages of number of records added or deleted from a file
b. If high, reduces processing efficiency for sequential and non sequential files
c. Is a measure of the percentage of existing records updated during a run
d. Refers to how closely the files fit into the allocated
Q. The following statement is not valid about indexing
a. it stores the index fields
b. it stores the corresponding record number
c. it maintains the alphabetically order
d. it duplicate the database file
Q. The following devices can be used to input data into a database
a. Keyboard, fax roller ball
b. Mouse, keyboard, monitor
c. Mouse, keyboard, touch screen
d. None of the above
Q. List command is used to get
a. List of database contents
b. List of database contents
c. List of variables used in database file
d. None of the above
Q. A field that uniquely identifies a record is called a
a. Main field
b. Header
c. Key field
d. None of above
Q. Corrupted index file is corrected using
a. Modifyindex
b. Recreateindex
c. Reindex
d. None of the above
Q. The navigation buttons enable you to
a. move from record to record in a table or form
b. move from page to page in report
c. (A) and (B) both
d. None of the above
Q. Different levels of access are assigned to personnel records in the health and fitness gym. Only the system manager is able to create delete or edit records. Certain other personnel are allowed to view all the records, whereas others are not permitted to view complete records. The levels of access are controlled by
a. Password
b. User id’s
c. Status
d. None of the above
Q. You can switch back and forth betweendesign and datasheet view by clicking the
a. queries object tab
b. switch command on the view menu
c. view button
d. select query title bar
Q. The table wizard
a. Quickly creates a default report
b. Displays a subset of the data in a database
c. Contains sample tables and fields you can use to create a table
d. Automatically edits your data as you enter it
Q. The names, address, and account balance of all of your customers, select the best fit for answer
a. record
b. file
c. database
d. key field
Q. An integrated collection of all of the data about your customers. Select the best fit for answer
a. Record
b. File
c. Database
d. Key field