Oracle.1z0-062.v2019-04-25.q208

Exam Code:1z0-062
Exam Name:Oracle Database 12c: Installation and Administration
Certification Provider:Oracle
Free Question Number:208
Version:v2019-04-25
Rating:
# of views:148
# of Questions views:2645
Start Practice Test

LEAVE A REPLY

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

Other Version
375 viewsOracle.1z0-062.v2018-11-27.q216
635 viewsOracle.1z0-062.v2018-04-27.q190
761 viewsOracle.1z0-062.v2018-03-09.q165
Exam Question List
Question 1: Your database instance has started using an SPFILE. Examine ...
Question 2: Your production database PRODuses file system storage. You w...
Question 3: Backup requirements for a database: * Level 0 backup on Sund...
Question 4: Which Oracle Database component is audited by default if the...
Question 5: Examine the following commands for redefining a table with V...
Question 6: You create a table with the PERIOD FOR clause to enable the ...
Question 7: What is the result of executing a TRUNCATE TABLE command on ...
Question 8: Which three statements are true about the working of system ...
Question 9: Your multitenant container database (CDB) contains a pluggab...
Question 10: You plan to install the Oracle Database 12c software. You wa...
Question 11: Which three statements are true regarding the use of the Dat...
Question 12: On your Oracle Database, you issue the following commands to...
Question 13: Which statement is true about using the Export/Import method...
Question 14: Which two statements are true about standard database auditi...
Question 15: Which two statements describe the relationship between a sch...
Question 16: You support Oracle Database 12c Oracle Database 11g, and Ora...
Question 17: You use the segment advisor to help determine objects for wh...
Question 18: In order to exploit some new storage tiers that have been pr...
Question 19: Unified auditing is enabled in your database. The HR_ADMINan...
Question 20: Which two statements are true about the RMAN validate databa...
Question 21: A user establishes a connection to a database instance by us...
Question 22: Which two statements are true when row archival management i...
Question 23: Your database is configured in ARCHIVELOGmode, and a daily f...
Question 24: Examine the parameters: (Exhibit) Users complain that their ...
Question 25: You are required to migrate your 11.2.0.3 database as a plug...
Question 26: Which three statements are true about SQL plan directives? (...
Question 27: A redaction policy was added to the SAL column of the SCOTT....
Question 28: The HRuser owns the BONUSEStable. HRgrants privileges to the...
Question 29: Which two statements are true about the (PMON) background pr...
Question 30: You executed this command to create a password file: $ orapw...
Question 31: You are connected to a pluggable database (PDB) as a common ...
Question 32: A warehouse fact table in your Oracle 12c Database is range-...
Question 33: Which two statements are true about Oracle Data Pump export ...
Question 34: Which two statements are true about the Database Configurati...
Question 35: Your database has the SRV1 service configured for an applica...
Question 36: Which four statements are true about the components of the O...
Question 37: You are administering a database and you receive a requireme...
Question 38: In your database, the STATISTICS_LEVELparameter is set to TY...
Question 39: Which three activities are supported by the Data Recovery Ad...
Question 40: Your database is open in read/write mode and multiple users ...
Question 41: You execute the following PL/SQL: (Exhibit) Which two statem...
Question 42: Which statement is true about the loss of a data file belong...
Question 43: You plan to migrate your database from a File system to Auto...
Question 44: In your Database, the TBS PERCENT USED parameter is set to 6...
Question 45: Which two statements are true about using SQL*Loader? (Choos...
Question 46: Which two statements are true about Oracle network connectio...
Question 47: Your database supports a Decision Support System (DSS) workl...
Question 48: Identify two prerequisites for configuring Enterprise Manage...
Question 49: Which three functions can be performed by the SQL Tuning Adv...
Question 50: SMD is a smallfile locally managed tablespace with manual se...
Question 51: You want to schedule a job to rebuild a table's indexes afte...
Question 52: You Execute the Following command to create a password file ...
Question 53: Which two statements are true concerning the Resource Manage...
Question 54: For which three requirements would you use the Database Reso...
Question 55: You are about to plug a multi-terabyte non-CDB into an exist...
Question 56: A senior DBA asked you to execute the following command to i...
Question 57: Which two options can be configured for an existing database...
Question 58: You configure your database Instance to support shared serve...
Question 59: Examine the parameters for your database instance: (Exhibit)...
Question 60: You find this query being used in your Oracle 12c database: ...
Question 61: You plan to upgrade your Oracle Database 9i to Oracle Databa...
Question 62: In your production database, data manipulation language (DML...
Question 63: Which four actions are possible during an Online Data file M...
Question 64: You enabled an audit policy by issuing the following stateme...
Question 65: Which two statements are true about the Oracle Direct Networ...
Question 66: Which two partitioned table maintenance operations support a...
Question 67: Which three statements are true about space usage alerts? (C...
Question 68: In your database, you want to ensure that idle sessions that...
Question 69: What is the benefit of running the catctl.plscript during an...
Question 70: An application repeatedly accesses small lookup tables, caus...
Question 71: Which two categories of segments are analyzed by the Automat...
Question 72: Your multitenant container database has three pluggable data...
Question 73: Identify three uses of the CROSSCHECKcommand (Choose three.)...
Question 74: Your database instance has the following parameter setting: ...
Question 75: Examine these two statements: (Exhibit) Which three are true...
Question 76: Your database is running in NOARCHIVLOGmode. Examine the fol...
Question 77: What is pre-requisite to alter a role?...
Question 78: You have altered a non-unique index to be invisible to deter...
Question 79: You want to flash back a test database by five hours. You is...
Question 80: Which two would you recommend to an application developer fo...
Question 81: You install Oracle Grid Infrastructure for a standalone serv...
Question 82: Which three tools or tasks are run by default as part automa...
Question 83: Which two statements are true about the Automatic Database D...
Question 84: Which three statements are true concerning the multitenant a...
Question 85: Which two statements are true about Automatic Storage Manage...
Question 86: You determine that database performance is sub-optimal due t...
Question 87: What action must you take to ensure complete database recove...
Question 88: Which three operations can be performed as multipartition op...
Question 89: Which two statements are true about a server parameter file ...
Question 90: You notice that the elapsed time for an important database s...
Question 91: Automatic Shared Memory Management (ASMM) is enabled for you...
Question 92: Your database is open and the LISTENER listener running. You...
Question 93: You execute this command: (Exhibit) Which two statements are...
Question 94: Identify three scenarios in which you would recommend the us...
Question 95: Examine the details of the Top 5 Timed Events in the followi...
Question 96: You execute the following piece of code with appropriate pri...
Question 97: Your database has been running with a peak load for the past...
Question 98: Identify two situations in which the alert log file is updat...
Question 99: Which three statements are true about checkpointing? (Choose...
Question 100: Which statement is true about unified auditing?...
Question 101: Which four operations performed after the Oracle Restart ins...
Question 102: You plan to implement the distributed database system in you...
Question 103: You performed an incremental level 0 backup of a database: R...
Question 104: Examine the command: (Exhibit) Which statement is true?...
Question 105: You have successfully taken a database backup by using the c...
Question 106: Your database instance has Automatic Memory Management enabl...
Question 107: Which three statements are true about Automatic Workload Rep...
Question 108: You run a script that completes successfully using SQL*Plus ...
Question 109: Which two statements are true about Automatic Database Diagn...
Question 110: You create an Oracle 12c database and then import schemas th...
Question 111: Which two statements are true about availability audit featu...
Question 112: In your database instance, the UNDO_RETENTIONparameter is se...
Question 113: Which three tasks can be automatically performed by the Auto...
Question 114: Which statement is true about Enterprise Manager (EM) expres...
Question 115: Which statement is true about the Oracle central inventory d...
Question 116: Which three statements are true about server-generated alert...
Question 117: Examine the parameters: Your database instance is started wi...
Question 118: Which two are prerequisites for performing a flashback trans...
Question 119: Identify three situations in which messages are written to t...
Question 120: Automatic Shared Memory Management is enabled for your datab...
Question 121: Examine the following command: SQL> DBMS_STATS. SET_TABLE...
Question 122: Which two statements are true about SQL *Loader Express Mode...
Question 123: Your multitenant container (CDB) contains two pluggable data...
Question 124: When is the UNDO_RETENTIONparameter value ignored by a trans...
Question 125: Examine the query and its output executed In an RDBMS Instan...
Question 126: Which three statements are true about Database Resource Mana...
Question 127: In your Oracle 12c database, you invoke SQL *Loader Express ...
Question 128: You are administering a database that supports an OLTP workl...
Question 129: Examine the command: SQL> ALTER SYSTEM SET ENABLE_DDL_LOG...
Question 130: You administer an online transaction processing (OLTP) syste...
Question 131: Examine the parameter settings in your local ORCLdatabase: (...
Question 132: Your multitenant container (CDB) containing three pluggable ...
Question 133: You execute the following commands to audit database activit...
Question 134: You use a recovery catalog for maintaining your database bac...
Question 135: You executed the following command to create a password file...
Question 136: Examine the commands executed to monitor database operations...
Question 137: You want to create a database with a block size other than t...
Question 138: You are managing an Oracle Database 12c database. The databa...
Question 139: In your database, the RESOURCE_LIMIT parameter is set to TRU...
Question 140: Which statement is true about profiles?...
Question 141: Which three statements are true about Oracle Restart? (Choos...
Question 142: Which statement is true about using the Database Upgrade Ass...
Question 143: Which three statements are true about naming methods? (Choos...
Question 144: Which three are direct benefits of the multiprocess, multith...
Question 145: Examine the following steps: A DBA grants the CREATETABLEsys...
Question 146: Which three statements are true about Oracle Data Pump? (Cho...
Question 147: The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES t...
Question 148: You have the following entry in the tnsnames.ors of your hq....
Question 149: You want to create a table, DAILY_ORDERS, for an OLTP applic...
Question 150: Your database is in NOARCHIVELOG mode. You want to enable ar...
Question 151: Identify the access that is initially available to connect t...
Question 152: Which three statements are true about using flashback databa...
Question 153: Which component resides in the System Global Area (SGA) of a...
Question 154: Which set of statements is true about data dictionary views?...
Question 155: In your multitenant container database (CDB) containing same...
Question 156: Your database supports an online transaction processing (OLT...
Question 157: Which three statements are true about Flashback Database? (C...
Question 158: Your multitenant container database (CDB) contains some plug...
Question 159: What is the effect of setting the STATISTICS_LEVEL initializ...
Question 160: Your single-instance Oracle 12c database home currently supp...
Question 161: You want to load data from a large file into your database w...
Question 162: What is the outcome of the SHUTDOWN ABORT command?...
Question 163: Examine the following command; ALTER SYSTEM SET enable_ddl_l...
Question 164: The HRuser updates the salary of one of the employees in the...
Question 165: In which two scenarios do you use SQL* Loader to load data? ...
Question 166: You install "Oracle Grid Infrastructure for a standalone ser...
Question 167: Identify three benefits of Unified Auditing....
Question 168: Which statement is true about Oracle Net Listener?...
Question 169: Which three are activities performed by SMON? (Choose three....
Question 170: You upgraded from a previous Oracle database version to Orac...
Question 171: You are using RMAN to back up your database. All the data fi...
Question 172: Flashback is enabled for your multitenant container database...
Question 173: Your database is running in ARCHIVELOGmode. You want to take...
Question 174: Your database is configured in ARCHIVELOGmode, and daily ful...
Question 175: A database uses Automatic Storage Management (ASM) as databa...
Question 176: Which two statements are true about Oracle Data Pump export ...
Question 177: Which task is performed by a background process in a databas...
Question 178: You install a non-RAC Oracle Database. During Installation, ...
Question 179: You are administering a database stored in Automatic Storage...
Question 180: The user SCOTT owns the CUST table that is placed in the SAL...
Question 181: Which two statements are true about resumable space allocati...
Question 182: You want to upgrade an Oracle Database running Oracle Databa...
Question 183: Your multitenant container database, CDB1, is running in ARC...
Question 184: Your multitenant container database (CDB) contains pluggable...
Question 185: As part of a manual upgrade of your database to Oracle Datab...
Question 186: Which three statements are true when the listener handles co...
Question 187: When does a database checkpoint occur?...
Question 188: The persistent configuration settings for RMAN have default ...
Question 189: The performance of your database degrades between 11:00 AM a...
Question 190: Which three statements are true about Enterprise Manager Dat...
Question 191: Oracle Grid Infrastructure for a stand-alone server is insta...
Question 192: You are connected using SQL* Plus to a multitenant container...
Question 193: You want to create a file watcher and an event-based job for...
Question 194: Your database is configured for ARCHIVELOGmode, and a daily ...
Question 195: You want to create a test database as a replica of your prod...
Question 196: In which situations does the Database Writer process (DBWn) ...
Question 197: You created an encrypted tablespace: (Exhibit) You then clos...
Question 198: Which two statements are true about the use of the procedure...
Question 199: A database is stored in an Automatic Storage Management (ASM...
Question 200: Identify three valid methods of opening, pluggable databases...
Question 201: On your Oracle 12c database, you Issue the following command...
Question 202: In your multitenant container database (CDB) with two plugga...
Question 203: Which two files must you copy from the Oracle home of the da...
Question 204: You have a production Oracle 12c database running on a host....
Question 205: Which statement is true about redo log files during instance...
Question 206: Which three resources might be prioritized between competing...
Question 207: Your database is in ARCHIVELOG mode and you want to automate...
Question 208: You want to import the schema objects of the HRuser from the...