1. A data dictionary is a special file that contains?
(1) the data types of all fields in all files
(2) the names of all fields in all files
(3) the widths of all fields in all files
(4) All of above
(5) None of above
Q.2. A command that lets you change one or more fields of a record is?
(1) Insert
(2) Modify
(3) Look-up
(4) All of above
(5) None of above
Q.3. In a large DBMS?
(1) Each user can see only a small part of the entire database
(2) Each user can access every sub schema
(3) Each sub schema contains every field in the logical schema
(4) All of above
(5) None of above
Q.4. It is better to use files than a DBMS when there are _______ .
(1) Stringent real-time requirements
(2) Multiple users who wish to access the data
(3) Complex relationships among data
(4) All of the above
(5) None of these
Q.5. The conceptual model is _______ .
(1) dependent on hardware
(2) dependent on software
(3) dependent on both hardware and software
(4) independent of both hardware and software
(5) None of these
Q.6. What is a relationship called when it is maintained between two entities?
(1) Unary
(2) Binary
(3) Ternary
(4) Quaternary
(5) 1 and 2
Q.7. Which of the following operation is used if we are interested in only certain columns of a table?
(1) PROJECTION
(2) SELECTION
(3) UNION
(4) JOIN
(5) Intersect
Q.8. Which of the following is a valid SQL type?
(1) CHARACTER
(2) NUMERIC
(3) FLOAT
(4) DATE
(5) All of the above
Q.9. The RDBMS terminology for a row is _______?
(1) Tuple
(2) Relation
(3) Attribute
(4) Degree
(5) Field
Q.10. Which of the following operations need the participating relations to be union compatible?
(1) UNION
(2) INTERSECTION0
(3) DIFFERENCE
(4) All of the above
(5) None of these
ANSWERS
Q.1. (4) the data types of all fields in all files, the names of all fields in all files and the widths of all fields in all files
Q.2. (2) Modify
Q.3. (1) Each user can see only a small part of the entire database.
Q.4. (2) Multiple users who wish to access the data
Q.5. (4) Independent of both hardware and sofware.
Q.6. (2) Binary
Q.7. (1) Projection operation is used if we are interested in only certain columns of a table.
Q.8. (5) All are valid SQL data type.
Q.9. (1) The RDBMS terminology for a row is Tuple.
Q.10. (4) Union, Intersection and d