Which two are true about lexical units? (Choose two.)

• A.A character literal with zero characters has the BOOLEAN value NULL.
• B.All user-defined identifiers must start with an alphabet.
• C.Spaces can be embedded in delimiters.
• D.Character literals are case-sensitive.
• E.Identifiers include labels.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about user-defined records?

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

Comment: *

Name: *

Email: *

Verification: *

Which three are true about the procedure overloading feature? (Choose three.)

• A.Each procedure must use named notation to specify the corresponding actual parameters.
• B.Each procedure's formal parameters must differ in name.
• C.Each procedure can be a standalone subprogram.
• D.Each procedure can be a nested subprogram.
• E.Each procedure's formal parameters can differ in data type or name.
• F.Each procedure must use positional notation to specify the corresponding actual parameters.
• G.Each procedure can be a packaged subprogram.

Comment: *

Name: *

Email: *

Verification: *

In which type of trigger can :OLD and :NEW identifiers be used?

• A.BEFORE STATEMENT
• B.ROW
• C.AFTER STATEMENT
• D.AFTER SUSPEND

Comment: *

Name: *

Email: *

Verification: *

Which two are true about collections and RECORD types? (Choose two.)

• A.Only associative arrays and nested tables can have elements of RECORD type.
• B.Collections and RECORD types are always dense.
• C.All collections and RECORD types can be stored in table columns.
• D.VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
• E.A variable of RECORD type can contain fields of another RECORD type or any collection type.
• F.All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.

Comment: *

Name: *

Email: *

Verification: *