1Z0-149 試験問題を無料オンラインアクセス

Which three are true about PL/SQL subprograms? (Choose three.)

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

Which statement is true about user-defined records?

• A.Field types must match column types.
• B.Field names must match selected column names.
• C.The number of fields must match the number of columns in a table.
• D.They can be returned from a function.

Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

• A.ENABLE
• B.ALL
• C.DISABLE
• D.SEVERE
• E.ERROR

Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

• A.an associative array indexed by VARCHAR2
• B.a record declared in an anonymous block
• C.a record declared in a procedure
• D.an associative array indexed by PLS_INTEGER
• E.a record declared in a package specification
• F.a predefined PL/SQL-only data type like BOOLEAN

Which three are true about user-defined functions? (Choose three.)

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