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

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 keyword is used to access attributes of preceding tables or subqueries in the from clause.

  • (A) in
  • (B) lateral
  • (C) having
  • (D) with

A

Admin • 833.24K Points
Coach

Q. Which of the following creates a temporary relation for the query on which it is defined?

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

A

Admin • 833.24K Points
Coach

Q. Subqueries cannot:

  • (A) use group by or group functions
  • (B) retrieve data from a table different from the one in the outer query
  • (C) join tables
  • (D) appear in select, update, delete, insert statements.

A

Admin • 833.24K Points
Coach

Q. Which of the following is not an aggregate function?

  • (A) avg
  • (B) sum
  • (C) with
  • (D) min

A

Admin • 833.24K Points
Coach

Q. The EXISTS keyword will be true if:

  • (A) any row in the subquery meets the condition only
  • (B) all rows in the subquery fail the condition only
  • (C) both of these two conditions are met
  • (D) neither of these two conditions is met

A

Admin • 833.24K Points
Coach

Q. How can you find rows that do not match some specified condition?

  • (A) exists
  • (B) double use of not exists
  • (C) not exists
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. Which one of the following deletes all the entries but keeps the structure of the relation.

  • (A) delete from r where p;
  • (B) delete from instructor where dept name= ’finance’;
  • (C) delete from instructor where salary between 13000 and 15000;
  • (D) delete from instructor;

A

Admin • 833.24K Points
Coach

Q. The problem of ordering the update in multiple updates is avoided using

  • (A) set
  • (B) where
  • (C) case
  • (D) when

A

Admin • 833.24K Points
Coach

Q. The condition allows a general predicate over the relations being joined.

  • (A) on
  • (B) using
  • (C) set
  • (D) where

A

Admin • 833.24K Points
Coach

Q. Which of the join operations do not preserve non matched tuples?

  • (A) left outer join
  • (B) right outer join
  • (C) inner join
  • (D) natural join

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.