Oracle 1Z0-146 問題集

質問 1：
Examine the structure of the TEST_DETAILS table: Name Null? Type
TEST_ID NUMBER
DESCRIPTION CLOB
DESCRIPTION data was entered earlier and saved for TEST_ID 12.
You execute this PL/SQL block to add data to the end of the existing data in the DESCRIPTION
column for TEST_ID 12:
DECLARE
clob_loc CLOB;
buf CHAR(12);
BEGIN
SELECT description INTO clob_loc FROM test_details WHERE test_id = 12 ;
buf := '0123456789';
DBMS_LOB.WRITEAPPEND(clob_loc,DBMS_LOB.GETLENGTH(buf), buf);
COMMIT;
END;
/
It generates an error on execution.
What correction should you do to achieve the required result?
A. FOR UPDATE must be added to the SELECT statement.
B. WRITEAPPEND must be replaced with APPEND.
C. The BUF variable data type must be changed to CLOB.
D. The GETLENGTH routine must be replaced with the LENGTH built-in function in WRITEAPPEND.
正解：A

質問 2：
Which two statements are true about the inlining of PL/SQL subprograms? (Choose two.)
A. The PL/SQL programs that make use of relatively large helper subroutines are good candidates for inlining.
B. Only local subroutines can be inlined.
C. Inlining always reduces the execution time for a PL/SQL program unit.
D. PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2.
正解：B,D

質問 3：
View the Exhibit and examine the code in the PL/SQL block.

The PL/SQL block generates an error on execution. What is the reason?
A. The NEXT method cannot be used with an associative array with VARCHAR2 key values.
B. The DELETE(n) method cannot be used with nested tables.
C. The NEXT method cannot be used with a nested table from which an element has been deleted.
D. The DELETE(n) method cannot be used with varrays.
正解：D

質問 4：
Which two queries' results cannot be cached? (Choose two.)
A. queries having SYSDATE and SYS_TIMESTAMP SQL functions
B. queries having the GROUP BY clause
C. the query on dictionary and temporary tables
D. queries having the ORDER BY clause
正解：A,C

質問 5：
View Exhibit1 and examine the structure of the EMPLOYEES table.

View Exhibit2 and examine the code in the PL/SQL block.
The PL/SQL block fails to execute.
What could be the reason?
A. LAST_NAME values cannot be assigned to the V_LAST_NAMES nested table because local collection types are not allowed in SQL statements.
B. The NEWNAMES nested table has not been initialized.
C. The assignment operator cannot be used to transfer all the element values from GROUP1 to GROUP2.
D. The third element of OLDNAMES cannot be assigned to the third element of GROUP1 because they are of inconsistent data types.
E. Nested tables cannot be returned by a function.
正解：A