Data Base Practice Questions
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?
2. Consider the following where clause
The above outer join lists
3. Level of Abstraction,describes what data are stored in database and what relationship among these data
4. The limit of level of nesting is _________ subqueries in SQL
5. Which of the following operation cannot be performed on VIEWS defined from Multiple Tables(which have been created with referencing clause)
6. A Sub-Query can not have a _______ clause and a ________ of selects
7. Raw data type can store maximum up to
8. Words used in PL/SQL block are called_______
9. A ________ can be used to provide a surrogate key in a table that doesnot have a primary key of its own.
10. __________ is used for error trapping in PL/SQL blocks
Learn More Multiple Choice Practice Questions