1. UPDATE OR DELETE ON SOCCER_FAN_SNACKS. Which two of the following keywords may be useful in your trigger source code to distinguish what should run, and when?

A. truncating 

B. updating 

C. deleting 

D. both b and c 

2. Consider the following where clause
WHERE A.no=B.no(+)
The above outer join lists

A. All matching and non-matching rows of table B 

B. All matching and non-matching rows of table A 

C. All non-matching rows of table B 

D. All non-matching rows of table A 

3. Level of Abstraction,describes what data are stored in database and what relationship among these data

A. Physical 

B. Logical 

C. View 

D. None of the above 

4. The limit of level of nesting is _________ subqueries in SQL

A. 255 

B. 1024 

C. 1000 

D. 2000 

5. Which of the following operation cannot be performed on VIEWS defined from Multiple Tables(which have been created with referencing clause)

A. INSERT 

B. DELETE 

C. UPDATE 

D. MODIFY 

6. A Sub-Query can not have a _______ clause and a ________ of selects

A. groupby,For update 

B. orderby,having 

C. orderby,For update 

D. orderby,groupby 

7. Raw data type can store maximum up to

A. 1024 bytes 

B. 255 bytes 

C. 2 GB 

D. None of Above 

8. Words used in PL/SQL block are called_______

A. Lexical Units 

B. block units 

C. grammer 

D. none of these 

9. A ________ can be used to provide a surrogate key in a table that doesnot have a primary key of its own.

A. procedure 

B. sequence 

C. function 

D. reference key 

10. __________ is used for error trapping in PL/SQL blocks

A. Error handling section 

B. Exception_init() 

C. Exception section 

D. None 

• 1
• 2
• 3
• 4
• 5