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

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 of the following is NOT an Oracle- supported trigger?

  • (A) before
  • (B) during
  • (C) after
  • (D) instead of

A

Admin • 833.24K Points
Coach

Q. What are the different in triggers?

  • (A) define, create
  • (B) drop, comment
  • (C) insert, update, delete
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. Triggers enabled or disabled

  • (A) can be
  • (B) cannot be
  • (C) ought to be
  • (D) always

A

Admin • 833.24K Points
Coach

Q. Which prefixes are available to Oracle triggers?

  • (A) : new only
  • (B) : old only
  • (C) both :new and : old
  • (D) neither :new nor : old

A

Admin • 833.24K Points
Coach

Q. Any recursive view must be defined as the union of two subqueries: a query that is nonrecursive and a query.

  • (A) base, recursive
  • (B) recursive, base
  • (C) base, redundant
  • (D) view, base

A

Admin • 833.24K Points
Coach

Q. Ranking of queries is done by which of the following?

  • (A) group by
  • (B) order by
  • (C) having
  • (D) both group by and order by

A

Admin • 833.24K Points
Coach

Q. In rank() function if one value is shared by two tuples then

  • (A) the rank order continues as counting numbers
  • (B) the rank order continues by leaving one rank in the middle
  • (C) the user specifies the order
  • (D) the order does not change

A

Admin • 833.24K Points
Coach

Q. The function that does not create gaps in the ordering.

  • (A) intense_rank()
  • (B) continue_rank()
  • (C) default_rank()
  • (D) dense_rank()

A

Admin • 833.24K Points
Coach

Q. If there are n tuples in the partition and the rank of the tuple is r, then its is defined as (r −1)/(n−1).

  • (A) ntil()
  • (B) cum_rank
  • (C) percent_rank
  • (D) rank()

A

Admin • 833.24K Points
Coach

Q. Inorder to simplify the null value confusion in the rank function we can specify

  • (A) not null
  • (B) nulls last
  • (C) nulls first
  • (D) either nulls last or first

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.