Oracle 1Z0-144 問題集

質問 1：
Examine the following snippet of PL/SQL code:

View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has
200 rows.

Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as 'ST_CLERK' and salary greater than 3000.
A. OPEN c1 (3000, emp_salary);
B. OPEN c1 (EMP_job, emp_salary);
C. OPEN c1 (emp_job, 3000);
D. OPEN c1 (NULL, 3000);
E. OPEN c1 ('ST_CLERK', 3000)
正解：E

質問 2：
Examine the following code:

The above code generates an error on execution.
What must you do to ensure that the code executes successfully?
A. Use both the TO_DATE function in line 2 and the TO_NUMBER function in line 6.
B. Use the TO_DATE function in line 7.
C. Use the TO_NUMBER function in line 6.
D. Use the TO_DATE function in line 2.
正解：D

質問 3：
Which statements correctly describe the features of functions and procedures? (Choose all that apply.)
A. A procedure can contain a return statement without a value.
B. A function can return multiple values using a single return clause,
C. A procedure can be executed as part of a SQL expression or as a PL/SQL statement,
D. A function can contain zero or more parameters that are transferred from the calling environment.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which two statements are true about the continue statement? (Choose two.)
A. The PL/SQL block execution terminates immediately.
B. The loop completes immediately and control passes to the statement after end loop.
C. The statements after the continue statement in the iteration are executed before terminating the LOOP.
D. The current iteration of the loop completes immediately and control passes to the next iteration of the loop
E. The CONTINUE statement cannot appear outside a loop.
正解：D,E

質問 5：
View Exhibit 1 and examine the structure of the EMP and dept tables.

View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.

What is the outcome on compilation?
A. It compiles successfully but gives an error on execution because it is not a row-level trigger.
B. It gives an error on compilation because the exception section Is used in the trigger.
C. It gives an error on compilation because it is not a row-level trigger.
D. It compiles and executes successfully.
正解：C