Database Management System (DBMS) MCQs | Page - 4

Dear candidates you will find MCQ questions of Database Management System (DBMS) here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.

Q. The Query is a statement requesting for

  • (A) Insertion of information
  • (B) Deletion of information
  • (C) Update of information
  • (D) Retrieval of information
💬 Discuss
✅ Correct Answer: (D) Retrieval of information

Published by Madhu ⭐ 12.07K Points at 04-Nov-2020 03:46 pm in Database Management System (DBMS)

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
💬 Discuss
✅ Correct Answer: (A) Is a low percentages of number of records added or deleted from a file

Published by Madhu ⭐ 12.07K Points at 04-Nov-2020 03:46 pm in Database Management System (DBMS)

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
💬 Discuss
✅ Correct Answer: (D) it duplicate the database file

Published by Madhu ⭐ 12.07K Points at 04-Nov-2020 03:46 pm in Database Management System (DBMS)

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
💬 Discuss
✅ Correct Answer: (C) Mouse, keyboard, touch screen

Published by Madhu ⭐ 12.07K Points at 04-Nov-2020 03:46 pm in Database Management System (DBMS)

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
💬 Discuss
✅ Correct Answer: (A) List of database contents

Published by Madhu ⭐ 12.07K Points at 04-Nov-2020 03:46 pm in Database Management System (DBMS)

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

  • (A) Main field
  • (B) Header
  • (C) Key field
  • (D) None of above
💬 Discuss
✅ Correct Answer: (C) Key field

Published by Madhu ⭐ 12.07K Points at 04-Nov-2020 03:46 pm in Database Management System (DBMS)

Q. Corrupted index file is corrected using

  • (A) Modifyindex
  • (B) Recreateindex
  • (C) Reindex
  • (D) None of the above
💬 Discuss
✅ Correct Answer: (C) Reindex

Published by Madhu ⭐ 12.07K Points at 04-Nov-2020 03:46 pm in Database Management System (DBMS)

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
💬 Discuss
✅ Correct Answer: (C) (A) and (B) both

Published by Madhu ⭐ 12.07K Points at 04-Nov-2020 03:46 pm in Database Management System (DBMS)

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
💬 Discuss
✅ Correct Answer: (A) Password

Published by Madhu ⭐ 12.07K Points at 04-Nov-2020 03:46 pm in Database Management System (DBMS)

Jump to

Explore More Categories

Click on category to learn MCQs of that category.

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play