SQL Quiz

1. View used used for displaying current status of database is ___________

system.databases
current.databases
sys.databases
status.databases

2. Can we create temporary tables inside stored procedure?

Yes
No
We can create only under certain conditions
None of the above

3. Which statement would add a column CGPA to a table Student which is already created

ALTER TABLE Student ADD COLUMN (CGPA NUMBER(3,1));
ALTER TABLE Student CGPA NUMBER(3,1);
ALTER TABLE Student ADD (CGPA NUMBER(3,1));
Both A and C

4. A relational database consists of a collection of

Table
Record
Fields
Attributes

5. If the referential integrity constraint is violated then the specific action clause attached by the database designers other than by default action is classified as

referential triggered action
foreign key triggered action
primary key triggered action
decimal triggered action

6. Which requirements can be implemented using a CHECK constraint?

Customer must have a name
Two customers cannot have same email id
Both A and B
None of the above

7. A functional dependency is a relationship between or among

Entities
Rows
Attributes
Tables

8. Which of the following exception raised when an arithmetic, conversion, truncation, or sizeconstraint error occurs?

ZERO_DIVIDE
VALUE_ERROR
TOO_MANY_ROWS
SELF_IS_NULL

9. Select * from student join takes using (ID); The above query is equivalent to ____________

Select * from student inner join takes using (ID);
Select * from student outer join takes using (ID);
Select * from student left outer join takes using (ID);
All of the mentioned

10. Independent sub query is the one where

the inner and the outer query are from two different tables
the inner query has no reference to the outer query
the inner and outer queries are for the same table but with different condition
None of the above