Set - 7

Question 16 :

What are the datatypes supported By oracle (INTERNAL)?

Answer :

Varchar2, Number,Char , MLSLABEL.


Question 17 :

What are attributes of cursor?

Answer :

%FOUND , %NOTFOUND , %ISOPEN,%ROWCOUNT


Question 18 :

Can you use select in FROM clause of SQL select ?

Answer :

Yes.


Question 19 :

Which trigger are created when master -detail relay?

Answer :

master delete property
* NON-ISOLATED (default)
a) on check delete master
b) on clear details
c) on populate details
* ISOLATED
a) on clear details
b) on populate details
* CASCADE
a) per-delete
b) on clear details
c) on populate details


Question 20 :

which system variables can be set by users?

Answer :

SYSTEM.MESSAGE_LEVEL
SYSTEM.DATE_THRESHOLD
SYSTEM.EFFECTIVE_DATE
SYSTEM.SUPPRESS_WORKING