DOWNLOAD PDF
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.
(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.
(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.
(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.
(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.
(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.
(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
(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.
(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.
(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.
(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.
0 comments:
Post a Comment
[img]https://1.bp.blogspot.com/-aFPBR4LADew/V85_aRWKXkI/AAAAAAAAHAw/O_N9dmf5tMQu0kSfbC3NU2yCzkLVQV7eACLcB/s320/share.png[/img]