1. It is better to use files than a DBMS when there are
a) Stringent real-time requirements
b) Multiple users wish to access the data
c) Complex relationships among data
d) All of the above
2. The conceptual model is:
a) dependent on hardware
b) dependent on software
c) dependent on both hardware and software
d) independent of both hardware and software
3. Which of the following operation is used if we are interested in only certain columns of a table?
a) Projection
b) Selection
c) Union
d) Join
4. What is a relationship called when it is maintained between two entities?
a) Unary
b) Binary
c) Ternary
d) Quaternary
5. Which of the following is a valid SQL type?
a) CHARACTER
b) NUMERIC
c) FLOAT
d) All of the above
6. The RDBMS terminology for a row is
a) tuple
b) relation
c) attribute
d) degree
7. Which of the following operations need the participating relations to be union compatible?
a) UNION
b) INTERSECTION
c) DIFFERENCE
d) All of the above
8. Which of the following is an advantage of view?
a) Data Security
b) Derived columns
c) Hiding of complex queries
d) All of the above
9. The full form of DDL is
a) Dynamic Data Language
b) Detailed Data Language
c) Data Definition Language
d) Data Derivation Language
10. Which of the following is a legal expression in SQL?
a) SELECT NULL FROM EMPLOYEE;
b) SELECT NAME FROM EMPLOYEE;
c) SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
d) None of the above