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

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. What’s the best Access object for an invoice you’ll mail to customers?

  • (A) A report
  • (B) A form
  • (C) A table
  • (D) All of the above

A

Admin • 828.03K Points
Coach

Q. The largest unit of a database is

  • (A) A record
  • (B) A field
  • (C) A subfield
  • (D) None of above

A

Admin • 828.03K Points
Coach

Q. What is the primary difference between a pivot table report and a cross tab query?

  • (A) A pivot table report can contain sums, counts, and averages while a cross tab query cannot.
  • (B) You can’t pivot a cross tab query
  • (C) A cross tab query lets you group similar items. A pitot table report does not
  • (D) None of above

A

Admin • 828.03K Points
Coach

Q. Need to see all the information from two tables on one form. Insert

  • (A) A page break
  • (B) A subform
  • (C) A linked command button
  • (D) None of the above

A

Admin • 828.03K Points
Coach

Q. COUNT command is used to

  • (A) Count the number of data fields in an active database file
  • (B) Count the number of data files which are active
  • (C) Count the records which are updated
  • (D) Count the number of records in an active database file

A

Admin • 828.03K Points
Coach

Q. What is the term to ask the computer to pt information in order numerically or alphabetically ?

  • (A) Crop
  • (B) Report
  • (C) Sort
  • (D) Organize

A

Admin • 828.03K Points
Coach

Q. The raw facts are called

  • (A) Data
  • (B) Programs
  • (C) Commands
  • (D) Responses

A

Admin • 828.03K Points
Coach

Q. The term refers to a collection of related information

  • (A) Database
  • (B) List
  • (C) Outline
  • (D) Record

A

Admin • 828.03K Points
Coach

Q. A form that is used to collect data in a structured manner for entry to a database is called a

  • (A) Database deign form
  • (B) Systems flowchart
  • (C) Data capture form
  • (D) None of above

A

Admin • 828.03K Points
Coach

Q. The following command is used for inserting records

  • (A) INSERT
  • (B) ADD
  • (C) Both of the above
  • (D) None of the above