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

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. The provides a set of operations that take one or more relations as input and return a relation as an output.

  • (A) schematic representation
  • (B) relational algebra
  • (C) scheme diagram
  • (D) relation flow

A

Admin • 833.24K Points
Coach

Q. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?

  • (A) dml(data manipulation langauge)
  • (B) ddl(data definition langauge)
  • (C) query
  • (D) relational schema

A

Admin • 833.24K Points
Coach

Q. To remove a relation from an SQL database, we use the command.

  • (A) delete
  • (B) purge
  • (C) remove
  • (D) drop table

A

Admin • 833.24K Points
Coach

Q. Updates that violate are disallowed.

  • (A) integrity constraints
  • (B) transaction control
  • (C) authorization
  • (D) ddl constraints

A

Admin • 833.24K Points
Coach

Q. The clause allows us to select only those rows in the result relation of the clause that satisfy a specified predicate.

  • (A) where, from
  • (B) from, select
  • (C) select, from
  • (D) from, where

A

Admin • 833.24K Points
Coach

Q. The clause is used to list the attributes desired in the result of a query.

  • (A) where
  • (B) select
  • (C) from
  • (D) distinct

A

Admin • 833.24K Points
Coach

Q. Which of the following statements contains an error?

  • (A) select * from emp where empid = 10003;
  • (B) select empid from emp where empid = 10006;
  • (C) select empid from emp;
  • (D) select empid where empid = 1009 and lastname = ‘geller’;

A

Admin • 833.24K Points
Coach

Q. In SQL the spaces at the end of the string are removed by function.

  • (A) upper
  • (B) string
  • (C) trim
  • (D) lower

A

Admin • 833.24K Points
Coach

Q. The union operation is represented by

  • (A) ∩
  • (B) u
  • (C) –
  • (D) *

A

Admin • 833.24K Points
Coach

Q. The intersection operator is used to get the tuples.

  • (A) different
  • (B) common
  • (C) all
  • (D) repeating

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.