Oracle Database Advanced PL SQL 12c 1z0 148

Question : 34 of 54

Marks: +1, -0

Which two are correct when migrating BasicFile LOBs to SecureFile LOBs by DBMS_REDEFINITION? (Choose two.)

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 columns
Online redefinition is the recommended method for migration of BasicFile LOBs to Secure LOBs.

Go to Question:

Prev Question

Next Question