- Home
- Oracle
- Oracle Database 12c: Advanced Administration
- Oracle.1z0-063.v2018-04-26.q231
- Question 127
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 127/231
Examine the RMAN command:
Which statement is true about the command?
Which statement is true about the command?
Correct Answer: C
Explanation/Reference:
SBT stands for Serial Backup Tape.
Configuring Parallel Channels for Disk and SBT Devices
The number of channels available for a device type when you run a command determines whether RMAN reads or writes in parallel. As a rule, the number of channels used in executing a command should match the number of devices accessed.
For tape backups, allocate one channel for each tape drive.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 5-
6
SBT stands for Serial Backup Tape.
Configuring Parallel Channels for Disk and SBT Devices
The number of channels available for a device type when you run a command determines whether RMAN reads or writes in parallel. As a rule, the number of channels used in executing a command should match the number of devices accessed.
For tape backups, allocate one channel for each tape drive.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 5-
6
- Question List (231q)
- Question 1: user_data is a nonencryptedtablespace containing tables with...
- Question 2: Identify three benefits of unified auditing....
- Question 3: Examine the RMAN command: RMAN> CONFIGURE ENCRYPTION FOR ...
- Question 4: Which three types of backups can be performed for a database...
- Question 5: Your database is running in archivelog mode. You are taking ...
- Question 6: Which three statements are true about unplugging a pluggable...
- Question 7: Your database is running in ARCHIVELOG mode and flashback is...
- Question 8: When is the UNDO_RETENTIONparameter value ignored by a trans...
- Question 9: You execute the RMAN commands: RMAN> BACKUP VALIDATE DATA...
- Question 10: Which four actions are possible during an Online Datafile Mo...
- Question 11: Examine the initialization parameter that is set in the PFIL...
- Question 12: You restore and recover your database to a new host by using...
- Question 13: Which three methods can be used to create a pluggable databa...
- Question 14: Which three statements are true about persistent lightweight...
- Question 15: Your database supports an online transaction processing (OLT...
- Question 16: The environmental variable oracle_Base is set to /u01/app/or...
- Question 17: A database instance uses an SPFILE. Examine the parameter: (...
- Question 18: Which two statements are true about the Automatic Diagnostic...
- Question 19: Which three statements are true about Oracle Restart?...
- Question 20: A user issues a query on the sales table and receives the fo...
- Question 21: Which two statements are true about tablespaces in multitena...
- Question 22: You notice that the performance of your production 24x7 Orac...
- Question 23: You are connected to a pluggable database (PDB) as a common ...
- Question 24: You use RMAN with a recovery catalog to back up your databas...
- Question 25: You are administering a multitenant container database (CDB)...
- Question 26: Which three statements are true about Oracle Secure Backup (...
- Question 27: Which two statements are true about service creation for plu...
- Question 28: You are administering a multitenant container database (CDB)...
- Question 29: You issue the command: SQL> ALTER DATABASE BACKUP CONTROL...
- Question 30: A complete database backup to media is taken for your databa...
- Question 31: Which two statements are true about Resource Manager plans f...
- Question 32: Automatic Undo Management is enabled for your database. You ...
- Question 33: Which three requirements should be successfully met by an Or...
- Question 34: You are connected to a recovery catalog and target database....
- Question 35: View the SPFILE parameter settings in the Exhibit. (Exhibit)...
- Question 36: Examine the RMAN commands executed in your database: RMAN>...
- Question 37: Your production database is running in archivelog mode. You ...
- Question 38: Which two statements are true about Resource Manager plans f...
- Question 39: You are administering a database that supports a data wareho...
- Question 40: Examine the command to back up the ASM metadata: ASMCMD>m...
- Question 41: Your database instance is started using an SPFILE. You are c...
- Question 42: You issue commands in SQL*Plus as the Oracle owner, to enabl...
- Question 43: A database is running in archivelog mode. You want to back u...
- Question 44: Your database is running in archivelog mode. Examine the par...
- Question 45: Which two statements are true about RMAN duplexed backups?...
- Question 46: You want to move your existing recovery catalog to another d...
- Question 47: You are administering a database that supports data warehous...
- Question 48: You want to export the pluggable database (PDB) hr_pdb1 from...
- Question 49: Your database is running on the host OUSERVER. You back up y...
- Question 50: You want the execution of large database operations to suspe...
- Question 51: Which two statements are true when row-archival management i...
- Question 52: You have installed two 64G flash devices to support the Data...
- Question 53: Examine the commands executed in the root container of your ...
- Question 54: In the SPFILE, UNDOJTABLESPACE is Set to UNDOTBS. You rename...
- Question 55: You have a production Oracle 12c database running on a host....
- Question 56: Your database supports an OLTP workload. Examine the output ...
- Question 57: You execute the RMAN commands: RMAN> CONFIGURE DEFAULT DE...
- Question 58: LDAP_DIRECTORY_SYSAUTH is set to YES. Users requiring DBAs a...
- Question 59: Identify three scenarios in which RMAN will use backup sets ...
- Question 60: Your database is running in archivelog mode and a nightly ba...
- Question 61: You plan to use the In-Database Archiving feature of Oracle ...
- Question 62: You are performing regular backups of your production databa...
- Question 63: In your database, the user SCOTT wants to retrieve the dropp...
- Question 64: You create a default Flashback Data Archive FLA1 and enable ...
- Question 65: Examine the statements that use flashback technologies: 1. F...
- Question 66: You execute the commands on a multitenant container database...
- Question 67: You created a tablespace with this statement: CREATE BIGFILE...
- Question 68: You set the following parameters in the parameter file and r...
- Question 69: Your database instance is abnormally terminated because of a...
- Question 70: Which statement is true about the loss or damage of a temp f...
- Question 71: Which two statements are true about Flashback Version Query?...
- Question 72: Which two statements are true about a multitenant architectu...
- Question 73: The following parameters are set for your Oracle 12c databas...
- Question 74: You want to consolidate backup information and centrally man...
- Question 75: Your multitenant container database (CDB) cdb1 that is runni...
- Question 76: You are administering a multitenant container database (CDB)...
- Question 77: Identify two scenarios in which the RMAN crosscheck command ...
- Question 78: Which three statements are true about the database instance ...
- Question 79: You plan to duplicate the multitenant container database (CD...
- Question 80: Your database is running in noarchivelog mode. One of the da...
- Question 81: On your Oracle 12c database, you invoke SQL*Loader to load d...
- Question 82: Which three conditions must be met before you Virtual Privat...
- Question 83: Examine the commands executed to monitor database operations...
- Question 84: A telecom company wishes to generate monthly bills to includ...
- Question 85: In which situation can you use Flashback Database?...
- Question 86: You must unload data from the orders, order_items, and produ...
- Question 87: Examine the parameters for your database instance: NAMETYPEV...
- Question 88: Which two statements are true about making RMAN image copies...
- Question 89: Which two resources might be prioritized between competing p...
- Question 90: You execute the command to recover your database: (Exhibit) ...
- Question 91: You want to create a guaranteed restore point for your datab...
- Question 92: Which three statements are true about unplugging a pluggable...
- Question 93: Which three statements are true about the keystore storage f...
- Question 94: You create a table with the period for clause to enable the ...
- Question 95: Which two statements are true regarding the Oracle Data Pump...
- Question 96: Examine the backup requirement for your company: 1) Every Su...
- Question 97: Your database is running in ARCHIVELOG mode. Complete databa...
- Question 98: You wish to enable an audit policy for all database users, e...
- Question 99: Which two methods can be used to add an Oracle 11g database ...
- Question 100: For which two requirements would you use the Database Resour...
- Question 101: You specified the warning and critical thresholds for a loca...
- Question 102: Which two statements are true about a common user?...
- Question 103: Examine the commands executed in CDB$ROOT of your multitenan...
- Question 104: RMAN is connected to a target database instance and an auxil...
- Question 105: In your multitenant container database (CDB) that contains p...
- Question 106: Which two statements are true about setting the FAST_START_M...
- Question 107: Which two statements are true about unified auditing?...
- Question 108: Which two statements are true about recovering logically cor...
- Question 109: Examine the command to create a pluggable database (PDB): SQ...
- Question 110: Evaluate these statements: CREATE TABLE purchase_orders ( po...
- Question 111: Consider the following scenario for your database: Backup op...
- Question 112: Examine the command: SQL> RECOVER DATABASE USING BACKUP C...
- Question 113: You issue the RMAN command: RMAN> BACKUP SECTION SIZE 300...
- Question 114: The CATDBI2c database contains an Oracle Database 12c catalo...
- Question 115: You regularly take backups of your database using RMAN with ...
- Question 116: Which three conditions must be true for unused block compres...
- Question 117: You are required to migrate your 11.2.0.3 database to an Ora...
- Question 118: Which two options can be configured for an existing database...
- Question 119: Identify three reasons for using a recovery catalog with Rec...
- Question 120: Your database is running in ARCHIVELOG mode. You use RMAN to...
- Question 121: In which three scenarios is media recovery required?...
- Question 122: Which two are prerequisites for creating a backup-based dupl...
- Question 123: You enable Flashback Data Archive for a table for which you ...
- Question 124: Examine the following steps of privilege analysis for checki...
- Question 125: Which three statements are true about compression of backup ...
- Question 126: You are administering a multitenant container database (CDB)...
- Question 127: Examine the RMAN command: (Exhibit) Which statement is true ...
- Question 128: Examine the steps to configure Oracle Secure Backup (OSB) fo...
- Question 129: You are administering a multitenant container database (CDB)...
- Question 130: You want to capture column group usage and gather extended s...
- Question 131: Which two statements are true about dropping a pluggable dat...
- Question 132: You install "Oracle Grid Infrastructure for a standalone ser...
- Question 133: Which two are prerequisites for performing Flashback Transac...
- Question 134: Examine the command used to perform an incremental level-0 b...
- Question 135: As part of a manual upgrade process, after installing the so...
- Question 136: Which three types of failures are detected by the Data Recov...
- Question 137: Which two statements are true about scheduling operations in...
- Question 138: Automatic Shared Memory Management (ASMm) is enabled for you...
- Question 139: For your database, an incremental level 1 backup is taken ev...
- Question 140: Examine the command: (Exhibit) Which statement is true about...
- Question 141: Examine the resources consumed by a database instance whose ...
- Question 142: Your Oracle 12c multitenant container database (CDB) contain...
- Question 143: Which three tasks can be automatically performed by the Auto...
- Question 144: Your multitenant container database (CDB) CDB1 has two plugg...
- Question 145: Which three requirements must be met before a tablespace can...
- Question 146: You wish to create jobs to satisfy these requirements: 1. Au...
- Question 147: In which three situations must you use a recovery catalog?...
- Question 148: Which three statements are true about Flashback Data Archive...
- Question 149: Which three statements correctly describe the relationship a...
- Question 150: Examine the command to duplicate a database: RMAN> DUPLIC...
- Question 151: Examine the command and its output: SQL> DROP TABLE EMPLO...
- Question 152: Examine the RMAN commands: RMAN> CONNECT TARGET "sbu@prod...
- Question 153: You issue the RMAN commands: RMAN> CONFIGURE DEFAULT DEVI...
- Question 154: You want to migrate your Oracle 11g database as a pluggable ...
- Question 155: Which statement is true about Enterprise Manager (EM) expres...
- Question 156: Examine the output: SQL > ARCHIVE LOG LIST Database log m...
- Question 157: Examine the following set of RMAN commands: RKAN> CONFIGU...
- Question 158: You create two Resource Manager plans, one for night time wo...
- Question 159: Examine the commands: SQL> ALTER SESSION SET RECYCLBIN = ...
- Question 160: View the Exhibit showing steps to create a database resource...
- Question 161: You created a database with DBCA by using one of the Oracle ...
- Question 162: Examine the steps/operations performed during the RMAN backu...
- Question 163: What can be automatically implemented after the SQL Tuning A...
- Question 164: You are required to migrate your 11.2.0.3 database to an Ora...
- Question 165: Which two are prerequisites for setting up Flashback Data Ar...
- Question 166: You use RMAN to take regular backups for your database. Exam...
- Question 167: Which two statements are true regarding Oracle Data Pump?...
- Question 168: The CATDB12cdatabase contains an Oracle Database version 12c...
- Question 169: Which statement is true about the ALTER SESSION SET CONTAINE...
- Question 170: Your database is running in archivelog mode. Examine the par...
- Question 171: Which three statements are true about common roles?...
- Question 172: In a database supporting an OLTP workload, tables are freque...
- Question 173: Your database supports a Decision Support System (DSS) workl...
- Question 174: Which two statements are true about encrypted backups perfor...
- Question 175: Which three statements are true about Consolidated Database ...
- Question 176: You want to migrate your Oracle 11g database as a pluggable ...
- Question 177: Which three statements are true regarding the use of the Dat...
- Question 178: Which two statements are true regarding SecureFile lobs?...
- Question 179: RMAN is configured to create backupset backups for your data...
- Question 180: Your database has a table customer that contains the columns...
- Question 181: Which parameter must be set to which value to implement auto...
- Question 182: Your database is running in archivelog mode and regular nigh...
- Question 183: Because of logical corruption of data in a table, you want t...
- Question 184: You notice performance degradation in your production Oracle...
- Question 185: Which three statements are true about the startup and shutdo...
- Question 186: Which two statements are true about roles in multitenant con...
- Question 187: You want RMAN to make duplicate copies of data files when us...
- Question 188: Examine the list of possible steps to transport a tablespace...
- Question 189: Which two statements describe the relationship between a win...
- Question 190: Your multitenant container database (CDB) cdb1 that is runni...
- Question 191: While performing database backup to tape via the media manag...
- Question 192: Examine the probable steps involved in the basic backup proc...
- Question 193: You are administering a multitenant container database (CDB)...
- Question 194: You notice a performance change in your production Oracle 12...
- Question 195: You are administering a multitenant container database (COB)...
- Question 196: Which two operations are NOT performed by the DUPLICATE comm...
- Question 197: You are administering a multitenant container database (CDB)...
- Question 198: Users report this error message when inserting rows into the...
- Question 199: Which three conditions must be met before you create a Virtu...
- Question 200: You accidentally drop the CUSTOMERStable, and then recover i...
- Question 201: Your database is running in archivelog mode. Examine the ini...
- Question 202: Your database supports an online transaction processing (OLT...
- Question 203: For which three pieces of information can you use the RMAN l...
- Question 204: You need to perform a block media recovery on the tools01.db...
- Question 205: Your multitenant container database (CDB) contains multiple ...
- Question 206: A database is running in archivelog mode. The database conta...
- Question 207: Which three statements are true about the SQL*Loader utility...
- Question 208: You notice that the performance of your production 24/7 Orac...
- Question 209: Your database is running in archivelog mode and Automatic Un...
- Question 210: In your database, the tbs percent used parameter is set to 6...
- Question 211: Examine these Data Pump commands to export and import object...
- Question 212: RMAN is connected to the target database prod1 and an auxili...
- Question 213: You want to back up a database such that only formatted bloc...
- 1 commentQuestion 214: You want to reduce fragmentation and reclaim unused space fo...
- Question 215: Examine the RMAN command: RMAN> SET ENCRYPTION IDENTIFIED...
- Question 216: In your database, there are tablespaces that were read-only ...
- Question 217: Your multitenant container database (CDB) cdb1, which has no...
- Question 218: You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parame...
- Question 219: You create a new database by using the CREATE DATABASEcomman...
- Question 220: Which three RMAN persistent settings can be set for a databa...
- Question 221: In CDB$ROOTof your multitenant container database (CDB), you...
- Question 222: You are administering a multitenant container database (CDB)...
- Question 223: Which Oracle Database component is audited by default if the...
- Question 224: Which three statements are true about a job chain?...
- Question 225: You execute the commands to configure settings in RMAN: (Exh...
- Question 226: Examine the RMAN command: RMAN> BACKUP VALIDATE DATABASE;...
- Question 227: After implementing full Oracle Data Redaction, you change th...
- Question 228: You want to consolidate databases for the CRM, ERP, and SCM ...
- Question 229: Which two are direct benefits of the multiprocess, multithre...
- Question 230: Which two can be backed up by using RMAN in a database that ...
- Question 231: You want to create a duplicate database DUP_DB from your pro...
