Q.1. 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.2. 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.3. 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.4. 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.5. Which of the following is a valid SQL type?
(1) CHARACTER
(2) NUMERIC
(3) FLOAT
(4) DATE
(5) All of the above
Q.6. The RDBMS terminology for a row is _______?
(1) Tuple
(2) Relation
(3) Attribute
(4) Degree
(5) Field
Q.7. Which of the following operations need the participating relations to be union compatible?
(1) UNION (2) INTERSECTION (3) DIFFERENCE (4) All of the above (5) None of these
Q.8. The full form of DDL is _______?
(1) Dynamic Data Language
(2) Detailed Data Language
(3) Data Definition Language
(4) Data Derivation Language
(5) Data Dimensional Language
Q.9. Which of the following is an advantage of a View?
(1) Data security
(2) Derived columns
(3) Hiding of complex queries
(4) All of the above
(5) Dd
Q.10. Which of the following is a legal expression in SQL?
(1) admission scheduler
(2) dispatcher scheduler
(3) swapping scheduler
(4) process scheduler
(5) path scheduler
Answers
Q.1.(2) Multiple users who wish to access the data.
Q.2.(4) Independent of both hardware and software.
Q.3.(2) Binary
Q.4.(1) Projection operation
Q.5.(5) All of the above
Q.6.(1) Tuple
Q.7.(4) Union, Intersection and difference
Q.8.(3) Data Definition Language.
Q.9.(4) All are advantages of view.
Q.10.(2) dispatch scheduler
