<< Prev Question Next Question >>

Question 58/160

You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.
The statistics_level parameter is PDB modifiable.
As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (160q)
Question 1: Which three statements are true about the keystore storage f...
Question 2: Examine the command to back up the ASM metadata: ASMCMD&gt;m...
Question 3: You are administering a multitenant container database (CDB)...
Question 4: Which three statements are true about the database instance ...
Question 5: Examine the command: SQL&gt; RECOVER DATABASE USING BACKUP C...
Question 6: A complete database backup to media is taken for your databa...
Question 7: You install "Oracle Grid Infrastructure for a standalone ser...
Question 8: Which three conditions must be met before you create a Virtu...
Question 9: Examine the RMAN commands executed in your database: RMAN&gt...
Question 10: Which two statements are true about Flashback Version Query?...
Question 11: Which two statements are true about a multitenant architectu...
Question 12: Examine these Data Pump commands to export and import object...
Question 13: You are required to migrate your 11.2.0.3 database to an Ora...
Question 14: user_data is a nonencryptedtablespace containing tables with...
Question 15: Which two statements are true regarding SecureFile lobs?...
Question 16: You are administering a database that supports data warehous...
Question 17: In a database supporting an OLTP workload, tables are freque...
Question 18: LDAP_DIRECTORY_SYSAUTH is set to YES. Users requiring DBAs a...
Question 19: When is the UNDO_RETENTION parameter value ignored by a tran...
Question 20: For which three pieces of information can you use the RMAN l...
Question 21: Which two resources might be prioritized between competing p...
Question 22: Which three statements are true about the startup and shutdo...
Question 23: Evaluate these statements: CREATE TABLE purchase_orders (po_...
Question 24: Your multitenant container database (CDB) cdb1, which has no...
Question 25: Examine the commands executed in the root container of your ...
Question 26: In the SPFILE, UNDOJTABLESPACEis Set to UNDOTBS. You rename ...
Question 27: You are administering a multitenant container database (CDB)...
Question 28: Which three statements are true about a job chain?...
Question 29: Your Oracle 12c multitenant container database (CDB) contain...
Question 30: Which Oracle Database component is audited by default if the...
Question 31: Which three statements are true about Consolidated Database ...
Question 32: Which three statements are true regarding the use of the Dat...
Question 33: Examine the commands: SQL&gt; ALTER SESSION SET RECYCLBIN = ...
Question 34: You created a database with DBCA by using one of the Oracle ...
Question 35: Identify three scenarios in which RMAN will use backup sets ...
Question 36: Examine the steps/operations performed during the RMAN backu...
Question 37: Which two statements are true about unified auditing?...
Question 38: You set the following parameters in the parameter file and r...
Question 39: Your multitenant container database (CDB) cdb1 that is runni...
Question 40: You specified the warning and critical thresholds for a loca...
Question 41: Identify two scenarios in which the RMAN crosscheck command ...
Question 42: You are administering a multitenant container database (CDB)...
Question 43: Which parameter must be set to which value to implement auto...
Question 44: In which situation can you use Flashback Database?...
Question 45: Which two statements describe the relationship between a win...
Question 46: Your production database is running in archivelog mode. You ...
Question 47: Which two are direct benefits of the multiprocess, multithre...
Question 48: You are administering a database that supports a data wareho...
Question 49: Which statement is true about Enterprise Manager (EM) expres...
Question 50: Which two statements are true about scheduling operations in...
Question 51: Which three tasks can be automatically performed by the Auto...
Question 52: Which three statements are true about Oracle Restart?...
Question 53: As part of a manual upgrade process, after installing the so...
Question 54: You wish to create jobs to satisfy these requirements: 1. Au...
Question 55: You are administering a multitenant container database (CDB)...
Question 56: Examine the command to duplicate a database: RMAN&gt; DUPLIC...
Question 57: While performing database backup to tape via the media manag...
Question 58: You are administering a multitenant container database (COB)...
Question 59: Which three statements are true about the SQL*Loader utility...
Question 60: You want to consolidate databases for the CRM, ERP, and SCM ...
Question 61: You notice a performance change in your production Oracle 12...
Question 62: Examine the command used to perform an incremental level-0 b...
Question 63: Automatic Shared Memory Management (ASMm) is enabled for you...
Question 64: Examine the commands executed to monitor database operations...
Question 65: Which three statements are true about compression of backup ...
Question 66: Your database has a table customers that contains the column...
Question 67: Which three RMAN persistent settings can be set for a databa...
Question 68: Which statement is true about the loss or damage of a temp f...
Question 69: Examine the backup requirement for your company: 1) Every Su...
Question 70: Your database is running in noarchivelog mode. One of the da...
Question 71: Identify three benefits of unified auditing....
Question 72: After implementing full Oracle Data Redaction, you change th...
Question 73: You want to move your existing recovery catalog to another d...
Question 74: View the SPFILE parameter settings in the Exhibit. (Exhibit)...
Question 75: Which two statements are true about Resource Manager plans f...
Question 76: Which four actions are possible during an Online Datafile Mo...
Question 77: Examine the following steps of privilege analysis for checki...
Question 78: You notice that the performance of your production 24x7 Orac...
Question 79: Which three statements correctly describe the relationship a...
Question 80: You execute the RMAN commands: RMAN&gt; BACKUP VALIDATE DATA...
Question 81: Your database is running in archivelog mode. You are taking ...
Question 82: Your multitenant container database (CDB) contains multiple ...
Question 83: What can be automatically implemented after the SQL Tuning A...
Question 84: Which three statements are true about Oracle Secure Backup (...
Question 85: Your multitenant container database (CDB) cdb1 that is runni...
Question 86: You issue commands in SQL*Plus as the Oracle owner, to enabl...
Question 87: Examine the command to create a pluggable database (PDB): SQ...
Question 88: Your database is running in archivelog mode. Examine the par...
Question 89: Your database is running in archivelog mode and regular nigh...
Question 90: In your database, there are tablespaces that were read-only ...
Question 91: You issue the RMAN commands: RMAN&gt; CONFIGURE DEFAULT DEVI...
Question 92: Which three statements are true about unplugging a pluggable...
Question 93: You created a tablespace with this statement: CREATE BIGFILE...
Question 94: Which two statements are true about tablespaces in multitena...
Question 95: Your database supports an OLTP workload. Examine the output ...
Question 96: You want to export the pluggable database (PDB) hr pdb1 from...
Question 97: You notice performance degradation in your production Oracle...
Question 98: Examine the commands executed in CDBS ROOT of your multitena...
Question 99: Examine the RMAN command: RMAN&gt; SET ENCRYPTION IDENTIFIED...
Question 100: You wish to enable an audit policy for all database users, e...
Question 101: Examine the resources consumed by a database instance whose ...
Question 102: Which two statements are true about the Automatic Diagnostic...
Question 103: You want RMAN to make duplicate copies of data files when us...
Question 104: Which two statements are true when row-archival management i...
Question 105: You create two Resource Manager plans, one for night time wo...
Question 106: Identify three reasons for using a recovery catalog with Rec...
Question 107: You want the execution of large database operations to suspe...
Question 108: For your database, an incremental level 1 backup is taken ev...
Question 109: A database is running in archivelog mode. You want to back u...
Question 110: The following parameters are set for your Oracle 12c databas...
Question 111: You create a table with the period for clause to enable the ...
Question 112: Your database is running in archivelog mode. Examine the ini...
Question 113: RMAN is connected to the target database prod1 and an auxili...
Question 114: You want to capture column group usage and gather extended s...
Question 115: Your database supports a Decision Support System (DSS) workl...
Question 116: On your Oracle 12c database, you invoke SQL*Loader to load d...
Question 117: Your database instance is started using an SPFILE. You are c...
Question 118: Which two statements are true about service creation for plu...
Question 119: You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parame...
Question 120: Consider the following scenario for your database: On March ...
Question 121: You create a default Flashback Data Archive FLA1and enable i...
Question 122: Which three types of failures are detected by the Data Recov...
Question 123: A database is running in archive log mode. The database cont...
Question 124: For which two requirements would you use the Database Resour...
Question 125: You are connected to a pluggable database (PDB) as a common ...
Question 126: Which two are prerequisites for setting up Flashback Data Ar...
Question 127: In your database, the tbs percent used parameter is set to 6...
Question 128: Which two statements are true about a common user?...
Question 129: The CATDB12C database contains an Oracle Database 12c catalo...
Question 130: Examine the following set of RMAN commands: RKAN&gt; CONFIGU...
Question 131: You want to create a guaranteed restore point for your datab...
Question 132: Examine the RMAN command: RMAN&gt; CONFIGURE ENCRYPTION FOR ...
Question 133: Which two statements are true regarding Oracle Data Pump?...
Question 134: View the Exhibit showing steps to create a database resource...
Question 135: You want to consolidate backup information and centrally man...
Question 136: Which two statements are true regarding the Oracle Data Pump...
Question 137: You must unload data from the orders, order_items, and produ...
Question 138: Users report this error message when inserting rows into the...
Question 139: You restore and recover your database to a new host by using...
Question 140: Which two methods can be used to add an Oracle 11g database ...
Question 141: You want to back up a database such that only formatted bloc...
Question 142: Your database is running in archivelog mode and a nightly ba...
Question 143: You want to migrate your Oracle 11g database as a pluggable ...
Question 144: Which three requirements must be met before a tablespace can...
Question 145: Examine the parameters for your database instance: NAMETYPEV...
Question 146: Examine the command: $expdp SYSTEM FULL=YES DUMPFILE=dpump_d...
Question 147: You notice that the performance of your production 24/7 Orac...
Question 148: Examine the RMAN command: RMAN&gt; BACKUP VALIDATE DATABASE;...
Question 149: Examine the steps to configure Oracle Secure Backup (OSB) fo...
Question 150: A user issues a query on the sales table and receives the fo...
Question 151: Examine the initialization parameter that is set in the PFIL...
Question 152: In your multitenant container database (CDB) that contains p...
Question 153: You plan to use the In-Database Archiving feature of Oracle ...
Question 154: The environmental variable oracle_Base is set to /u01/app/or...
Question 155: Your database is running in archive log mode and Automatic U...
Question 156: You execute the commands on a multitenant container database...
Question 157: You are administering a multitenant container database (CDB)...
Question 158: Which three conditions must be true for unused block compres...
Question 159: Which two statements are true about dropping a pluggable dat...
Question 160: Which two options can be configured for an existing database...