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

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. If we want to retain all duplicates, we must write in place of union.

  • (A) union all
  • (B) union some
  • (C) intersect all
  • (D) intersect some

A

Admin • 833.24K Points
Coach

Q. The number of attributes in relation is called as its

  • (A) cardinality
  • (B) degree
  • (C) tuples
  • (D) entity

A

Admin • 833.24K Points
Coach

Q. clause is an additional filter that is applied to the result.

  • (A) select
  • (B) group-by
  • (C) having
  • (D) order by

A

Admin • 833.24K Points
Coach

Q. joins are SQL server default

  • (A) outer
  • (B) inner
  • (C) equi
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. The is essentially used to search for patterns in target string.

  • (A) like predicate
  • (B) null predicate
  • (C) in predicate
  • (D) out predicate

A

Admin • 833.24K Points
Coach

Q. A indicates an absent value that may exist but be unknown or that may not exist at all.

  • (A) empty tuple
  • (B) new value
  • (C) null value
  • (D) old value

A

Admin • 833.24K Points
Coach

Q. If the attribute phone number is included in the relation all the values need not be entered into the phone number column. This type of entry is given as

  • (A) 0
  • (B) –
  • (C) null
  • (D) empty space

A

Admin • 833.24K Points
Coach

Q. The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is false and unknown is while unknown and unknown is

  • (A) unknown, unknown, false
  • (B) true, false, unknown
  • (C) true, unknown, unknown
  • (D) unknown, false, unknown

A

Admin • 833.24K Points
Coach

Q. Using the clause retains only one copy of such identical tuples.

  • (A) null
  • (B) unique
  • (C) not null
  • (D) distinct

A

Admin • 833.24K Points
Coach

Q. The primary key must be

  • (A) unique
  • (B) not null
  • (C) both unique and not null
  • (D) either unique or not null

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.