Database Management System (DBMS) MCQs with answers Page - 4

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 828.03K Points
Coach

Q. The Query is a statement requesting for

  • (A) Insertion of information
  • (B) Deletion of information
  • (C) Update of information
  • (D) Retrieval of information

A

Admin • 828.03K Points
Coach

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

A

Admin • 828.03K Points
Coach

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

A

Admin • 828.03K Points
Coach

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

A

Admin • 828.03K Points
Coach

Q. The following command is used for sorting

  • (A) list
  • (B) browse
  • (C) index
  • (D) sort

A

Admin • 828.03K Points
Coach

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

A

Admin • 828.03K Points
Coach

Q. A field that uniquely identifies a record is called a

  • (A) Main field
  • (B) Header
  • (C) Key field
  • (D) None of above

A

Admin • 828.03K Points
Coach

Q. Corrupted index file is corrected using

  • (A) Modifyindex
  • (B) Recreateindex
  • (C) Reindex
  • (D) None of the above

A

Admin • 828.03K Points
Coach

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

A

Admin • 828.03K Points
Coach

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

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.