DBMS MCQs

 1) The collection of data, usually referred to as the _____________.

A)storage B)knowledge C)information D) database

Correct Ans: database

2) _____________ is the processing of data to draw conclusions, and infer rules or decision procedures.

A)data analytics B)online transaction processing C)data loading D) data processing

Correct Ans: data analytics

3) The ____________ uses a collection of tables to represent both data and the relationships among those data.

A)Entity-Relationship Model B) relational model C) Semi-structured Data Model D) Object-Based Data Model

Correct Ans: relational model

4) In the _____________, the designer maps the high-level conceptual schema onto the implementation data model of the database system that will be used.

A) logical-design phase B) physical-design phase C) normalization D) conceptual-design phase

Correct Ans: logical-design phase

5) A __________ is a language that enables users to access or manipulate data as organized by the appropriate data model.

A) data-manipulation language B) SQL C) JQuery D) Data Defination Language

Correct Ans: data-manipulation language

6) __________ which manages the allocation of space on disk storage and the data

structures used to represent information stored on disk.

A) integrity manager B) Transaction manager C) File manager D) Buffer manager

Correct Ans: File manager

7) _____________, which executes low-level instructions generated by the DML compiler.

A) Query evaluation engine B) DDL interpreter C) query optimization D) DML Interpreter

Correct Ans: Query evaluation engine

8) A relational database consists of a collection of ___________.

A) tables B) Forms C) files D) Folders

Correct Ans: tables

9) The __________ value is a special value that signifies that the value is unknown or does not exist. 

A)atomic B)domain C) null D) none of these

Correct Ans: null

10) The intersection operation, denoted by _________.

A) ∩ B) − C) ∪ D) $

Correct Ans: ∩

11) An __________ is a set of entities of the same type that share the same properties,

or attributes.

A) extension B) entity set C)attributes D) value

Correct Ans: entity set

12) The select, project, and rename operations, are called _________ operations.

A) unary B) binary C) relational D) None of these

Correct Ans: unary

13) ___________ constraints ensure that changes made to the database by authorized users

do not result in a loss of data consistency.

A) consistency B)security C) Integrity D) domain

Correct Ans: Integrity

14) To define a view in SQL by using the _________ view command.

A) select B) form C) join D) create

Correct Ans: create

15) The method for designing a relational database is to use a process commonly

known as ___________.

A) normalization B) conventions C) functional dependencies D) Decomposition

Correct Ans: normalization

16) Tuples with the same value on all attributes in the ____________ clause are placed in one group.

A)select B) form C) group by D) where

Correct Ans: group by

17) ____________ is nothing but execution of a transaction in isolation preserves the consistency of the database.

A) Atomicity B) Consistency C) Isolation D) Durability

Correct Ans: Consistency

18) A transaction may obtain locks, but may not release any lock in ___________.

A) growing phase B) shrinking phase C) locking protocol D) legal phase

Correct Ans: growing phase

19) PL/SQL controls the context area through a ____________.

A)procedures B) cursor C)  functions D) Records

Correct Ans: cursor

20) ___________ are stored programs, which are automatically executed or fired when some events occur. 

A) packages B) collections C) Triggers D) transactions

Correct Ans: Triggers