Oracle 1Z0-146 問題集

質問 1：
Which two statements are true about the extproc process? (Choose two.)
A. It converts the C output back to PL/SQL.
B. It is started by the server process.
C. A single extproc process serves all user sessions.
D. It loads the dynamic library.
正解：A,D

質問 2：
View the Exhibit and examine the PL/SQL code.

Which statement is true about the execution of the PL/SQL code?
A. It executes successfully and displays 101 and 200000 values.
B. The SELECT statement generates an error because the nested table has not been initialized in the ASSIGN_VAL function.
C. The ASSIGN_VAL function generates an error during compilation because nested tables cannot be returned by functions.
D. The ASSIGN_VAL function generates an error during compilation because the EXTEND method cannot be used with nested tables.
正解：B

質問 3：
You executed this command to gather information about the memory allocation for storing query
results:
SQL> execute dbms_result_cache.memory_report
View the Exhibit and examine the output for the execution of the
DBMS_RESULT_CACHE.MEMORY_REPORT procedure.
Which two statements are true about the output in the Exhibit? (Choose two.)

A. Currently 52 KB is allocated to the result cache.
B. The result cache can be increased by 65628 bytes.
C. Currently 32 KB is allocated to the result cache.
D. In total, four blocks are used by the result cache.
正解：B,C

質問 4：
Which two statements are true about REF CURSOR types? (Choose two.)
A. Only a weak REF CURSOR type can be used as a formal parameter of a stored procedure or function.
B. REF CURSOR types cannot be defined inside a package.
C. SYS_REFCURSOR can be used to declare cursor variables in stored procedures and functions.
D. A REF CURSOR return type can be declared using %TYPE, or %ROWTYPE, or a userdefined record.
正解：C,D

質問 5：
Which guidelines should be considered when designing and using cursors in a PL/SQL block? ? (Choose all that apply.)
A. When using data manipulation language statements, (DML) reference a SQL cursor attribute immediately after the DML statement executes in the same block.
B. When fetching from a cursor, fetch into a record.
C. Whenever possible, explicitly declare the cursor and use the OPEN, FETCH and CLOSE statements to manipulate the cursor instead of using cursor FOR loop.
D. Use parameters with cursors so that the result set for the cursor is not tied to a specific variable in a program.
E. Use the %NOTFOUND attribute in combination with the SELECT INTO statement to check for non existent values.
正解：A,B,D

質問 6：
Which two statements are true about associative arrays and nested tables? (Choose two.)
A. Only associative arrays can hold an arbitrary number of elements.
B. Both associative arrays and nested tables can hold an arbitrary number of elements.
C. Both associative arrays and nested tables can be used as column types in database tables.
D. Only nested tables can be used as column types in database tables.
正解：B,D

質問 7：
Identify two strategies against SQL injection. (Choose two.)
A. Using parameterized queries with bind arguments.
B. Use RESTRICT_REFERENCE clauses in functions that use dynamic SQLs.
C. Validate user inputs to functions that use dynamic SQLs built with concatenated values.
D. Use subprograms that are run with the definer's right.
正解：A,C

質問 8：
Which two types of query results cannot be stored in the query result cache? (Choose two.)
A. results of a query having the SYSDATE function
B. results of a query having the GROUP BY clause
C. subquery results
D. results of a query having the DATE data type in the WHERE clause
正解：A,C

質問 9：
Examine the structure of the EMPLOYEES table in the SCOTT schema. Name Null? Type
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
SALARY NOT NULL NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2)
DEPARTMENT_ID NUMBER(4)
View the Exhibit and examine the code for the EMP_TOTSAL procedure created by user SCOTT.
Which statement is true regarding the EMP_TOTSAL procedure?

A. It generates an error because the %NOTFOUND attribute cannot be used in combination with a SELECT INTO statement.
B. It is created successfully and displays the correct output message for both existent and nonexistent employee IDs.
C. It generates an error because a user-defined exception has to be included whenever the %NOTFOUND attribute is used in combination with a SELECT INTO statement.
D. It is created successfully, but displays the correct output message only for existent employee IDs.
正解：D