DATABASE MANAGEMENT SYSTEM MCQS Questions with Correct Answers

1




DATABASE MANAGEMENT SYSTEM MCQS
Questions with Correct Answers for Specific
Exam Mail
DBMS is a collection of .............. that enables user to create and maintain a
database.




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

Ans: programs



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




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

Ans: domains



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




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

Ans: entity



DFD stands for




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




Pretest - Stuvia US

, 2


Ans: 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

Ans: hierarchical schema



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




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

Ans: 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

Ans: schema



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




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

Ans: having




Pretest - Stuvia US