Oracle 1Z0-149 問題集

質問 1：
Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)
A. It will set all salaries to NULL if it executes successfully.
B. It might return a run time error depending on who invokes it.
C. It will always automatically initialize v_raise.
D. It will always return a run time error because v_raise is not initialized.
E. It will always return a compile time error because it lacks an EXCEPTION section.
F. It will set all salaries to 0 if it executes successfully.
正解：A,C

質問 2：
Which is true about EXIT and CONTINUE statements?
A. They have the same effect on the execution of a loop.
B. They must have a WHEN condition.
C. They must use labels.
D. They can be used in any type of loop.
正解：D

質問 3：
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
A.

B.

C.

D.

正解：C

質問 4：
Examine these statements from a block of code:

Which two are true? (Choose two.)
A. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
B. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
C. Only the PRICE column can be updated in the PRODUCTS table.
D. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
E. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
正解：A,B

質問 5：
Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?
A. It will return an error at line 2.
B. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.
C. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.
D. It will return an error at line 3.
E. It will return an error at line 8.
正解：B

質問 6：
Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:

USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?
A. It results in an error because Authid Current_User is missing from MYPROC.
B. It executes successfully.
C. It results in an error because Authid Definer is missing from MYPROC.
D. It results in an error because USERB doesn't have select privilege on USERA.EMP.
正解：B

質問 7：
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?
A.

B.

C.

D.

正解：B