1.
ORDER_TOTAL is a column in the orders table with the data type and size as number(8, 2) Examine the following code:
Which statement is correct about the above code?
2.
Which statement is true about triggers on data definition language (DDL) statements?
3.
In which of the following scenarios would you recommend using associative arrays?
4.
Examine the following code:
Which statement is true about the execution of the above code?
5.
You create the following table and execute the following code:
Which statement is true about the outcome of the above code?
6.
Examine the following code that you plan to execute: What correction should be performed in the above code?
7.
Examine the following command:
SQL>ALTER SESSION
SET plsql_warnings *
'enable:severe',
'enable:performance',
'ERROR:05003';
What is the implication of the above command?
8.
What is the correct definition of the persistent state of a packaged variable?
9.
Which statements are true about PL/SQL procedures? (Choose all that apply.)
10.
Examine the following block of code:
Which line in the above code would result in errors upon execution?