Free Oracle 1z1-074 Exam Dumps Questions & Answers

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

Which statement is true about Trace File Analyzer (TFA) Collector?

• A.  In Oracle 12c Release 2, TFA installation can be done only while executing root.sh.
• B.  If TFA is installed on any cluster node, it automatically collects diagnostic data on all other cluster nodes.
• C.  It can be used to collect diagnostic data for predefined events, and can be configured to automatically collect data for other events.
• D.  TFA collects diagnostic data only for Oracle 12c Release 2 databases or later versions.
• E.  It is used to collect diagnostic data only for ORA-600, ORA-7445, and ORA-4031 events.

Your CDB is in ARCHIVELOG mode and has an application container with a container PDB. A backup exists for the CDB.
When you connect to the container PDB and try to execute a query, you get an error that a SYSTEM data file is missing in the container PDB.
You want to use the RMAN RESTORE DATABASE and RECOVER DATABASE commands to perform the recovery.
Examine these actions:
* Connect to CDB$ROOT and execute SHUTDOWN ABORT and STARTUP MOUNT.
* Connect to the application container and execute SHUTDOWN ABORT.
* Connect to the application container and execute ALTER PLUGGABLE DATABASE CLOSE ABORT.
Which option correctly lists the actions that you must execute before performing the recovery?

• A.  only 2
• B.  only 3
• C.  1 and 3
• D.  1 and 2

The TESTDB container database (CDB) contains two pluggable databases (PDBs), PDB1 and PDB2.
USER1 is a local user in PDB1 and has the SYSBACKUP privilege.
Connect descriptors for PDB1 and PDB2 are mapped to TNS aliases pdb1 and PDB2 in tnsnames.ora.
Examine these commands executed by USER1 when all PDBs are open:

What is the outcome and why?

• A.  The current date is displayed.
• B.  An error is returned because the user is not SYS.
• C.  An error is returned because the user is connected to a pluggable database.
• D.  An error is returned because the user is not a common user.
• E.  An error is returned because SQL commands cannot be executed from RMAN without using the SQL shell syntax: SQL"<command>".

You want to restrict PGA usage to 200 MB for a set of database users' sessions as part of your organization's security requirements for combating denial of service (DOS) attacks.
Which statement is true about limiting PGA usage for those users' sessions?

• A.  You can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB.
• B.  You can limit their PGA usage by setting PGA_AGGREGATE_TARGET to 200 MB.
• C.  You can limit their PGA usage by setting SORT_AREA_SIZE to 200 MB.
• D.  You cannot limit PGA for a set of database user sessions.
• E.  You can limit their PGA usage by setting the SESSION_PGA_LIMIT directive by using Database Resource Manager