1.
In PL/SQL, which of these returns the actual error message of the last error that was thrown?
2.
What is the output of the following PL/SQL query:
select floor(5), floor(5.1), floor(-5) from dual;
3.
What is the output of the following PL/SQL query:
select coalesce(1, 2, 3), coalesce(null, 2, null, 5) from dual;
4.
What is the output of the following PL/SQL query:
select ltrim('database', 'da'), ltrim('2333222', '23') from dual;
5.
In PL/SQL, which of the following statements is used to end the transaction and make it permanent?
6.
In PL/SQL, which of the following statements is used to undo the changes made to the database?
7.
In PL/SQL, the most recent implicit cursor is known as the _____________ cursor.
8.
Which of the following is an exception in PL/SQL?
9.
Which of the following is a cursor exception in PL/SQL?
10.
Which of the following can not be run explicitly in PL/SQL?