Oracle.1z0-063.v2019-01-09.q140

Exam Code:1z0-063
Exam Name:Oracle Database 12c: Advanced Administration
Certification Provider:Oracle
Free Question Number:140
Version:v2019-01-09
Rating:
# of views:228
# of Questions views:5675
Start Practice Test

LEAVE A REPLY

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

Other Version
583 viewsOracle.1z0-063.v2018-04-26.q231
Exam Question List
Question 1: Examine the probable steps involved in the basic backup proc...
Question 2: You create a new database by using the CREATE DATABASEcomman...
Question 3: A database instance uses an SPFILE. Examine the parameter: (...
Question 4: You must unload data from the orders, order_items, and produ...
Question 5: In your database, there are tablespaces that were read-only ...
Question 6: You execute the commands on a multitenant container database...
Question 7: Which three requirements should be successfully met by an Or...
Question 8: Your database is running in archivelog mode and regular nigh...
Question 9: Which three statements are true about the startup and shutdo...
Question 10: Your database is running on the host OUSERVER. You back up y...
Question 11: Which two statements are true regarding the Oracle Data Pump...
Question 12: Which three statements correctly describe the relationship a...
Question 13: Which three tasks can be automatically performed by the Auto...
Question 14: You regularly take backups of your database using RMAN with ...
Question 15: In which three scenarios is media recovery required? (Choose...
Question 16: For your database, an incremental level 1 backup is taken ev...
Question 17: Your database instance is started using an SPFILE. You are c...
Question 18: You want to create a guaranteed restore point for your datab...
Question 19: You are required to migrate your 11.2.0.3 database to an Ora...
Question 20: Which two statements are true regarding Oracle Data Pump? (C...
Question 21: Which three statements are true about Oracle Secure Backup (...
Question 22: You execute the commands to configure settings in RMAN: (Exh...
Question 23: Which three statements are true about the database instance ...
Question 24: Examine the command to duplicate a database: RMAN> DUPLIC...
Question 25: You are administering a multitenant container database (CDB)...
Question 26: You are connected to a pluggable database (PDB) as a common ...
Question 27: Your database is running in ARCHIVELOGmode. Examine the init...
Question 28: Which four actions are possible during an Online Datafile Mo...
Question 29: In which situation can you use Flashback Database?...
Question 30: Which two statements are true about Resource Manager plans f...
Question 31: Which three RMAN persistent settings can be set for a databa...
Question 32: Which two methods can be used to add an Oracle 11g database ...
Question 33: Which two can be backed up by using RMAN in a database that ...
Question 34: Identify three benefits of unified auditing. (Choose three.)...
Question 35: A telecom company wishes to generate monthly bills to includ...
Question 36: Examine the output: SQL > ARCHIVE LOG LIST Database log m...
Question 37: Which two statements are true about dropping a pluggable dat...
Question 38: You are administering a multitenant container database (CDB)...
Question 39: The CATDB12Cdatabase contains an Oracle Database 12c catalog...
Question 40: Examine the steps/operations performed during the RMAN backu...
Question 41: Your database supports a Decision Support System (DSS) workl...
Question 42: Examine the commands executed in CDB$ROOT of your multitenan...
Question 43: Which three conditions must be true for unused block compres...
Question 44: The CATDB12cdatabase contains an Oracle Database version 12c...
Question 45: You have installed two 64G flash devices to support the Data...
Question 46: Identify two scenarios in which the RMAN crosscheck command ...
Question 47: Your multitenant container database (CDB) contains multiple ...
Question 48: Which two statements are true about a common user? (Choose t...
Question 49: You execute the RMAN commands: RMAN> BACKUP VALIDATE DATA...
Question 50: Examine the RMAN commands executed in your database: RMAN&gt...
Question 51: You create a default Flashback Data Archive FLA1 and enable ...
Question 52: You are connected to a recovery catalog and target database....
Question 53: RMAN is connected to a target database instance and an auxil...
Question 54: You notice that the performance of your production 24x7 Orac...
Question 55: Evaluate these statements: CREATE TABLE purchase_orders (po_...
Question 56: You are administering a multitenant container database (CDB)...
Question 57: You install "Oracle Grid Infrastructure for a standalone ser...
Question 58: You want to back up a database such that only formatted bloc...
Question 59: You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parame...
Question 60: Which statement is true about the loss or damage of a temp f...
Question 61: While performing database backup to tape via the media manag...
Question 62: You are administering a multitenant container database (COB)...
Question 63: You execute the command to recover your database: (Exhibit) ...
Question 64: Which three statements are true about the SQL*Loader utility...
Question 65: You want to migrate your Oracle 11g database as a pluggable ...
Question 66: Which Oracle Database component is audited by default if the...
Question 67: You use RMAN with a recovery catalog to back up your databas...
Question 68: You issue commands in SQL*Plus as the Oracle owner, to enabl...
Question 69: You are administering a database that supports data warehous...
Question 70: On your Oracle 12c database, you invoke SQL*Loader to load d...
Question 71: You are administering a multitenant container database (CDB)...
Question 72: user_data is a non-encrypted tablespace containing tables wi...
Question 73: After implementing full Oracle Data Redaction, you change th...
Question 74: Which three statements are true about unplugging a pluggable...
Question 75: Your production database is running in archivelog mode. You ...
Question 76: Which statement is true about Enterprise Manager (EM) expres...
Question 77: Examine the command used to perform an incremental level-0 b...
Question 78: A database is running in archivelog mode. You want to back u...
Question 79: Your multitenant container database (CDB) cdb1 that is runni...
Question 80: Examine the command to create a pluggable database (PDB): SQ...
Question 81: Which two are direct benefits of the multiprocess, multithre...
Question 82: Examine the backup requirement for your company: 1) Every Su...
Question 83: Which two statements are true about a multitenant architectu...
Question 84: Which two statements are true about setting the FAST_START_M...
Question 85: You want to migrate your Oracle 11g database as a pluggable ...
Question 86: Examine the following steps of privilege analysis for checki...
Question 87: Which two statements are true about making RMAN image copies...
Question 88: Which two statements are true about tablespaces in multitena...
Question 89: Your multitenant container database (CDB) cdb1, which has no...
Question 90: You specified the warning and critical thresholds for a loca...
Question 91: Your database is running in archivelog mode and a nightly ba...
Question 92: You are administering a multitenant container database (CDB)...
Question 93: Examine the commands executed to monitor database operations...
Question 94: View the Exhibit showing steps to create a database resource...
Question 95: In a database supporting an OLTP workload, tables are freque...
Question 96: You notice that the performance of your production 24/7 Orac...
Question 97: You plan to duplicate the multitenant container database (CD...
Question 98: In CDB$ROOTof your multitenant container database (CDB), you...
Question 99: You are administering a multitenant container database (CDB)...
Question 100: Automatic Undo Management is enabled for your database. You ...
Question 101: You created a tablespace with this statement: CREATE BIGFILE...
Question 102: You want to reduce fragmentation and reclaim unused space fo...
Question 103: Which three methods can be used to create a pluggable databa...
Question 104: You issue the command: SQL> ALTER DATABASE BACKUP CONTROL...
Question 105: In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS. You rename...
Question 106: Examine the commands: SQL> ALTER SESSION SET RECYCLEBIN =...
Question 107: Which two are prerequisites for creating a backup-based dupl...
Question 108: Users report this error message when inserting rows into the...
Question 109: In your multitenant container database (CDB) that contains p...
Question 110: Which two statements describe the relationship between a win...
Question 111: You issue the RMAN commands: RMAN> CONFIGURE DEFAULT DEVI...
Question 112: Your multitenant container database (CDB) CDB1that is runnin...
Question 113: In which three situations must you use a recovery catalog? (...
Question 114: Examine the command to back up the ASM metadata: ASMCMD>m...
Question 115: Your database is running in noarchivelog mode. One of the da...
Question 116: What can be automatically implemented after the SQL Tuning A...
Question 117: Your database has a table CUSTOMERSthat contains the columns...
Question 118: Which two options can be configured for an existing database...
Question 119: Examine the resources consumed by a database instance whose ...
Question 120: Examine these Data Pump commands to export and import object...
Question 121: You want to consolidate databases for the CRM, ERP, and SCM ...
Question 122: For which two requirements would you use the Database Resour...
Question 123: Automatic Shared Memory Management (ASMm) is enabled for you...
Question 124: Which three requirements must be met before a tablespace can...
Question 125: Examine the command: (Exhibit) Which statement is true about...
Question 126: As part of a manual upgrade process, after installing the so...
Question 127: Which three statements are true about the keystore storage f...
Question 128: You need to perform a block media recovery on the tools01.db...
Question 129: Which three statements are true about common roles? (Choose ...
Question 130: LDAP_DIRECTORY_SYSAUTH is set to YES. Users requiring DBAs a...
Question 131: When is the UNDO_RETENTIONparameter value ignored by a trans...
Question 132: Which statement is true about the ALTER SESSION SET CONTAINE...
Question 133: Examine the list of possible steps to transport a tablespace...
Question 134: You want to create a duplicate database DUP_DB from your pro...
Question 135: Which two statements are true about the Automatic Diagnostic...
Question 136: You wish to enable an audit policy for all database users, e...
Question 137: Which three statements are true regarding the use of the Dat...
Question 138: Identify three reasons for using a recovery catalog with Rec...
Question 139: You accidentally drop the CUSTOMERStable, and then recover i...
Question 140: View the SPFILE parameter settings in the Exhibit. (Exhibit)...