Master the 1Z0-063 Oracle Database 12c: Advanced Administration content and be ready for exam day success quickly with this Testking 1Z0-063 exam answers. 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
Q41. You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used?
A. RMAN recovery catalog
B. RMAN Media Management Library
C. Enterprise Manager Cloud Control
D. Enterprise Manager Database Express
E. Oracle Secure Backup
Answer: A,C
Q42. Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).
A. to store backup information of multiple databases in one place
B. to restrict the amount of space that is used by backups
C. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
D. to store RMAN scripts that are available to any RMAN client that can connect to target databasesregistered in the recovery catalog
E. to automatically delete obsolete backups after a specified period of time
Answer: A,C,D
Q43. Which two statements are true regarding Oracle Data Pump?
A. EXPDP and IMPDP are the clientcomponents of Oracle Data Pump.
B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
D. Oracle Data Pump imports can bedone from the export files generated in the Original Export Utility.
E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
Answer: A,B
Reference:http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm
Q44. Which three statements are true about persistent lightweight jobs?
A. A user cannot set privileges on them.
B. They generate large amounts of metadata.
C. They may be created as fully self-contained jobs.
D. They must reference an existing Scheduler Program.
E. The are useful when users need to create a large number of jobs quickly.
Answer: A,D,E
Q45. Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?
A. by using the RMAN switch command to set the new location for the data files
B. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host
C. by using the RMAN duplicate command with dbid and set nekname for tablespace to recover the database to the new host
D. by creating a new database in the new host, and then using the RMAN recover command
Answer: D
Q46. Which three statements are true about unplugging a pluggable database (PDB)?
A. The PDB must be open in read only mode.
B. The PDB must be dosed.
C. The unplugged PDB becomes a non-CDB.
D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
E. The unplugged PDB can be plugged into another CDB.
F. The PDB data files are automatically removed from disk.
Answer: B,D,E
Explanation: B, not A: The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means,quite simply, that an unplugged PDB cannot be moved across an endianness difference.
E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that thePDB’s datafiles can remain in place.
Reference: Oracle White Paper, Oracle Multitenant
Q47. Which two statements are true abouta multitenant architecture?
A. Each pluggable database (PDB) has its own initialization parameter file.
B. A PDB can have a private undo tablespace.
C. Log switches occur only at the container database level.
D. A PDB can have a private temporary tablespace.
E. Each PDB has a private control file.
Answer: C,D
Q48. Which three statements are true about Consolidated Database Replay?
A. The workload capture and replay systems must have the same operating system (OS).
B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
C. A subset of the captured workload can be replayed.
D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
E. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.
Answer: B,C,E
Q49. Examine the following set of RMAN commands:
RKAN> CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ;
RKAN> RUN
{
ALLOCATE CHANNEL chl DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN run block execution?
A. The script is executed and both DC1 and chi channels are used for script execution.
B. The execution of the script fails because multiple channels cannot exist simultaneously.
C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN run block.
D. The new channel, chi, is ignored because a channel has been configured already.
Answer: C
Q50. Examine the command and its output:
SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin;
RECYCLE_NAMEORIGINAL_NAMETYPE
binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE
You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;
Which two statements are true?
A. It flashes back the employee tableand all the constraints associated with the table.
B. It automatically flashes back all the indexes on the employes table.
C. It automatically flashes back any triggers defined on the table.
D. It flashes back only the structure of the table and not the data.
E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.
Answer: B,D
