最新1Z0-149合格保証試験問題集には正確で最新な問題があります [Q30-Q46]

最新1Z0-149合格保証試験問題集には正確で最新な問題があります

1Z0-149試験ブレーン問題集で学習注釈と理論

質問 # 30
Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

A. It might return a run time error depending on who invokes it.
B. It will always return a run time error because v_raise is not initialized.
C. It will set all salaries to NULL if it executes successfully.
D. It will set all salaries to 0 if it executes successfully.
E. It will always return a compile time error because it lacks an EXCEPTION section.
F. It will always automatically initialize v_raise.

正解：C、F

質問 # 31
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

A. Object privileges to execute a replaced function are retained by those users who had the privileges.
B. Function based indexes remain usable when replacing the function on which the index depends.
C. This clause can be used only for procedures and functions.
D. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
E. A function definition can be modified without dropping and re-creating it.

正解：A、E

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

正解：B

質問 # 33
In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.
A row exists with EMPLOYEE_ID 201.
Examine these packages created by user HR:

EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.
Which two will execute successfully? (Choose two.)

A. Call HR.HELPER.H1 from the HR schema.
B. Call HR.API.P1 from the HR schema.
C. Call HR.HELPER.H1 from the SH schema.
D. Call HR.API.P1 from the SH schema.
E. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.

正解：C、D

質問 # 34
Examine this code:
ALTER SESSION SET plsql_warnings='ENABLE:ALL';
/
You compile this function:

What happens when the function is created with PLSQL_WARNINGS set to 'ENABLE: ALL'?

A. A performance compilation warning is generated.
B. It fails compilation.
C. There are no compilation warnings or errors.
D. A severe compilation warning is generated.
E. An information compilation warning is generated.

正解：A

質問 # 35
Which two are true about packages? (Choose two.)

A. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
B. A package definition must have a specification and body.
C. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
D. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
E. Package specifications can be compiled without their bodies.

正解：D、E

質問 # 36
Which is true about the PLSCOPE_SETTINGS parameter?

A. It can be used to control a user's privileges on PL/SQL objects at run time.
B. It can be used to control execution of specific portions of the PL/SQL code conditionally.
C. It can be used to obtain information about all identifiers when compiling a procedure.
D. It is deprecated in Oracle 12c.

正解：C

質問 # 37
Which three are true about user-defined functions? (Choose three.)

A. Functions can call only other functions.
B. They can be used in ORDER BY and GROUP BY clauses.
C. They must be defined with at least one parameter.
D. They can be executed as standalone commands.
E. They can appear in the select list of a SELECT statement.
F. They need not return any values.
G. They can be used in CONNECT BY and START WITH clauses.

正解：B、E、G

質問 # 38
Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

A. PL/SQL code can be compiled and executed based on different versions of the operating system.
B. PL/SQL code can be compiled and executed based on different versions of Oracle.
C. The PL/SQL compiler can conditionally include selected parts of a program.
D. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
E. Conditional compilation is disabled by default.

正解：B、C

質問 # 39
Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

A. It will fail at lines 6 and 7.
B. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
C. It will fail only at line 7.
D. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.

正解：C

質問 # 40
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

正解：A

質問 # 41
Which three are true about anonymous blocks and subprograms? (Choose three.)

A. Named subprograms are stored in the database server.
B. Anonymous blocks must always start with the Declare keyword.
C. Named subprograms cannot be called from other packages.
D. A FUNCTION subprogram must return one or more values.
E. Anonymous blocks cannot use packaged variables.
F. PROCEDURE subprograms can accept parameters.
G. FUNCTION subprograms must be called and passed through one or more parameters.

正解：A、D、F

質問 # 42
Examine this table definition in the SH schema.

A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)

正解：A、C

質問 # 43
Examine this row of data from the EMPLOYEES table:

Now, examine this block of code which executes successfully:

What is the value of v_commission?

A. 0
B. 1
C. 2
D. 3

正解：A

質問 # 44
Which three are true about PL/SQL subprograms? (Choose three.)

A. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
B. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.
C. Host variables can be referenced inside any PL/SQL subprogram.
D. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
E. A PL/SQL procedure can invoke an external code block written in a different programming language.
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、D、E

質問 # 45
Which two blocks of code display a numerical zero? (Choose two.)