DATABASE MANAGEMENT SYSTEM MCQS(100%
Guaranteed)
DBMS is a collection of .............. that enables user to create and maintain a database.
A) Keys B) Translators C) Program D) Language Activity correct answers programs
In a relational schema, each tuple is divided into fields called
A) Relations B) Domains C) Queries D) All of the above correct answers domains
In an ER model, ................ is described in the database by storing its data.
A) Entity B) Attribute C) Relationship D) Notation correct answers entity
DFD stands for
A) Data Flow Document B) Data File Diagram C) Data Flow Diagram D) None of the above
correct answers 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 correct
answers hierarchical schema
.................. table store information about database or about the system.
A) SQL B) Nested C) System D) None of these correct answers 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 correct answers schema
.................. clause is an additional filter that is applied to the result.
A) Select B) Group-by C) Having D) Order by correct answers having
A logical schema
A) is the entire database B) is a standard way of organizing information into accessible parts. C)
Describes how data is actually stored on disk. D) All of the above correct answers is a standard
way of organizing information into accessible parts
..................... is a full form of SQL.
Guaranteed)
DBMS is a collection of .............. that enables user to create and maintain a database.
A) Keys B) Translators C) Program D) Language Activity correct answers programs
In a relational schema, each tuple is divided into fields called
A) Relations B) Domains C) Queries D) All of the above correct answers domains
In an ER model, ................ is described in the database by storing its data.
A) Entity B) Attribute C) Relationship D) Notation correct answers entity
DFD stands for
A) Data Flow Document B) Data File Diagram C) Data Flow Diagram D) None of the above
correct answers 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 correct
answers hierarchical schema
.................. table store information about database or about the system.
A) SQL B) Nested C) System D) None of these correct answers 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 correct answers schema
.................. clause is an additional filter that is applied to the result.
A) Select B) Group-by C) Having D) Order by correct answers having
A logical schema
A) is the entire database B) is a standard way of organizing information into accessible parts. C)
Describes how data is actually stored on disk. D) All of the above correct answers is a standard
way of organizing information into accessible parts
..................... is a full form of SQL.
