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

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 • 833K Points
Coach

Q. COPY STRUCTURE command is used to

  • (A) Copy contents of an active database to a new file
  • (B) Copy all records of an active database to disk
  • (C) Copy contents of an active database to disk
  • (D) Copy structure of an active database to a new file

A

Admin • 833K Points
Coach

Q. DBMS is

  • (A) Collection of data
  • (B) Set of programs to access those data
  • (C) Set of programs to update those data
  • (D) All of the above

A

Admin • 833K Points
Coach

Q. If you are entering data in a form, a quick way to copy a value from the previous record is to press

  • (A) Ctrl+’
  • (B) F6
  • (C) Ctrl+D
  • (D) None of the above

A

Admin • 833K Points
Coach

Q. Sub-schema can be used to

  • (A) Create very different, personalized views of the same data
  • (B) Present information in different formats
  • (C) Hide sensitive information by omitting fields from the subschema’s description
  • (D) All of the above

A

Admin • 833K Points
Coach

Q. The purpose of the Add-in Manager is to

  • (A) Create macros and automate data processing
  • (B) Add or remove data in an existing database
  • (C) Add or remove templates, macros, and wizards
  • (D) All of above

A

Admin • 833K Points
Coach

Q. Which of the following are common ways to enforce data validation when entering data into an Access form?

  • (A) Create an input mask to restrict the kind of value that can be entered in positions across the field.
  • (B) Define a validation rule for that field
  • (C) A and B
  • (D) none of the above

A

Admin • 833K Points
Coach

Q. Pivot Table reports are good for

  • (A) Analyzing large amounts of data
  • (B) Turning tables upside down
  • (C) Breaking spreadsheet data into multiple worksheet
  • (D) None of above

A

Admin • 833K Points
Coach

Q. What did the first Table Analyzer do?

  • (A) Analyze the data in a set of flat files and automatically create a relational database system from that information
  • (B) Provide a graphic way to design relational databases
  • (C) Automate process of connecting tables to SQL Server
  • (D) None

A

Admin • 833K Points
Coach

Q. Which field allow to select items from drop down list?

  • (A) An OLE field
  • (B) A Memo Field
  • (C) A lookup Field
  • (D) A hyperlink field

A

Admin • 833K Points
Coach

Q. What is a Grouped Report?

  • (A) A type of report that can be generated by the Report Wizard
  • (B) A report that displays data that has been sorted in ascending or descending order
  • (C) A report that displays data grouped by fields you specify
  • (D) None

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.