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

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. How many tables may be included with a join?

  • (A) one
  • (B) two
  • (C) three
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. Which are the join types in join condition:

  • (A) cross join
  • (B) natural join
  • (C) join with using clause
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. How many join types in join condition:

  • (A) 2
  • (B) 3
  • (C) 4
  • (D) 5

A

Admin • 833.24K Points
Coach

Q. The operation which is not considered a basic operation of relational algebra is

  • (A) join
  • (B) selection
  • (C) union
  • (D) cross product

A

Admin • 833.24K Points
Coach

Q. In SQL the statement select * from R, S is equivalent to

  • (A) select * from r natural join s
  • (B) select * from r cross join s
  • (C) select * from r union join s
  • (D) select * from r inner join s

A

Admin • 833.24K Points
Coach

Q. Which of the following creates a virtual relation for storing the query?

  • (A) function
  • (B) view
  • (C) procedure
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. Materialised views make sure that

  • (A) view definition is kept stable
  • (B) view definition is kept up-to-date
  • (C) view definition is verified for error
  • (D) view is deleted after specified time

A

Admin • 833.24K Points
Coach

Q. Updating the value of the view

  • (A) will affect the relation from which it is defined
  • (B) will not change the view definition
  • (C) will not affect the relation from which it is defined
  • (D) cannot determine

A

Admin • 833.24K Points
Coach

Q. Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause?

  • (A) with
  • (B) check
  • (C) with check
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. A consists of a sequence of query and/or update statements.

  • (A) transaction
  • (B) commit
  • (C) rollback
  • (D) flashback

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.