Online Access Free 1z1-074 Practice Test

Which two are true about tables recovered by using the RMAN RECOVER TABLE command or the command itself, starting from Oracle Database 12c Release 2? (Choose two.)

• A.They must be un-partitioned tables
• B.An AUXILIARY instance is started only if there is sufficient disk space
• C.They may be recovered to a schema in a different PDB
• D.They may be recovered to a different schema in the same pluggable database (PDB)
• E.They can be recovered by RMAN without an AUXILIARY instance

A multi-tenant container database (CDB) contains three PDBs.
Which three are prerequisites for performing a cross-platform transport of any of the PDBs? (Choose three.)

• A.The source and target platforms must have the same endianness.
• B.Flashback database must be enabled for the CDB.
• C.The COMPATIBLE parameter must be set to 12.2 or greater in the CDB.
• D.The CDB should be in MOUNT state.
• E.The CDB must use Automatic Memory Management.
• F.The source PDBs must be closed for a cross-platform PDB backup.

Which three statements are true about the deferred invalidation clause in DDL statements? (Choose three.)

• A.The CURSOR_INVALIDATION parameter always overrides the deferred invalidation clause.
• B.It always overrides the CURSOR_INVALIDATION setting.
• C.It defers invalidating dependent cursor when possible.
• D.It cannot be used for bitmap index creation.
• E.It cannot be used for creating a secondary index on index organized tables

Which three statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

• A.It analyzes only those memory components of the database instance that are impacting performance.
• B.It analyzes the performance of the database instance based on the latest two AWR snapshots.
• C.It recommends implementing SQL profiles to generate better execution plans.
• D.It determines the segments on which waits are occurring when the database has a high number of buffer busy waits.
• E.It analyzes only the components and waits that are impacting database performance.
• F.It determines SQL statements that are performing poorly.

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.Set the REMOTE_LOGIN_PASSWORDFILE parameter value to NONE.
• B.Recreate the password file with the password set to Oracle_4U.
• C.Restart the database instance.
• D.Change the password of U1 to Oracle_123.
• E.Regrant SYSDBA to U1.