Valid 1Z0-060 Dumps shared by ExamDiscuss.com for Helping Passing 1Z0-060 Exam! ExamDiscuss.com now offer the newest 1Z0-060 exam dumps, the ExamDiscuss.com 1Z0-060 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1Z0-060 dumps with Test Engine here:
Access 1Z0-060 Dumps Premium Version
(205 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 30/150
Examine the commands executed to monitor database operations:
$ > conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid:= DBMS_SQL_MONITOR.BEGIN_OPERATION ('batch_job',
FORCED_TRACKING => 'Y');
Which two statements are true? (Choose two.)
$ > conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid:= DBMS_SQL_MONITOR.BEGIN_OPERATION ('batch_job',
FORCED_TRACKING => 'Y');
Which two statements are true? (Choose two.)
Correct Answer: C,E
Explanation/Reference:
Explanation:
C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC
+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.
Note:
* The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real- time Database Operation Monitoring.
*(not B) BEGIN_OPERATION Function starts a composite database operation in the current session.
/(E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts. You can also use the string variable 'Y'.
/(not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable 'N'.
Explanation:
C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC
+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.
Note:
* The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real- time Database Operation Monitoring.
*(not B) BEGIN_OPERATION Function starts a composite database operation in the current session.
/(E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts. You can also use the string variable 'Y'.
/(not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable 'N'.
- Question List (150q)
- Question 1: Your database is open and the LISTENERlistener running. You ...
- Question 2: You are administering a database and you receive a requireme...
- Question 3: What is the effect of specifying the "ENABLE PLUGGABLE DATAB...
- Question 4: Which two statements are true when row archival management i...
- Question 5: Which three activities are supported by the Data Recovery Ad...
- Question 6: Which statement is true about Oracle Net Listener?...
- Question 7: What are two benefits of installing Grid Infrastructure soft...
- Question 8: Which two statements are true about the use of the procedure...
- 1 commentQuestion 9: You notice a performance change in your production Oracle 12...
- Question 10: You use a recovery catalog for maintaining your database bac...
- Question 11: You are connected using SQL* Plus to a multitenant container...
- Question 12: In your multitenant container database (CDB) containing plug...
- Question 13: Your multitenant container database, CDB1, is running in ARC...
- Question 14: Your multitenant container database (CDB) contains pluggable...
- Question 15: In a recent Automatic Workload Repository (AWR) report for y...
- Question 16: To implement Automatic Management (AMM), you set the followi...
- Question 17: In your multitenant container database (CDB) containing same...
- Question 18: Your multitenant container database (CDB) contains three plu...
- Question 19: Which three statements are true about Oracle Data Pump expor...
- Question 20: Your multitenant container database has three pluggable data...
- Question 21: You execute the following piece of code with appropriate pri...
- Question 22: Your database is running an ARCHIVELOGmode. The following pa...
- 1 commentQuestion 23: You want to upgrade your pre-12c database to an Oracle 12c d...
- Question 24: You want to capture column group usage and gather extended s...
- Question 25: Identify three benefits of Unified Auditing....
- Question 26: Which three resources might be prioritized between competing...
- Question 27: You are administering a database stored in Automatic Storage...
- Question 28: You notice that the performance of your production 24/7 Orac...
- Question 29: What is the result of executing a TRUNCATE TABLEcommand on a...
- Question 30: Examine the commands executed to monitor database operations...
- Question 31: On your Oracle Database, you issue the following commands to...
- Question 32: Examine the contents of SQL loader control file: (Exhibit) W...
- Question 33: Identify three scenarios in which you would recommend the us...
- Question 34: You support Oracle Database 12c Oracle Database 11g, and Ora...
- Question 35: Which three statements are true concerning the multitenant a...
- Question 36: Examine the following query output: (Exhibit) You issue the ...
- Question 37: Examine the following command: CREATE TABLE (prod_id number(...
- Question 38: You configure your database Instance to support shared serve...
- Question 39: You are administering a database stored in Automatic Storage...
- Question 40: Which two statements are true about the Oracle Direct Networ...
- Question 41: You created an encrypted tablespace: (Exhibit) You then clos...
- Question 42: Examine the following commands for redefining a table with V...
- Question 43: Examine the parameters for your database instance: (Exhibit)...
- Question 44: Examine the following command: ALTER SYSTEM SET enable_ddl_l...
- Question 45: The following parameters are set for your Oracle 12c databas...
- Question 46: Examine the following steps of privilege analysis for checki...
- Question 47: Which three statements are true regarding the use of the Dat...
- Question 48: Your multitenant container (CDB) contains two pluggable data...
- Question 49: You enabled an audit policy by issuing the following stateme...
- Question 50: The persistent configuration settings for RMAN have default ...
- Question 51: Examine the query and its output executed In an RDBMS Instan...
- Question 52: Which three are direct benefits of the multiprocess, multith...
- Question 53: Examine the following parameters for a database instance: (E...
- Question 54: You wish to enable an audit policy for all database users, e...
- Question 55: After implementing full Oracle Data Redaction, you change th...
- Question 56: Which three statements are true about the working of system ...
- Question 57: On your Oracle 12c database, you invoked SQL*Loader to load ...
- Question 58: Flashback is enabled for your multitenant container database...
- Question 59: You notice a high number of waits for the db file scattered ...
- Question 60: You find this query being used in your Oracle 12c database: ...
- Question 61: You are planning the creation of a new multitenant container...
- Question 62: In order to exploit some new storage tiers that have been pr...
- Question 63: You are administering a database stored in Automatic Storage...
- Question 64: To enable the Database Smart Flash Cache, you configure the ...
- Question 65: You performed an incremental level 0 backup of a database: R...
- Question 66: Your multitenant container database (CDB) is running in ARCH...
- Question 67: You created a new database using the "create database" state...
- Question 68: Which two statements are true concerning the Resource Manage...
- Question 69: Which three statements are true about SQL plan directives?...
- Question 70: You execute a DROP USER CASCADEon an Oracle 11g release 1 da...
- Question 71: Examine the details of the Top 5 Timed Events in the followi...
- Question 72: Identify two valid options for adding a pluggable database (...
- Question 73: You create a table with the PERIOD FORclause to enable the u...
- Question 74: In which two scenarios do you use SQL* Loader to load data?...
- Question 75: A warehouse fact table in your Oracle 12c Database is range-...
- Question 76: Which two statements are true about Enterprise Manager (EM) ...
- Question 77: Which three statements are true about Flashback Database? (C...
- Question 78: Which two are direct benefits of the multiprocess, multithre...
- Question 79: Which two statements are true when the listener handles conn...
- Question 80: Which three statements are true about adaptive SQL plan mana...
- Question 81: You have altered a non-unique index to be invisible to deter...
- Question 82: Which statement is true concerning dropping a pluggable data...
- Question 83: A senior DBA asked you to execute the following command to i...
- Question 84: Which two partitioned table maintenance operations support a...
- Question 85: Which three operations can be performed as multipartition op...
- Question 86: You conned using SQL Plus to the root container of a multite...
- Question 87: An administrator account is granted the CREATE SESSIONand SE...
- Question 88: Which statement is true about Enterprise Manager (EM) expres...
- Question 89: You create a new pluggable database, HR_PDB, from the seed d...
- Question 90: Your database has the SRV1 service configured for an applica...
- Question 91: Your multitenant container (CDB) containing three pluggable ...
- Question 92: Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PRE...
- Question 93: Which Oracle Database component is audited by default if the...
- Question 94: The tnsnames.ora file has an entry for the service alias ORC...
- Question 95: You must configure Oracle Data Redaction for the EMP table t...
- Question 96: In your multitenant container database (CDB) with two plugga...
- Question 97: You executed this command to create a password file: $ orapw...
- Question 98: Which two are true concerning a multitenant container databa...
- Question 99: You upgrade your Oracle database in a multiprocessor environ...
- Question 100: You install a non-RAC Oracle Database. During Installation, ...
- Question 101: Examine the following impdp command to import a database ove...
- Question 102: Identify two situations in which the alert log file is updat...
- Question 103: You plan to use the In-Database Archiving feature of Oracle ...
- Question 104: Which two statements are true about Oracle Managed Files (OM...
- Question 105: Examine the parameter for your database instance: (Exhibit) ...
- Question 106: Which two statements are true about variable extent size sup...
- Question 107: You notice a performance change in your production Oracle da...
- Question 108: You plan to migrate your database from a File system to Auto...
- Question 109: You find this query being used in your Oracle 12c database: ...
- Question 110: Identify three valid methods of opening, pluggable databases...
- Question 111: Which two are prerequisites for performing a flashback trans...
- Question 112: You are about to plug a multi-terabyte non-CDB into an exist...
- Question 113: What are three purposes of the RMAN "FROM" clause?...
- Question 114: Which two statements are true about the RMAN VALIDATE DATABA...
- Question 115: A database is stored in an Automatic Storage Management (ASM...
- Question 116: Which three functions are performed by the SQL Tuning Adviso...
- Question 117: Your multitenant container database (CDB) contains some plug...
- Question 118: Which four actions are possible during an Online Data file M...
- Question 119: You execute the following commands to audit database activit...
- Question 120: A new report process containing a complex query is written, ...
- Question 121: You upgraded your database from pre-12c to a multitenant con...
- Question 122: You notice that the elapsed time for an important database s...
- Question 123: You Execute the Following command to create a password file ...
- Question 124: You upgraded from a previous Oracle database version to Orac...
- Question 125: In your multitenant container database (CDB) that contains p...
- Question 126: You administer an online transaction processing (OLTP) syste...
- Question 127: A redaction policy was added to the SALcolumn of the SCOTT.E...
- Question 128: You are the DBA supporting an Oracle 11g Release 2 database ...
- Question 129: Which three features work together, to allow a SQL statement...
- Question 130: Your database supports a DSS workload that involves the exec...
- Question 131: Identify two correct statements about multitenant architectu...
- Question 132: Which three statements are true concerning unplugging a plug...
- Question 133: In your multitenant container database (CDB) containing plug...
- Question 134: In your database, you want to ensure that idle sessions that...
- Question 135: You execute the following PL/SQL: (Exhibit) Which two statem...
- Question 136: You use the segment advisor to help determine objects for wh...
- Question 137: Your multitenant container database (CDB) contains a pluggab...
- Question 138: Which three are true about the large pool for an Oracle data...
- Question 139: Which three statements are true about using flashback databa...
- Question 140: You have installed two 64G flash devices to support the Data...
- Question 141: On your Oracle 12c database, you issue the following command...
- Question 142: You enabled an audit policy by issuing the following stateme...
- Question 143: Your database supports an online transaction processing (OLT...
- Question 144: Which three statements are true when the listener handles co...
- Question 145: You want to flash back a test database by five hours. You is...
- Question 146: Oracle Grid Infrastructure for a stand-alone server is insta...
- Question 147: You must track all transactions that modify certain tables i...
- Question 148: Which two statements are true when row-archival management i...
- Question 149: Examine the current values for the following parameters in y...
- Question 150: You are connected to a pluggable database (PDB) as a common ...
