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
Discussion
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
Discussion
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
Discussion
4. What is a relationship called when it is maintained between two entities?
a) Unary
b) Binary
c) Ternary
d) Quaternary
Discussion
5. Which of the following is a valid SQL type?
a) CHARACTER
b) NUMERIC
c) FLOAT
d) All of the above
Discussion
6. The RDBMS terminology for a row is
a) tuple
b) relation
c) attribute
d) degree
Discussion
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
Discussion
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
Discussion
9. The full form of DDL is
a) Dynamic Data Language
b) Detailed Data Language
c) Data Definition Language
d) Data Derivation Language
Discussion
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
Discussion