1z0-148 Oracle Database 12c: Advanced PL/SQL Practice Questions

UNDOTBS1

SYSAUX

SYSTEM

TEMP

USERS

When the amount of data to be held in the collection is widely variable.

As a column in a table when you want to retrieve the collection data for certain rows by ranges of values.

When you want to delete elements from the middle of the collection.

As a column in a table when you want to store no more than 10 elements in each row’s collection.

Online redefinition can be done only at the table level.

Specify only BasicFiles LOB and SecureFiles LOB column names in parameter col_mapping of DBMS_REDEFINITION.START_REDEF_TABLE.

Set the database initialization parameter db_securefile to NEVER.

During migration, specify the NOLOGGING storage parameter for any new SecureFiles LOB column

Online redefinition is the recommended method for migration of BasicFile LOBs to Secure LOBs

The IN parameters must not include BLOB, CLOB, collection or record data types.

The function must be created with invoker’s rights or in an anonymous block.

The function must be declared as a pipelined table function.

The function must have an OUT or an IN OUT parameter.

When a user fixes incorrect marks for a student, with an update to the MARKS table, and then executes the function in the same sessio

When the amount of memory allocated for the result cache is increase

When the function is executed in a session frequently with the same parameter value

When the database administrator disables the result cache during ongoing application patching

When the maximum amount of server result cache memory that can be used for a single result is set to 0.