Q.1. Choose the correct way to indicate that a line in a C++ program is a comment line, that is, a line the will not be executed as an instruction___.
(1) begin the line with a # sign
(2) begin the line with double slashes (/ /)
(3) begin and end the line with double hyphens (-_-)
(4) indent the line
(5) begin and end the line with double astrick (**)
Q. 2. Which of the following statements are TRUE about an SQL query?
An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause
An SQL query can contain a HAVING clause only if it has a GROUP BY clause
All attributes used in the GROUP BY clause must appear in the SELECT clause
Not all attributes used in the GROUP BY clause need to appear in the SELECT clause
(1) 1 and 3
(2) 1 and 4
(3) 2 and 3
(4) 2 and 4
(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 is a comparison operator in SQL?
(1) =
(2) LIKE
(3) BETWEEN
(4) All of the above
(5) Prefer
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 ER Diagram, relationship is represented using?
(1) Diamond
(2) Rectangle
(3) Eclipse
(4) Double rectangle
(5) Square
Q.9. 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.10. _________ 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
Answers
Q.1. (2) begin the line with double slashes (/ /)
Q.2. (2) 1 and 4
Q.3. (1) External database level is closest to the users.
Q.4. (2) Total and partial are the two ways in which entities can participate in a relationship.
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 diamond.
Q.9. (2). In an ER Diagram, ellipse with underlying lines is used to represent Key attribute.
Q.10. (2) Foreign Key constraint is used to restrict actions that would destroy links between tables.
