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

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

Q. In a large DBMS

  • (A) each user can “see” only a small part of the entire database
  • (B) each user can access every subschema
  • (C) each subschema contains every field in the logical schema
  • (D) none of the above is true

A

Admin • 833.24K Points
Coach

Q. When you save an Access project, what file format do you use?

  • (A) .adp
  • (B) .xm.
  • (C) .mdb
  • (D) All of above

A

Admin • 833.24K Points
Coach

Q. Which of the following criterion would find records whose personality field does not equal “Nice”?

  • (A) <>Nice
  • (B) NOT Nice
  • (C) <>”Nice”
  • (D) IS NOT Nice

A

Admin • 833.24K Points
Coach

Q. Which of the following fields would not make a suitable primary key ?

  • (A) A date field
  • (B) An invoice number
  • (C) An autoNumber field
  • (D) A customer’s social security number

A

Admin • 833.24K Points
Coach

Q. The data in a record is of the following types

  • (A) four text fields and three numeric fields
  • (B) two integer fields and five text fields
  • (C) three text fields and four numeric fields
  • (D) none of the above

A

Admin • 833.24K Points
Coach

Q. A treelike structure of records in a database. Select the best fit for answer

  • (A) Hierarchical database structure
  • (B) Relational database structure
  • (C) Multidimensional database structure
  • (D) Sequential database access

A

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

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

  • (A) Ctrl+’
  • (B) F6
  • (C) Ctrl+D
  • (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.