Q.1. 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
Q.2. 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
Q.3. Which database level is closest to the users?
(1) External
(2) Internal
(3) Physical
(4) Conceptual
(5) None of these
Q.4. Which are the two ways in which entities can participate in a relationship?
(1) Passive and active
(2) Total and partial
(3) Simple and Complex
(4) All of the above
(5) None of these
Q.5. The result of the UNION operation between R1 and R2 is a relation that includes _______.
(1) All the tuples of R1
(2) All the tuples of R2
(3) All the tuples of R1 and R2
(4) All the tuples of R1 and R2 which have common columns
(5) None of these
Q.6. Which of the following option appropriate is a comparison operator in SQL?
(1) =
(2) LIKE
(3) BETWEEN
(4) All of the above
(5) None of these
Q.7. ________ is a process when relation between two entity is treated as a single entity.
(1) Normalization
(2) Aggregation
(3) Generalization
(4) Specialization
(5) Simplification
Q.8. In an ER Diagram, ellipse with underlying lines is used to represent _________?
(1) attribute
(2) Key attribute
(3) Composite attribute
(4) Multivalued attribute
(5) Entity
Q.9. _________ constraint is used to restrict actions that would destroy links between tables?
(1) Primary key
(2) Foreign Key
(3) Check
(4) Not Null
(5) Unique
Q.10. In a table of data base, degree refers-
(1) total numer of row
(2) row in a table
(3) column in a table
(4) total number of column in a table
(5) none of these
ANSWERS
Q.1. (3) DDL stands for Data Definition Language.
Q.2. (4) All are advantages of view.
Q.3. (1) External database level is closest to the users.
Q.4. (2) Total and partial.
Q.5. (4) All the tuples of R1 and R2 which have common columns.
Q.6. (4) =, Like and Between are comparison operators in SQL.
Q.7. (2) Aggregation is a process when relation between two entities is treated as a single entity.
Q.8. (2) In an ER Diagram, ellipse with underlying lines is used to represent Key attribute.
Q.9. (2) Foreign Key constraint is used to restrict actions that would destroy links between tables.
Q.10. (4) Total mumber of column
