What is the maximum no.of statements that can be specified in a trigger statement ?
One
Two
Three
Four
What is the maximum no of cascading triggers used at a time?
24
8
16
32
Which symbol preceeds the path to the table in the remote database ?
/
#
@
\
If all the values from a cursor have been fetched and another fetch is issued, the output will be :
Error
Last Record
First Record
Can't Say
Is Sysdate a system variable or a system function?
System Variable
System Function
Both A & B
None of the Above
How can you avoid indexes ?
Use FULL hint to optimizer for full table scan
Use INDEX or AND-EQUAL hint to optimizer to use one index or set to indexes instead of another.
Use an expression in the Where Clause of the SQL.
Disable Index on the column
The variables or expressions referenced in the parameter list of a subprogram call are Actual parameters?
True
False
The variables declared in a subprogram specification and referenced in the subprogram body are formal parameters?
If I have an execute privilege on a procedure in another users schema, can I execute his procedure even though I do not have privileges on the tables within the procedure ?
No
Yes
None of the above
Which of the following is not a feature of a cursor FOR loop?
Record type declaration.
Opening and parsing of SQL statements.
Fetches records from cursor.
Requires exit condition to be defined.