Master the 1Z0-063 Oracle Database 12c: Advanced Administration content and be ready for exam day success quickly with this Examcollection 1Z0-063 exam. We guarantee it!We make it a reality and give you real 1Z0-063 questions in our Oracle 1Z0-063 braindumps.Latest 100% VALID Oracle 1Z0-063 Exam Questions Dumps at below page. You can use our Oracle 1Z0-063 braindumps and pass your exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-063 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-063 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-063-exam-dumps.html
Q1. Which three statements are true about Oracle Secure Backup (OSB)?
A. It can encrypt client data written to tape.
B. It can be used to take image copy backups to tape.
C. It can be used to manage tape backup and restore operations for multiple databases.
D. It can be used along with an RMAN recovery catalog for maintaining records of backups
in a tape library.
E. It can be used to perform file system backups at the file, directory, file system, or raw partition level.
Answer: A,C,E
Q2. For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;
Which statement is true about the execution of the command?
A. It returns an error because there isno level 0 backup available for new data files.
B. It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.
C. It performs a level-0 backup of all data files including those that belong to the new tablespace.
D. It performs an image copy backup of all data files including those that belong to the new tablespace.
E. It performs a backup as a backup set of all data files including those that belong to the new tablespace.
Answer: B
Reference:http://www.oracle-base.com/articles/misc/incrementally-updated-image-copy-backups.php
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm
Q3. Examine the command to duplicate a database:
RMAN> DUPLICATE TARGET DATABASE TO cdb
PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATE command?
A. The SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated.
B. A backup of pdbi and pd35 must exist before executing the command.
C. The duplicate command first creates a backup, and then duplicates the PDBs by using the
D. backup.
E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
Answer: D,E
Q4. Which three statements are true about compression of backup sets?
A. Compressed backups can only be written to media.
B. Binary compression creates performance overhead during a backup operation.
C. Unused blocks below the high-water mark are not backed up.
D. Compressed backups cannot have section size defined during a backup operation
E. It works only for locally managed tablespaces.
Answer: B,C,E
Q5. Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):
1.Start the RMAN client by using the RMAN target / command.
2.Start the RMANclient by using the OSB user.
3.RMAN creates the backup pieces.
4.Run the RMAN backup command with the sbt channels.
5.OSB creates a backup job and assigns a unique identifier.
6.OSB creates a backup job request through the OSB sbt library.
7.OSB stores metadata about RMAN backup pieces in the OSB catalog.
8.OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.
A. 1, 4, 6, 5, 8, 3, 9
B. 1, 6, 4, 5, 8, 3, 9
C. 2, 4, 6, 5, 8, 3, 7
D. 2, 4, 5, 8, 3, 7, 9
Answer: C
Q6. Consider the following scenario for your database:
Backup optimization is enabled in RMAN.
Therecovery window is set to seven days in RMAN.
The most recent backup to disk for the tools tablespace was taken on March 1,
...
2013.
. The tools tablespace is read-only since March 2, 2013.
On March 15, 2013, you issue the RMAN command to back up the databaseto disk.
Which statement is true about the backup of the tools tablespace?
A. The RMAN backup fails because the tools tablespace is read-only.
B. RMAN skips the backup of the tools tablespace because backup optimization is enabled.
C. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.
Answer: D
Q7. 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 virtual memory utilization
C. Improved Serial Execution performance
D. Reduced physical I/O
E. Reduced CPU utilization
Answer: B,E
Q8. Which parameter must be set to which value toimplement automatic PGA memory management?
A. Set memory_target to zero.
B. Set STATISTICS_LEVEL to BASIC.
C. Set pga_aggregate_target to a nonzero value.
D. Set pga_aggregate_target and sga_target to the same value.
E. Set sgajtarget to zero.
Answer: C
rence:http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11
Q9. Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
A. whenthe duplicate ... from active database command contains the section size clause
B. when you perform active database duplication on a database with flashback disabled
C. when you specify set encryption before the duplicate ... from active database command
D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
E. when you perform active database duplication on a database that has read-onlytablespaces
Answer: A,C,D
Reference:http://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV298
Q10. You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:
CONNECT/AS SYSDBA
ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCOPE=SPFILE;
SHUTDOWNIMMEDIATE
You then restart the instance and get an error:
STARTUP
ORA-01031:insufficientprivileges
Why does the startup command return the error shown?
A. because the threaded architecture requires exiting from sql*pIus and reconnectingwith sql*PIus / as sysdba before issuing a startup command
B. because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus before issuing a startup command
C. because the threaded architecture requires authentication using a password file before issuing a startup command
D. because the threaded architecture requires connecting to the instance via a listener before issuing a startup command
E. because the threaded architecture requires restarting the listener before issuing astartup command
Answer: C