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

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. What is the corresponding text for the <#1/1/ 95# validation rule setting?

  • (A) Neter a value less or more than 1,195
  • (B) Value must be less than 95 characters
  • (C) Enter a date before 1995
  • (D) All of above

A

Admin • 833.24K Points
Coach

Q. What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library’s available objects and members?

  • (A) Object Viewer
  • (B) Object Browser
  • (C) Type Library Spy
  • (D) None of above

A

Admin • 833.24K Points
Coach

Q. Which of the following is not a data type ?

  • (A) Picture/graphic
  • (B) Data/time
  • (C) Text
  • (D) Number

A

Admin • 833.24K Points
Coach

Q. In a relational schema, each tuple is dividedinto fields called

  • (A) Relations
  • (B) Domains
  • (C) Queries
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. How do you filter by selection?

  • (A) Right click the field value and select filter by selection from the shortcut menu
  • (B) Find and double click the value on which you want to base the filter
  • (C) Find and select the value on which you want to base the filter and select tools>filter by selection from the menu
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. What is a fast way to adjust the width of a column?

  • (A) Right click the left side of the column heading
  • (B) Double click the left side of the column heading
  • (C) Double click the right side of the column heading
  • (D) Select tools>adjust column width from the menu

A

Admin • 833.24K Points
Coach

Q. A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As

  • (A) Tables
  • (B) Relations
  • (C) Tuple
  • (D) Both (A) and (B)

A

Admin • 833.24K Points
Coach

Q. If a piece of data is stored in two places in the database, then a

  • (A) Storage space is wasted
  • (B) Changing the data is one spot will cause data inconsistency
  • (C) It can be more easily accessed
  • (D) Both (A) and (B)

A

Admin • 833.24K Points
Coach

Q. Which action will optimize your databaseperformance?

  • (A) Set the record set type to Snapshot
  • (B) Use the compact and repair database tool
  • (C) Create a replica of the database
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. How can you add a table to the relationship window?

  • (A) Select Tools>Add table from the menu
  • (B) Select the table from the table list on the toolbar
  • (C) Click the show table button on the toolbar
  • (D) Select Edit>Add table from the menu

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.