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

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. Relational calculus is a

  • (A) Procedural language.
  • (B) Non- Procedural language.
  • (C) Data definition language.
  • (D) High level language

A

Admin • 833.24K Points
Coach

Q. In a relational database a referential integrity constraint can be specified with the help of

  • (A) primary key
  • (B) foreign key
  • (C) secondary key
  • (D) none of the above

A

Admin • 833.24K Points
Coach

Q. A super key is a set of one or more attributes that, taken collectively, allow us

  • (A) to identify uniquely an entity in the entity set
  • (B) to make the key most powerful for faster retrieval
  • (C) to increase effectiveness of database access
  • (D) none of the above

A

Admin • 833.24K Points
Coach

Q. 4NF is designed to cope with:

  • (A) Transitive dependency
  • (B) Join dependency
  • (C) Multi valued dependency
  • (D) None of these

A

Admin • 833.24K Points
Coach

Q. A relational database developer refers to a record as

  • (A) a criteria.
  • (B) a relation.
  • (C) a tuple.
  • (D) an attribute.

A

Admin • 833.24K Points
Coach

Q. The relational model feature is that there

  • (A) is no need for primary key data.
  • (B) is much more data independence than some other database models.
  • (C) are explicit relationships among records.
  • (D) are tables with many dimensions.

A

Admin • 833.24K Points
Coach

Q. SET concept is used in :

  • (A) Network Model
  • (B) Hierarchical Model
  • (C) Relational Model
  • (D) None of these

A

Admin • 833.24K Points
Coach

Q. Relational Algebra is

  • (A) Data Definition Language .
  • (B) Meta Language
  • (C) Procedural query Language
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. _____ Minimises the memory requirement for concurrent media streams.

  • (A) Active buffer allocation
  • (B) Passive buffer allocation
  • (C) Dynamic buffer allocation
  • (D) Static buffer allocation

A

Admin • 833.24K Points
Coach

Q. The financial function of the temporal database includes

  • (A) Portfolio organisation
  • (B) Banking
  • (C) Accounting
  • (D) All of the above

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.