cdac end module data base technologies practice questions -page

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 ?