SQL Quiz

1. Which option in view is to ensure that all UPDATE and INSERTs satisfy the condition(s) in the view definition?

Uncheck
With Check
Check
With

2. TRUNCATE statement in SQL is a

DDL
DML
DCL
TCL

3. 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

4. When a referential-integrity constraint is violated, the normal procedure is to

Continue with flow
Accept the action
Reject the action
Store it for evaluation

5. What is the syntax for UNIQUE Indexes?

CREATE INDEX index_name ON table_name (column_name);
CREATE UNIQUE INDEX index_name on table_name (column_name);
CREATE INDEX UNIQUE index_name on table_name (column_name);
CREATE INDEX index_name on UNIQUE table_name (column_name);

6. An exception is an error condition during a program execution.

TRUE
FALSE
Can be true or false
Can not say

7. A data manipulation command the combines the records from one or more tables is called

SELECT
PROJECT
JOIN
PRODUCT

8. Which of the following statement(s) is/are FALSE about primary key?

There can be more than one primary key for a table
Columns with string data types cannot be made Primary Key because they are large
Both A and B
None of the above

9. Many current-generation database applications need to store photographs, or of the order megabytes and gigabytes using

Large-index type
Large-object type
Large-location type
Large-locator type

10. Trigger isn&aspo;t called recursively when?

If an INSTEAD OF trigger defined on a table runs a statement against the table that would ordinarily fire the INSTEAD OF trigger again
When an INSTEAD OF trigger defined on a view runs a statement against the view that would ordinarily fire the INSTEAD OF trigger again
Both A and B
None of the above