Identify two types of files that are generated by the Pre-Upgrade Information tool as part of the database upgrade prerequisite checks? (Choose two.)

A. expdp scripts to export database objects belonging to the SYS schema

B. a log file containing a list of pre-upgrade patches to be applied

C. RMAN database backup scripts

D. a log file with tool recommendations and requirements

E. pre- and post-upgrade fixup scripts

Which two statements are true about clean restore points in a regular PDB? (Choose two.)

A. They require a clone instance to be created when used in a PDB flashback operation

B. They can be created for a PDB when connected to either the PDB or to the root

C. They require backups to be restored when used in a PDB flashback operation

D. They are created as guaranteed restore points

E. They can be created only if shared undo is enabled

F. They can be created only for a PDB in the mount state

Identify four prerequisites for issuing the RMAN RECOVER TABLE command starting from ORACLE Database 12c Release 2.

A. The COMPATIBLE parameter must be set to 12.0 or greater.

B. The database must be in ARCHIVELOG mode.

C. FLASHBACK DATABASE must be enabled.

D. RMAN must use a recovery catalog.

E. The database must be in the READ WRITE state.

F. RMAN can recover the table only from a backupset.

G. An export dump file of the table must be available.

H. There must be sufficient space to start the auxiliary instance.

In TESTDB, U1 has SYSDBA privileges and the password Oracle_4U.

You recreate the password file:

$ orapwd FILE=orapwtestdb FORMAT=12.2 password=Oracle_123 ENTRIES=5

Examine the command and result:

$ sqlplus u1/Oracle_4U@testdb as sysdba

ERROR:

ORA-01017: invalid username/password; logon denied

What can you do to fix this error?

A. Recreate the password file with the password set to Oracle_4U.

B. Change the password of U1 to Oracle_123.

C. Set the REMOTE_LOGIN_PASSWORDFILE parameter value to NONE.

D. Regrant SYSDBA to U1.

E. Restart the database instance.

Which three database objects can have columns stored in the In-Memory (IM) column store? (Choose three.)

A. subpartitions

B. clustered tables

C. materialized views

D. index-organized tables

E. heap tables

F. any SYS owned objects