CDAC 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 WHERE A.no=B.no(+) 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
All Categories