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

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. Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively
(again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in the
result of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?

  • (A) m = min(r,s)
  • (B) 0 <= m <= r + s
  • (C) min(r,s) <= m <= max(r,s)
  • (D) 0 <= m <= min(r,s)

A

Admin • 833.24K Points
Coach

Q. Which of the following is not a key?

  • (A) A
  • (B) E
  • (C) B, C
  • (D) D

A

Admin • 833.24K Points
Coach

Q. If a relation is in BCNF, then it is also in

  • (A) 1 NF
  • (B) 2 NF
  • (C) 3 NF
  • (D) All of the above

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. Data Manipulation Language enables users to

  • (A) retrieval of information stored in database
  • (B) deletion of information from the database
  • (C) all of the above
  • (D) insertion of new information into the database

A

Admin • 833.24K Points
Coach

Q. Which of the following is not an Schema?

  • (A) logical schema
  • (B) critical schema
  • (C) database schema
  • (D) physical schema

A

Admin • 833.24K Points
Coach

Q. Which of the following is Database Language?

  • (A) all of the options
  • (B) query language
  • (C) data definition language
  • (D) data manipulation language

A

Admin • 833.24K Points
Coach

Q. Which of the following in not a function of DBA?

  • (A) authorization for data access
  • (B) network maintenance
  • (C) routine maintenance
  • (D) schema definition

A

Admin • 833.24K Points
Coach

Q. Which of the following is a Data Model?

  • (A) object-based data model
  • (B) all of the options
  • (C) entity-relationship model
  • (D) relational data model

A

Admin • 833.24K Points
Coach

Q. Column header is refer as

  • (A) table
  • (B) domain
  • (C) attributes
  • (D) relation

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.