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?
Answer : both b and c.
2. Consider the following where clause WHERE A.no=B.no(+) The above outer join lists
Answer : All matching and non-matching rows of table A.
3. Level of Abstraction,describes what data are stored in database and what relationship among these data
Answer : Logical.
4. The limit of level of nesting is _________ subqueries in SQL
Answer : 255.
5. Which of the following operation cannot be performed on VIEWS defined from Multiple Tables(which have been created with referencing clause)
Answer : INSERT.
6. A Sub-Query can not have a _______ clause and a ________ of selects
Answer : orderby,For update.
7. Raw data type can store maximum up to
Answer : 255 bytes.
8. Words used in PL/SQL block are called_______
Answer : Lexical Units.
9. A ________ can be used to provide a surrogate key in a table that doesnot have a primary key of its own.
Answer : sequence.
10. __________ is used for error trapping in PL/SQL blocks
Answer : Exception section.