Q.1. Snapshot of the data in the database at a given instant of time is called _____.
(1) Database Schema
(2) Database Instance
(3) Database Snapshot
(4) All of the above
(5) None of these
Q.2. Which of the following is not Unary operation?
(1) Select
(2) Project
(3) Rename
(4) Union
(5) None of these
Q.3. Which of the following is not binary operation?
(1) Union
(2) Project
(3) Set Difference
(4) Cartesian Product
(5) None of these
Q.4. The raw facts and figures are:
(1) Program
(2) Information
(3) Snapshot
(4) Reports
(5) None of these
Q.5. A command to remove a relation from an SQL database is ____.
(1) Delete table
(2) Drop table
(3) Erase table
(4) Alter table
(5) None of these
Q.6. Entities having primary key are called?
(1) Primary Entities
(2) Strong Entities
(3) Weak Entities
(4) Primary Key
(5) None of these
Q.7. In the E-R diagrams, the term cardinality is a synonym for the term?
(1) Attribute
(2) Degree
(3) Entities
(4) Cartesian
(5) None of these
Q.8. TRUNCATE statement in SQL is a ____.
(1) DML statement
(2) DDL statement
(3) DCL statement
(4) TCL statement
(5) None of above
Q.9. The default date format in SQL is?
(1) DD-MON-YY
(2) DD-MM-YY
(3) DD-MM-YYY
(4) DD-MM-YYYY
(5) None of these
Q.10. For adding number of hours to a date, which of the following statement is used ?
(1) Date + Number
(2) Date + Number/24
(3) Date+Number of Hours
(4) Date +Hour/30
(5) None of above
ANSWERS
Q.1. (2) Snapshot of the data in the database at a given instant of time is called Database Instance.
Q.2. (4) Union is not Unary operation.
Q.3. (5) Project is not binary operation.
Q.4. (5) None of these
Q.5. (2) Drop table
Q.6. (2) Strong Entities
Q.7. (4) Cartesian
Q.8. (2) TRUNCATE statement in SQL removes all records from table, including all spaces allocated for the records are removed.
Q.9. (4) The default date format in SQL is DD-MM-YYYY.
Q.10. (2) Date + Number/24
