Oracle 1Z0-149 問題集

質問 1：
Which three statements can process a dynamic multi-row query? (Choose three.)
A. CLOSE
B. FETCH
C. WHEN
D. OPEN
E. INTO
F. DECLARE
G. OPEN-FOR
正解：A,B,G

質問 2：
Examine the structure of the ora1.depts table:

Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:

Which is true?
A. It will run successfully producing a result of 4.
B. It will result in an error because table depts has been altered.
C. DEP_VU must be manually recompiled to successfully run this code.
D. It will run successfully producing a result of 5.
正解：A

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

B.

C.

D.

正解：C

質問 4：
Examine this code:

What will be the outcome?
A. It will execute successfully and will display the user-defined error message.
B. It will result in an error as the range of the error code can only be from "-20000 to -20999."
C. It will result in an error as the range of the error code can only be from "-2000 to -2999."
D. It will result in an error as the range of the error code can only be from "-1000 to -2000."
正解：B

質問 5：
Which three are true about PL/SQL subprograms? (Choose three.)
A. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
B. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.
C. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
D. A PL/SQL procedure can invoke an external code block written in a different programming language.
E. Host variables can be referenced inside any PL/SQL subprogram.
F. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.
G. Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.
正解：A,C,D

質問 6：
Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)
A. A function is deterministic if it always returns the same result for a specific combination of input values.
B. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
C. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
D. The PARALLEL_ENABLE clause can be specified for a nested function.
E. A deterministic function's results always depend on the state of session variables.
F. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
G. The NOCOPY hint asks the compiler to pass the actual parameters by value.
正解：A,C,F

質問 7：
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?
A.

B.

C.

D.

正解：A