header1.html

Monday, 8 April 2013

DBMS Quiz-1


DBMS Quiz-1
1.The _______ is a set of programs to use and / or modify this data.
DBMS
System
Program
Software


2.The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.
Clustered
Hashed
Un-clustered
Collision


3.The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain


4.The middleware databases in which the business rules act are applicable to _______ tier architectures
Single
Three
Two
None


5.The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple.
Primary
Foreign
Candidate
Alternate


6.E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R


7.Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security


8. _____ database is used to provide statistical information or summaries of values based on various criteria.
Statistical
Mathematical
Normalized
Un normalized


9.The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.
Data Manipulation
Data Definition
Data Control
None


10.The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
OR
AND
NOT
ALL