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

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. The command such tables are available only within the transaction executing the query and are dropped when the transaction finishes.

  • (A) create table
  • (B) create temporary table
  • (C) create view
  • (D) create label view

A

Admin • 833.24K Points
Coach

Q. OLAP stands for

  • (A) online analytical processing
  • (B) online analysis processing
  • (C) online transaction processing
  • (D) online aggregate processing

A

Admin • 833.24K Points
Coach

Q. The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is

  • (A) slicing
  • (B) dicing
  • (C) pivoting
  • (D) both slicing and dicing

A

Admin • 833.24K Points
Coach

Q. The operation of moving from finer- granularity data to a coarser granularity (by means of aggregation) is called a

  • (A) rollup
  • (B) drill down
  • (C) dicing
  • (D) pivoting

A

Admin • 833.24K Points
Coach

Q. In SQL the cross-tabs are created using

  • (A) slice
  • (B) dice
  • (C) pivot
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. What do data warehouses support?

  • (A) olap
  • (B) oltp
  • (C) olap and oltp
  • (D) operational databases

A

Admin • 833.24K Points
Coach

Q. In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.

  • (A) A many-to-many relationship set
  • (B) A multivalued attribute of an entity set
  • (C) A one-to-many relationship set
  • (D) All of the mentioned

A

Admin • 833.24K Points
Coach

Q. Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by

  • (A) Unique-role assumption
  • (B) Unique-key assignment
  • (C) Role intergral assignment
  • (D) None of the mentioned

A

Admin • 833.24K Points
Coach

Q. Designers use which of the following to tune the performance of systems to support timecritical operations?

  • (A) Denormalization
  • (B) Redundant optimization
  • (C) Optimization
  • (D) Realization

A

Admin • 833.24K Points
Coach

Q. In the schema (dept name, size) we have relations total inst 2007, total inst 200Q:8) Which dependency have lead to this relation ?

  • (A) Dept name, year->size
  • (B) Year->size
  • (C) Dept name->size
  • (D) Size->year

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.