DATABASE MANAGEMENT SYSTEM MCQS Questions with Detailed Verified Answers for Accuracy

ACCURACY IS GUARANTEED


DATABASE MANAGEMENT SYSTEM MCQS
Questions with Detailed Verified Answers for
Accuracy
DBMS is a collection of .............. that enables user to create and
maintain a database.


A) Keys B) Translators C) Program D) Language Activity

✓✓ programs


In a relational schema, each tuple is divided into fields called


A) Relations B) Domains C) Queries D) All of the above

✓✓ domains


In an ER model, ................ is described in the database by
storing its data.


A) Entity B) Attribute C) Relationship D) Notation

✓✓ entity


DFD stands for


A) Data Flow Document B) Data File Diagram C) Data Flow
Diagram D) None of the above

, ACCURACY IS GUARANTEED

✓✓ data flow diagram


A top-to-bottom relationship among the items in a database is
established by a


A) Hierarchical schema B) Network schema C) Relational
Schema D) All of the above

✓✓ hierarchical schema


.................. table store information about database or about the
system.


A) SQL B) Nested C) System D) None of these

✓✓ system


..............defines the structure of a relation which consists of a
fixed set of attribute-domain pairs.


A) Instance B) Schema C) Program D) Super Key

✓✓ schema


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


A) Select B) Group-by C) Having D) Order by