Online Access Free 1z0-067 Exam Questions

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;

Which two statements are true?

• A.An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
• B.An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
• C.The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
• D.A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.
• E.The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

• A.The backup as copy can only be taken to disk
• B.Backup will constitute all used and unused blocks in the database
• C.The backup as copy can only be taken to tape
• D.Backup can be performed only when the instance is shutdown

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

• A.Reduced logical I/O
• B.Reduced CPU utilization
• C.Reduced virtual memory utilization
• D.Reduced physical I/O
• E.Improved Serial Execution performance

Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?

• A.parallel server limit
• B.maximum idle time for a session in a PDB
• C.maximum undo per consumer group
• D.CPU
• E.maximum number of sessions for a PDB

Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?

• A.A data file belonging to a noncritical tablespace is missing.
• B.All the control files are missing.
• C.All the data files are missing.
• D.The database backup is older than the control file backup.
• E.The current online redo log file is missing.