Oracle Database 19c: Program with PL/SQL 認定 1Z0-149 試験問題 (Q15-Q20):
質問 # 15 Which two are true about collections and RECORD types? (Choose two.)
A. All collections and RECORD types can be stored in table columns.
B. A variable of RECORD type can contain fields of another RECORD type or any collection type.
C. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
D. Only associative arrays and nested tables can have elements of RECORD type.
E. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
F. Collections and RECORD types are always dense.
正解:D、E 質問 # 16 Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)
A. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
B. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
C. A deterministic function's results always depend on the state of session variables.
D. A function is deterministic if it always returns the same result for a specific combination of input values.
E. The PARALLEL_ENABLE clause can be specified for a nested function.
F. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
G. The NOCOPY hint asks the compiler to pass the actual parameters by value.
正解:A、B、D 質問 # 17 Examine this statement which is submitted for compilation:
Which three are true? (Choose three.)
A. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
B. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
C. Initialization of loan_amount can be done while using this packaged variable in another program.
D. This program unit will compile successfully.
E. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
F. Initialization of min_bal can be done while using this packaged constant in another program.
G. This will not compile successfully because the min_bal constant must be initialized.
正解:A、B、G 質問 # 18 Which three are true regarding code based access control (CBAC)? (Choose three.)
A. CBAC roles can be granted to a program unit only if they are directly granted to its owner.
B. You can use CBAC to attach database roles to a PL/SQL function or procedure only.
C. CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.
D. In a multitenant environment, the DELEGATE option of CBAC cannot be used.
E. CBAC cannot be used to secure definer's rights.
F. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
G. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
正解:A、F、G 質問 # 19 Which is true about the PLSCOPE_SETTINGS parameter?
A. It is deprecated in Oracle 12c.
B. It can be used to obtain information about all identifiers when compiling a procedure.
C. It can be used to control execution of specific portions of the PL/SQL code conditionally.
D. It can be used to control a user's privileges on PL/SQL objects at run time.
OraclePDFバージョン、PCバージョン、APPオンラインバージョンなど、3つの異なるバージョンのOracle Database 19c: Program with PL/SQL prepトレントを選択できます、1Z0-149練習試験に準備する多くの人にとっては、資格試験資料を準備し、1Z0-149試験問題を勉強するのは本当に大変な作業です。
それだけでなく、テストトレント1Z0-149の最新情報を保持するために、チームは毎日更新を確認します。