-
Exceptions
What do yo mean by exceptions? How many type of predefined exceptions are there & What are they?
-
Force View
What do you mean by Force View?
-
ROW_NUMBER(), RANK(), DENSE_RANK()
What do you mean by ROW_NUMBER(), RANK(), DENSE_RANK() differentiate them?
-
Privileges Granted & Privileges Obtained
Which system tables contain information on privileges granted & privileges obtained?
-
-
SQL Commands to Manipulate Oracle Database Structures
Which is the subset of SQL commands used to manipulate Oracle database structures, including tables?
-
SQL Buffer
Which command displays the SQL command in the SQL buffer, and then executes it?