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

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. Which one of the following is the easiest to use?

  • (A) ORDBMS
  • (B) OODBMS
  • (C) RDBMS
  • (D) DBMS

A

Admin • 833.24K Points
Coach

Q. The _______ is such a structure. It is a template index structure based on B+ trees, which allows most of the tree index

  • (A) Generalised Binary Search Tree
  • (B) Generalised Search Tree
  • (C) Generalised AVL Search Tree
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. Which linking is available in various types of ORDBMS?

  • (A) Dynamic linking
  • (B) Refresh linking
  • (C) Static linking
  • (D) Pure linking

A

Admin • 833.24K Points
Coach

Q. Which of the following is the application package for Informix Universal Server?

  • (A) Extenders
  • (B) Data blades
  • (C) Data cartridge
  • (D) Blade Smith

A

Admin • 833.24K Points
Coach

Q. __________ language defines how to formulate a database schema (the structure of a database).

  • (A) Object definition
  • (B) Access Method
  • (C) Nested relation
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. In access, the best types of queries to use for data analysis are:

  • (A) Select querie
  • (B) Parameter queries
  • (C) Action queries
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. A set of programs that handle firm’s data base responsibilities is called a

  • (A) Database Management System (DBMS)
  • (B) Database Processing System (DBPS)
  • (C) Data Management System (DMS)
  • (D) All of above

A

Admin • 833.24K Points
Coach

Q. What happens when you add the asterisk (() from any field list ot a query?

  • (A) The table will not include any fields from the table
  • (B) The query sorts the table’s record in the order you specify
  • (C) The query will include every field from the table*
  • (D) The query uses the records from the table without displaying them

A

Admin • 833.24K Points
Coach

Q. A command that lets you cange one or more fields in a record is

  • (A) Insert
  • (B) Modify
  • (C) Look up
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. Customers, Orders. What’s their best relationship?

  • (A) Many-to-many
  • (B) One-to-one
  • (C) One-to-many
  • (D) All 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