Oracle
Indexes
Public synonyms
Tables,
Triggers
A. TRUE
B. FALSE
In
Outin
Out
Inout
True
False
True
False
User defined exception
Pre defined exception
Try
Catch
A. A triggering event or statement b. Open trigger c. A trigger restriction d. A trigger action e. Close trigger a. A triggering event or statement b. Open trigger c. A trigger restriction d. A trigger action e. Close trigger A triggering event or statement
Open trigger
A trigger restriction
A trigger action
Close trigger
12
11
13
One
Two
Three
Four
True
False
Yes, by adding datafiles to it.
No, It is impossible
Yes, by using alter command
Yes, by using update command
Easy maintenance
Improved data security and integrity
Improved performance
Improved code clarity
Improved speed
Improves efficiency
A. Row level
B. Statement level
C. Column level
Before insert
Insert before
After Insert
Before update
A. Procedures
B. Triggers
C. Functions
D. Cursor
Declare the cursor
Open the cursor
Fetch the results into PL/SQL variables
Close the cursor
Execute the cursor
Delete the cursor
Immediate execute
Execute immediate
Execute
Execute later
Static SQL
Dynamic SQL
PL/SQL
Oracle 10g
Export
Execute
Import
Sql loader
DDL commands
%isopen
%open
%isclose
Isopen
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.