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

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 is a procedural extension of Oracle- SQL that offers language constructs similar tothose in imperative programming languages?

  • (A) PQL
  • (B) Advanced SQL
  • (C) PL/SQL
  • (D) SQL

A

Admin • 833.24K Points
Coach

Q. Which of the following retains duplicate rows in the result of a query or in an Aggregate expression?

  • (A) ALL
  • (B) DISTINCT
  • (C) PRIOR
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. Which of the following is an aggregate function in SQL?

  • (A) Union
  • (B) Like
  • (C) Group By
  • (D) Max

A

Admin • 833.24K Points
Coach

Q. Which command is used to add a column to an existing table?

  • (A) Create
  • (B) Update
  • (C) Alter
  • (D) None of these

A

Admin • 833.24K Points
Coach

Q. A deadlock exists in the system if and only if the wait for graph:

  • (A) has a cycle in it
  • (B) has a path from first node to last node
  • (C) is a tree
  • (D) none of the above

A

Admin • 833.24K Points
Coach

Q. Rollback of transactions is normally used to:

  • (A) recover from transaction failure
  • (B) update the transaction
  • (C) retrieve old records
  • (D) repeat a transaction

A

Admin • 833.24K Points
Coach

Q. The DBMS language component which can be embedded in a program is

  • (A) The data definition language (DDL).
  • (B) The data manipulation language (DML).
  • (C) The database administrator (DBA).
  • (D) A query language

A

Admin • 833.24K Points
Coach

Q. The statement in SQL which allows to change the definition of a table is

  • (A) Alter.
  • (B) Update.
  • (C) Create.
  • (D) select.

A

Admin • 833.24K Points
Coach

Q. A DBMS query language is designed to

  • (A) support end users who use English-like commands.
  • (B) support in the development of complex applications software.
  • (C) specify the structure of a database.
  • (D) all of the above.

A

Admin • 833.24K Points
Coach

Q. Which of the following is correct

  • (A) a SQL query automatically eliminates duplicates.
  • (B) SQL permits attribute names to be repeated in the same relation.
  • (C) a SQL query will not work if there are no indexes on the relations
  • (D) None of these

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.