Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)

• A.The default value is NATIVE.
• B.Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
• C.It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
• D.If set to NATIVE, programs are stored in platform dependent machine code.
• E.If set to NATIVE, programs are stored in a PL/SQL bytecode format.

Comment: *

Name: *

Email: *

Verification: *

The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).
Which two blocks of code execute successfully when invoked by user SH? (Choose two.)

• A.
• B.
• C.
• D.
• E.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Examine these statements from a block of code:

Which two are true? (Choose two.)

• A.An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
• B.The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
• C.The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
• 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.

Comment: *

Name: *

Email: *

Verification: *