- Home
- Oracle
- Oracle Database 12c: Advanced Administration
- Oracle.1z0-063.v2018-04-26.q231
- Question 87
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 87/231
Examine the parameters for your database instance:
NAMETYPEVALUE
- -----------------------------------------------
optimizer_adaptive_reporting_onlybooleanFALSE
optimizer_capture_sql_plan_baselinesbooleanFALSE
optimizer_dynamic_samplinginteger2
optimizer_features_enablestring12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?
NAMETYPEVALUE
- -----------------------------------------------
optimizer_adaptive_reporting_onlybooleanFALSE
optimizer_capture_sql_plan_baselinesbooleanFALSE
optimizer_dynamic_samplinginteger2
optimizer_features_enablestring12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?
Correct Answer: A,C,D
Explanation/Reference:
Explanation:
C: During the first execution of a SQL statement, an execution plan is generated as usual.
D: if multi-column statistics are not present for the relevant combination of columns, the optimizer can fall back on cardinality feedback.
(not B)* Cardinality feedback. This feature, enabled by default in 11.2, is intended to improve plans for repeated executions.
optimizer_dynamic_sampling
optimizer_features_enable
Dynamic sampling or multi-column statistics allow the optimizer to more accurately estimate selectivity of conjunctive predicates.
Note:
* OPTIMIZER_DYNAMIC_SAMPLING controls the level of dynamic sampling performed by the optimizer.
Range of values. 0 to 10
Cardinality feedback was introduced in Oracle Database 11gR2. The purpose of this feature is to automatically improve plans for queries that are executed repeatedly, for which the optimizer does not estimate cardinalities in the plan properly. The optimizer may misestimate cardinalities for a variety of reasons, such as missing or inaccurate statistics, or complex predicates. Whatever the reason for the misestimate, cardinality feedback may be able to help.
Explanation:
C: During the first execution of a SQL statement, an execution plan is generated as usual.
D: if multi-column statistics are not present for the relevant combination of columns, the optimizer can fall back on cardinality feedback.
(not B)* Cardinality feedback. This feature, enabled by default in 11.2, is intended to improve plans for repeated executions.
optimizer_dynamic_sampling
optimizer_features_enable
Dynamic sampling or multi-column statistics allow the optimizer to more accurately estimate selectivity of conjunctive predicates.
Note:
* OPTIMIZER_DYNAMIC_SAMPLING controls the level of dynamic sampling performed by the optimizer.
Range of values. 0 to 10
Cardinality feedback was introduced in Oracle Database 11gR2. The purpose of this feature is to automatically improve plans for queries that are executed repeatedly, for which the optimizer does not estimate cardinalities in the plan properly. The optimizer may misestimate cardinalities for a variety of reasons, such as missing or inaccurate statistics, or complex predicates. Whatever the reason for the misestimate, cardinality feedback may be able to help.
- 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...
