Free Oracle 1z0-034 Exam Dumps Questions & Answers

In which two aspects does hot patching differ from conventional patching? (Choose two.)

• A.It is not persistent across instance startup and shutdown unlike conventional patching.
• B.It can be installed and uninstalled via OPatch unlike conventional patching.
• C.It consumes more memory compared with conventional patching.
• D.It takes more time to install or uninstall compared with conventional patching.
• E.It does not require down time to apply or remove unlike conventional patching.

Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the orders table and receives the following error:
ERROR at line I:
ORA-0I565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp'
ORA-27037: unable to obtain file status
What would be the most efficient way to rectify this error?

• A.Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.
• B.Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.
• C.Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
• D.Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.

Examine the following command for RMAN backup:
RMAN> RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
ALLOCATE CHANNEL c2 DEVICE TYPE sbt;
ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
BACKUP
INCREMENTAL LEVEL = 0
(DATAFILE 1,4,5 CHANNEL c1)
(DATAFILE 2,3,9 CHANNEL c2)
(DATAFILE 6,7,8 CHANNEL c3);
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
}
Which statement is true regarding the approach in the command?

• A.It is a case of parallelization of the backup set.
• B.It is an implementation of a multisection backup.
• C.The RMAN multiplexing level is 4.
• D.It is the use of asynchronous I/O by RMAN.

Which four resources can directives be specified by using the Oracle Resource Manager?

• A.idle time for blocking sessions
• B.degree of parallelism
• C.number of I/Os requests
• D.number of open cursors
• E.CPU usage
• F.number of sorts performed

In which two situations would you rebuild an index using the ALTER INDEX----- REBUILD command?

• A.to change index storage options
• B.to change a unique index into a non-unique index
• C.to move the index to another tablespace
• D.to improve performance of an INDEX CLUSTER
• E.to enable index monitoring