最新的Oracle Database 11g: Program with PL/SQL - 1Z0-144免費考試真題

A. The check option for views is not enforced when Insertions or updates to the view are performed by using the instead of trigger.

B. Delete operations cannot be performed using the instead of triggers.

C. The instead or triggers must be created to add or modify data through any view.

D. The instead of triggers can be written only for views, and the before and after timing options are not valid.

A. The attributes of fields in the record with the %ROWTYPE attribute can be modified manually.

B. It is used to declare a record that can hold multiple rows of a table.

C. The attributes of fields in the record take their names and data types from the columns of the table, view, cursor, or cursor variable.

D. It ensures that the data types of the variables that are declared with the %ROWTYPE attribute change dynamically when the underlying table is altered.

A. It consists of a single transaction,

B. It consists of two transactions

C. It gives an error on execution because sequences cannot be used in anonymous blocks.

D. The data is automatically committed after the block execution ends,

A. the exceptions that are explicitly raised by the program and can be caught by the exception handler

B. an exception that is raised automatically when the PL/SQL program violates a database rule or exceeds a system-dependent limit

C. an exception that the developer determines as abnormal, are in the declarative section and raised explicitly

D. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler

A. It produces the ora-01403: no data found error 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 displays null 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. SCOTT'S session displays 5, and then 0, greets session displays 0.

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

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

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

A. It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger.

B. It gives an error on compilation because it should be a statement-level trigger.

C. It gives an error on compilation because of the commit command in the trigger code

D. It compiles and fires successfully when the credit limit is updated in the customer table.

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

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

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

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

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

A. Line 2

B. Line 3

C. Line 5

D. Line 6

E. Line 4

A. because the WORD_LIST parameter in out mode cannot be of a record data type

B. because the WORD_LIST variable is not visible in procedure wording

C. because the lexicon variable is not initialized in procedure wording

D. because the lexicon variable is not visible in procedure ADD_ENTRY