Oracle 1Z0-146 問題集

質問 1：
Which two statements are true about cursor variables? (Choose two.)
A. Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied to a cursor variable.
B. Cursor variables can be parameterized like cursors.
C. The OPEN FOR statement executes the query associated with a cursor variable and identifies the result set.
D. The FETCH statement executes the query associated with a cursor variable and identifies the result set.
E. The query associated with a cursor variable cannot reference host variables and PL/SQL variables.
正解：A,C

質問 2：
Examine the section of code taken from a PL/SQL program:
PROCEDURE p1 (x PLS_INTEGER) IS
... ...
PRAGMA INLINE (p1, 'NO');
x:= p1(1) + p1(2) + 17; -- Call 1
...
x:= p1(3) + p1(4) + 17; -- Call 2
Call 1 and Call 2 are the comments for distinguishing the code. The PLSQL_OPTIMIZE_LEVEL
parameter is set to 3. Which two statements are true in this scenario? (Choose two.)
A. The calls to the P1 procedure are never inlined in both the sections commented as Call 1 and Call 2.
B. The calls to the P1 procedure are not inlined in the section commented as Call 1.
C. The calls to the P1 procedure are inlined in both the sections commented as Call 1 and Call 2.
D. The calls to the P1 procedure might be inlined in the section commented as Call 2.
正解：B,D

質問 3：
Which statements are true about the SecureFile storage paradigm? (Choose two.)
A. SecureFile is the default storage paradigm for all LOBs that are stored in locally managed tablespaces if the DB_SECUREFILE parameter is set to ALWAYS.
B. SecureFile options enabled for a LOB column can be overridden on a per-LOB basis within the column.
C. SecureFile storage can be used for internal and external LOBs.
D. Automatic Segment Space Management must be enabled for a tablespace to store SecureFile LOBs.
正解：B,D

質問 4：
Examine the settings for a user session given below:
RESULT_CACHE_MODE= FORCE
What would be the implications of this setting on query execution? (Choose all that apply.)
A. All query results are stored in the result cache if possible.
B. Query results that are bigger than the available space in the result cache are not cached.
C. Query results are stored even when you explicitly use the /*+ no_result_cache */ hint in your query.
D. Query results are stored only when you explicitly use the /*+ result_cache */ hint in your query.
正解：A,B

質問 5：
Match the following external C procedure components with their descriptions:
1.External procedure a. a process that starts the extproc process
2.Shared library b. a session-specific process that executes the external procedure
3.Alias library c. schema object that represents the operating system (OS) shared library
4.The extproc process d. operating system file that stores the external procedure
5.Listener process e. a unit of code written in C
A. 1-a; 2-d; 3-e; 4-c; 5-b
B. 1-e; 2-d; 3-c; 4-b; 5-a
C. 1-e; 2-c; 3-d; 4-b; 5-a
D. 1-c; 2-d; 3-e; 4-b; 5-a
正解：B

質問 6：
Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure? (Choose two.)
A. You can describe a stored procedure, stored function, packaged procedure, or packaged function.
B. You can obtain information about the position, name, and data type of the arguments of a procedure.
C. You can describe anonymous PL/SQL blocks.
D. You can describe remote objects.
正解：A,B

質問 7：
Which two statements are true about the tuning of PL/SQL code? (Choose two.)
A. Usage of the NOT NULL constraint in PL/SQL code can degrade performance.
B. Implicit data type conversion in PL/SQL code can improve performance.
C. If you have one PL/SQL program unit instead of multiple smaller executable sections, performance can be improved.
D. Redundant SQL statements in PL/SQL code should be avoided.
正解：A,D

質問 8：
You created a procedure as follows:
CREATE OR REPLACE PROCEDURE query_prod(twhr VARCHAR2)
IS
stmt VARCHAR2(100);
pname VARCHAR2(20);
BEGIN
stmt:='SELECT product_name FROM products WHERE product_id=:2';
EXECUTE IMMEDIATE stmt INTO pname USING twhr;
DBMS_OUTPUT.PUT_LINE(pname);
END;
/
View the Exhibit to examine the structure of PRODUCTS table.

Which statement is true about the procedure?
A. The values for bind arguments remain persistent in the session after the execution of the procedure.
B. It can be invoked only from a PL/SQL block.
C. It reduces the chances of SQL injection by using bind arguments.
D. It produces an error when invoked.
正解：C

質問 9：
Identify the two types of PL/SQL programs for which you consider setting the compilation method to native mode. (Choose two.)
A. A PL/SQL program, which is called with the same parameters by multiple sessions
B. PL/SQL programs that spend most of their execution time in executing SQL statements
C. PL/SQL programs that have computation-intensive procedural operations
D. PL/SQL programs that are still in the debugging phase of development
正解：A,C