Computer Quiz - 10

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

Ans. (2) Multiple users who wish to access the data.

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

Ans. (4) The conceptual model is independent of both hardware and software.

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 

Ans. (2) Binary is a relationship when it is maintained between two entities.

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

Ans. (1) Projection operation is used if we are interested in only certain columns of a table.

Q. 5. Which of the following is a valid SQL type?

(1) CHARACTER

(2) NUMERIC

(3) FLOAT

(4) DATE

(5) All of the above

Ans. (5) All are valid SQL data type.

Q. 6. The RDBMS terminology for a row is _______?

(1) Tuple

(2) Relation

(3) Attribute

(4) Degree

(5) Field

Ans. (1) The RDBMS terminology for a row is Tuple.

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

Ans. (4) Union, Intersection and difference

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

Ans. (3) DDL stands for Data Definition 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) None of these

Ans. (4) All are advantages of view.

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

Ans. (2) Dispatch scheduler is a legal expression in SQL.