A. Statement triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.

B. A row trigger fires once even if no rows are affected.

C. A statement trigger fires once even if no rows are affected.

D. Row triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.

A. SCOTT's session shows the EMPNO 100, GREEN'S session shows EMPNO 100, and SCOTT's session shows the EMPNO 101.

B. SCOTT's session shows the EMPNO 100, GREEN'S session shows an error, and SCOTT's session shows an error.

C. SCOTT's session shows the EMPNO 100, GREEN'S session shows an error, and SCOTT's session shows the second EMPNO 101.

D. SCOTT's session shows the EMPNO 100, GREEN'S session shows EMPNO 101, and SCOTT's session shows the second EMPNO 102.

A. It gives an error because the record type is not defined within the function

B. It executes successfully but does not display the names and salaries of all employees who earn the highest salary.

C. It gives an error because the return type is not valid.

D. It gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not valid

E. It executes successfully and displays the names and salaries of all employees who earn the highest salary.

A. It displays null if no employee with employee_id 123 exists.

B. It displays an error because the select into clause cannot be used to populate the PL/SQL record type.

C. It produces the ora-01403: no data found error if no employee with employee_id 123 exists.

D. The code executes successfully even if no employee with employee_id 123 exists and displays Record Not Found.

A. They are implicitly fired when a triggering event occurs, depending on which user is connected

B. They can include SQL and PL/SQL or calls to Java procedures.

C. They are implicitly fired by an event that must occur within an application

D. They can invoke only PL/SQL procedures

A. Only the first fetch retrieves the first row and assigns values to the target variables- the second produces an error.

B. They produce an error because you must close and reopen the cursor before each fetch -statement.

C. Each fetch retrieves the next consecutive row and assigns values to the target variables.

D. Each fetch retrieves the first row and assigns values to the target variables.

A. AFTER LOGON

B. BEFORE SHUTDOWN

C. AFTER STARTUP

D. AFTER SERVERERROR

A. It executes successfully and incorrectly gives the result of the sum of salaries in department 60.

B. It gives an error because the variable name and column name are the same in the where clause of the select statement.

C. It executes successfully and correctly gives the result of the sum of salaries in
department 60.

D. It gives an error because group functions cannot be used in anonymous blocks

A. SCOTT'S session displays 5, and then 5 again; green's session displays 5.

B. SCOTT'S session displays 5, and then 5 again, green's session displays 0.

C. SCOTT'S session displays 5, and then 0; green's session displays 5.

D. SCOTT'S session displays 5, and then 0, greets session displays 0.

A. It gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL block.

B. It gives an error because decode cannot be used in a PL/SQL block.

C. It gives an error because the AVG function cannot be used in a PL/SQL block

D. It executes successfully.

E. It gives an error because both the AVG and decode functions cannot be used in a PL/SQL block.