- Home
- Oracle
- Oracle Database 12c: Advanced Administration
- Oracle.1z0-063.v2019-08-18.q143
- Question 101
Valid 1z0-063 Dumps shared by ExamDiscuss.com for Helping Passing 1z0-063 Exam! ExamDiscuss.com now offer the newest 1z0-063 exam dumps, the ExamDiscuss.com 1z0-063 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1z0-063 dumps with Test Engine here:
Access 1z0-063 Dumps Premium Version
(278 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 101/143
You want to create a duplicate database DUP_DB from your production database PRODon the same host.
The PRODdatabase uses Automatic Storage Management (ASM) for storage. Regular backups are taken
using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:
What is a prerequisite for the successful execution of this command?
The PRODdatabase uses Automatic Storage Management (ASM) for storage. Regular backups are taken
using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:
What is a prerequisite for the successful execution of this command?
Correct Answer: B
Explanation/Reference:
Explanation:
Assume that the source database prod is on host1 and stores its data files in a non-ASM file system. The
control files for prod are located in /oracle/oradata/prod/.
You want to duplicate the source database to database dupdb on remote host host2.
You want to store the duplicate database files in ASM disk group +DISK1.
After connecting RMAN to the target, duplicate, and recovery catalog databases, run the following RMAN
script to duplicate the database.
DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT '/oracle/oradata/prod/', '+DISK1'
SET DB_CREATE_FILE_DEST +DISK1;
When the DUPLICATE command completes, the duplicate database is created, with data files, online redo
log files, and control files in ASM disk group +DISK1.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page
26-7
Explanation:
Assume that the source database prod is on host1 and stores its data files in a non-ASM file system. The
control files for prod are located in /oracle/oradata/prod/.
You want to duplicate the source database to database dupdb on remote host host2.
You want to store the duplicate database files in ASM disk group +DISK1.
After connecting RMAN to the target, duplicate, and recovery catalog databases, run the following RMAN
script to duplicate the database.
DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT '/oracle/oradata/prod/', '+DISK1'
SET DB_CREATE_FILE_DEST +DISK1;
When the DUPLICATE command completes, the duplicate database is created, with data files, online redo
log files, and control files in ASM disk group +DISK1.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page
26-7
- Question List (143q)
- Question 1: You enable Flashback Data Archive for a table for which you ...
- Question 2: Which two statements are true about roles in multitenant con...
- Question 3: Your multitenant container database (CDB) CDB1 has two plugg...
- Question 4: Which three statements are true about Oracle Secure Backup (...
- Question 5: Your database is running in ARCHIVELOGmode. Examine the init...
- Question 6: Your production database is running in archivelog mode. You ...
- Question 7: You want to create a guaranteed restore point for your datab...
- Question 8: You want to migrate your Oracle 11g database as a pluggable ...
- Question 9: Examine the command used to perform an incremental level-0 b...
- Question 10: Your database is running in archivelog mode and a nightly ba...
- Question 11: You want to back up a database such that only formatted bloc...
- Question 12: Which three requirements must be met before a tablespace can...
- Question 13: You created a database with DBCA by using one of the Oracle ...
- Question 14: You are administering a multitenant container database (CDB)...
- Question 15: Which three statements are true regarding the use of the Dat...
- Question 16: The HR user updates the salary of one of the employees in th...
- Question 17: Identify three reasons for using a recovery catalog with Rec...
- Question 18: Which two statements are true about tablespaces in multitena...
- Question 19: Examine the commands executed in the root container of your ...
- Question 20: Examine these Data Pump commands to export and import object...
- Question 21: Automatic Undo Management is enabled for your database. You ...
- Question 22: Examine the RMAN commands executed in your database: RMAN>...
- Question 23: You issue the RMAN commands: RMAN> CONFIGURE DEFAULT DEVI...
- Question 24: You are administering a multitenant container database (CDB)...
- Question 25: You create a new database by using the CREATE DATABASEcomman...
- Question 26: After implementing full Oracle Data Redaction, you change th...
- Question 27: You notice that the performance of your production 24x7 Orac...
- Question 28: Examine the probable steps involved in the basic backup proc...
- Question 29: Automatic Shared Memory Management (ASMm) is enabled for you...
- Question 30: You want to consolidate databases for the CRM, ERP, and SCM ...
- Question 31: Examine the command to duplicate a database: RMAN> DUPLIC...
- Question 32: Which statement is true about the loss or damage of a temp f...
- Question 33: Your database supports a Decision Support System (DSS) workl...
- Question 34: You want to create a database with a block size other than t...
- Question 35: Which two statements are true about making RMAN image copies...
- Question 36: You create two Resource Manager plans, one for night time wo...
- Question 37: In your database, the tbs percent used parameter is set to 6...
- Question 38: Which three statements are true about the startup and shutdo...
- Question 39: Which two statements are true regarding SecureFile lobs? (Ch...
- Question 40: Which three conditions must be met before you create a Virtu...
- Question 41: Which three statements are true about Oracle Restart? (Choos...
- Question 42: You plan to duplicate the multitenant container database (CD...
- Question 43: The following parameters are set for your Oracle 12c databas...
- Question 44: Which three statements are true about compression of backup ...
- Question 45: Your database is running in archivelog mode. Examine the par...
- Question 46: As part of a manual upgrade process, after installing the so...
- Question 47: Examine the commands executed in CDB$ROOT of your multitenan...
- Question 48: You set the following parameters in the parameter file and r...
- Question 49: Examine the RMAN command: RMAN> SET ENCRYPTION IDENTIFIED...
- Question 50: Examine the statements that use flashback technologies: 1. F...
- Question 51: Which three statements are true about the SQL*Loader utility...
- Question 52: You regularly take backups of your database using RMAN with ...
- Question 53: Which three statements are true about unplugging a pluggable...
- Question 54: You are administering a database that supports a data wareho...
- Question 55: Examine the output: SQL > ARCHIVE LOG LIST Database log m...
- Question 56: You wish to enable an audit policy for all database users, e...
- Question 57: Which activity is audited by default and recorded in the ope...
- Question 58: Which three methods can be used to create a pluggable databa...
- Question 59: You create a table with the period for clause to enable the ...
- Question 60: Examine the commands: SQL> ALTER SESSION SET RECYCLEBIN =...
- Question 61: Which two statements are true about the Automatic Diagnostic...
- Question 62: Evaluate these statements: CREATE TABLE purchase_orders ( po...
- Question 63: RMAN is configured to create backupset backups for your data...
- Question 64: Examine the list of possible steps to transport a tablespace...
- Question 65: You execute the RMAN commands: RMAN> CONFIGURE DEFAULT DE...
- Question 66: Your multitenant container database (CDB) cdb1, which has no...
- Question 67: A database is running in archivelog mode. You want to back u...
- Question 68: You have a production Oracle 12c database running on a host....
- Question 69: Which three statements correctly describe the relationship a...
- Question 70: Your Oracle 12c multitenant container database (CDB) contain...
- Question 71: Examine the RMAN command: RMAN> BACKUP VALIDATE DATABASE;...
- Question 72: For your database, an incremental level 1 backup is taken ev...
- Question 73: You accidentally drop the CUSTOMERStable, and then recover i...
- Question 74: Identify three scenarios in which RMAN will use backup sets ...
- Question 75: You issue the RMAN command: RMAN> BACKUP SECTION SIZE 300...
- Question 76: Which two statements are true about setting the FAST_START_M...
- Question 77: Your multitenant container database (CDB) contains multiple ...
- Question 78: Which two resources might be prioritized between competing p...
- Question 79: Which statement is true about the ALTER SESSION SET CONTAINE...
- Question 80: You want to reduce fragmentation and reclaim unused space fo...
- Question 81: Which two are prerequisites for setting up Flashback Data Ar...
- Question 82: You are administering a multitenant container database (CDB)...
- Question 83: Which four actions are possible during an Online Datafile Mo...
- Question 84: In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS. You rename...
- Question 85: Your database is running in archivelog mode and Automatic Un...
- Question 86: In your multitenant container database (CDB) that contains p...
- Question 87: Which three statements are true about a job chain? (Choose t...
- Question 88: Your database is running in noarchivelog mode. One of the da...
- Question 89: You want to export the pluggable database (PDB) HR_PDB1from ...
- Question 90: You want to capture column group usage and gather extended s...
- Question 91: Which two statements describe the relationship between a win...
- Question 92: Identify three benefits of unified auditing. (Choose three.)...
- Question 93: You are connected to a pluggable database (PDB) as a common ...
- Question 94: Which three types of backups can be performed for a database...
- Question 95: RMAN is connected to a target database instance and an auxil...
- Question 96: Which two statements are true about service creation for plu...
- Question 97: You are administering a multitenant container database (CDB)...
- Question 98: When is the UNDO_RETENTIONparameter value ignored by a trans...
- Question 99: Which statement is true about Enterprise Manager (EM) expres...
- Question 100: Identify two scenarios in which the RMAN crosscheck command ...
- Question 101: You want to create a duplicate database DUP_DB from your pro...
- Question 102: Which two statements are true regarding Oracle Data Pump? (C...
- Question 103: A database instance uses an SPFILE. Examine the parameter: (...
- Question 104: Which three statements are true about common roles? (Choose ...
- Question 105: You want RMAN to make duplicate copies of data files when us...
- Question 106: Users report this error message when inserting rows into the...
- Question 107: Which two statements are true about dropping a pluggable dat...
- Question 108: Which two statements are true about encrypted backups perfor...
- Question 109: While performing database backup to tape via the media manag...
- Question 110: You are administering a database that supports data warehous...
- Question 111: You are administering a multitenant container database (CDB)...
- Question 112: You need to perform a block media recovery on the tools01.db...
- Question 113: Which two statements are true about RMAN duplexed backups? (...
- Question 114: You use RMAN to take regular backups for your database. Exam...
- Question 115: The CATDB12cdatabase contains an Oracle Database version 12c...
- Question 116: You want to migrate your Oracle 11g database as a pluggable ...
- Question 117: Examine the RMAN command: RMAN> CONFIGURE ENCRYPTION FOR ...
- Question 118: Your multitenant container database (CDB) CDB1that is runnin...
- Question 119: You are required to migrate your 11.2.0.3 database to an Ora...
- Question 120: A telecom company wishes to generate monthly bills to includ...
- Question 121: Examine the backup requirement for your company: 1) Every Su...
- Question 122: You issue the command: SQL> ALTER DATABASE BACKUP CONTROL...
- Question 123: View the Exhibit showing steps to create a database resource...
- Question 124: The CATDB12Cdatabase contains an Oracle Database 12c catalog...
- Question 125: Which three statements are true about automated maintenance ...
- Question 126: Your database is running in ARCHIVELOG mode and flashback is...
- Question 127: The environmental variable oracle_Base is set to /u01/app/or...
- Question 128: Examine the RMAN commands: (Exhibit) Which statement is true...
- Question 129: Which three tasks can be automatically performed by the Auto...
- Question 130: In your database, there are tablespaces that were read-only ...
- Question 131: Examine the RMAN command: (Exhibit) Which statement is true ...
- Question 132: You notice performance degradation in your production Oracle...
- Question 133: Which three statements are true about Flashback Data Archive...
- Question 134: Which two statements are true about Flashback Version Query?...
- Question 135: Examine the command: SQL> RECOVER DATABASE USING BACKUP C...
- Question 136: Examine the following set of RMAN commands: (Exhibit) Which ...
- Question 137: Your database is running in archivelog mode and regular nigh...
- Question 138: You are administering a multitenant container database (CDB)...
- Question 139: You notice a performance change in your production Oracle 12...
- Question 140: Which Oracle Database component is audited by default if the...
- Question 141: Which two options can be configured for an existing database...
- Question 142: Which three factors influences the optimizer's choice of an ...
- Question 143: Which two are direct benefits of the multiprocess, multithre...
