Data Base Practice Questions

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 ?