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

Which two are true about implicit data type conversion? (Choose two.)

• A. Implicit data type conversion can negatively impact performance.
• B. Collections can be implicitly converted to records.
• C. RAW data types are always implicitly converted to a CLOB when used in a query.
• D. Comparison between character value and a number value always implicitly converts the character value to the number data type.
• E. ROWIDS are always implicitly converted to a number when used in a query.

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

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

Examine these statements from a block of code:

Which two are true? (Choose two.)

• A. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
• B. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
• C. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
• D. Only the PRICE column can be updated in the PRODUCTS table.
• E. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.

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

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