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