a) SELECT NULL FROM EMPLOYEE; b) SELECT NAME FROM EMPLOYEE; c) SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL; d) None ...
View QuestionThe full form of DDL is
a) Dynamic Data Language b) Detailed Data Language c) Data Definition Language d) Data Derivation Language Answer: ...
View QuestionWhich of the following is an advantage of view?
a) Data Security b) Derived columns c) Hiding of complex queries d) All of the above Answer: d
View QuestionWhich of the following operations need the participating relations to be union compatible?
a) UNION b) INTERSECTION c) DIFFERENCE d) All of the above Answer: d
View QuestionThe RDBMS terminology for a row is
a) tuple b) relation c) attribute d) degree Answer: a
View QuestionWhich of the following is a valid SQL type?
a) CHARACTER b) NUMERIC c) FLOAT d) All of the above Answer: d
View QuestionWhat is a relationship called when it is maintained between two entities?
a) Unary b) Binary c) Ternary d) Quaternary Answer: b
View QuestionWhich 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 Answer: a
View QuestionThe conceptual model is:
a) dependent on hardware b) dependent on software c) dependent on both hardware and software d) independent of both hardware ...
View QuestionIt 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
View Question