Oracle Database Program with PL/SQL: 1Z0-149

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

A. RAW data types are always implicitly converted to a CLOB when used in a query.

B. Collections can be implicitly converted to records.

C. ROWIDS are always implicitly converted to a number 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. Implicit data type conversion can negatively impact performance.

Examine this table definition in the SH schema.

A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)

A. Option A

B. Option B

C. Option C

D. Option D

Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

A. The actual parameters must be specified in the same order as the formal parameters are declared.

B. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.

C. Only trailing optional parameters can be omitted in the invocation call.

D. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.

E. Any optional parameters can be omitted in the invocation call.