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

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.VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
• D.Only associative arrays and nested tables can have elements of RECORD type.
• E.Collections and RECORD types are always dense.
• F.All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.

Which three are true about functions and procedures? (Choose three.)

• A.The ACCESSIBLE BY clause can be used only for procedures.
• B.Both can have only constants as actual parameters for IN mode parameters.
• C.In a function, every execution path must lead to a RETURN statement.
• D.In a function every RETURN statement must specify an expression.
• E.In a procedure the RETURN statement cannot specify an expression.
• F.Both can be invoked from within SQL statements.

Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

• A.The RETURNING INTO clause and bulk binds may not be used together.
• B.The RETURNING INTO clause returns column values for rows affected by DML statements.
• C.When using the RETURNING INTO clause, the data returned can be only single column or expression.
• D.The RETURNING clause can be used for remote or parallel deletes.
• E.The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.

Examine these statements:

Which is true?

• A.It will result in a compilation error for protected_proc because calling_proc does not exist.
• B.It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.
• C.It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.
• D.With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

For which three SYSTEM EVENTS can triggers be created? (Choose three.)

• A.BEFORE ANALYZE
• B.SERVERERROR
• C.BEFORE GRANT
• D.DDL
• E.SHUTDOWN
• F.AFTER AUDIT
• G.STARTUP