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?





Show Answer ?

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





Show Answer ?

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





Show Answer ?

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





Show Answer ?

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





Show Answer ?

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





Show Answer ?

7. Raw data type can store maximum up to





Show Answer ?

8. Words used in PL/SQL block are called_______





Show Answer ?

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





Show Answer ?

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





Show Answer ?