As a leading IT exam study material provider, CertBus not only provides you the 1Z0-062 exam questions and answers but also the most comprehensive knowledge of the whole 1Z0-062 Oracle Database 12c: Installation and Administration certifications. We provide our users with the most accurate 1Z0-062 Oracle Database 12c: Installation and Administration study material about the 1Z0-062 exam and the guarantee of pass. We assist you to get well prepared for 1Z0-062 certification which is regarded valuable the IT sector.
We CertBus has our own expert team. They selected and published the latest 1Z0-062 preparation materials from Oracle Official Exam-Center: http://www.certgod.com/1Z0-062.html
QUESTION NO:64
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user
executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2,
v_SALARY NUMBER, v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from
inserting values into tables on which they do not have any privileges?
A. Create the CREATE_TEST procedure with definer\’s rights.
B. Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
C. Create the CREATE_TEST procedure with invoker\’s rights.
D. Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege
the package.
Correct Answer: C
Explanation
Explanation/Reference:
If a program unit does not need to be executed with the escalated privileges of the definer, you should
specify that the program unit executes with the privileges of the caller, also known as the invoker. Invoker\’s
rights can mitigate the risk of SQL injection.
Incorrect:
Not A: By default, stored procedures and SQL methods execute with the privileges of their owner, not their
current user. Such definer-rights subprograms are bound to the schema in which they reside.
not B: Using the GRANT option, a user can grant an Object privilege to another user or to PUBLIC.
QUESTION NO:126
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?
A. Database operations will be monitored only when they consume a significant amount of resource.
B. Database operations for all sessions will be monitored.
C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL
and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC TUNING.
D. Only DML and DDL statements will be monitored for the session.
E. All subsequent statements in the session will be treated as one database operation and will be
ExamReal.com — 100% Real QandAs | 100% Real Pass
monitored.
Correct Answer: CE
Explanation
Explanation/Reference:
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 NO:101
Examine the parameters for your database instance:
Which three statements are true about the process of automatic optimization by using cardinality
feedback?
A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is
a huge difference in optimizer estimates and execution statistics.
B. The optimizer can re optimize a query only once using cardinality feedback.
C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are
enabled.
E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors
are submitted to the optimizer.
Correct Answer: ACD
Explanation
Explanation/Reference:
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.
ExamReal.com — 100% Real QandAs | 100% Real Pass
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 NO:89
Which three tasks can be automatically performed by the Automatic Data Optimization feature of
Information lifecycle Management (ILM)?
A. Tracking the most recent read time for a table segment in a user tablespace
B. Tracking the most recent write time for a table segment in a user tablespace
C. Tracking insert time by row for table rows
D. Tracking the most recent write time for a table block
E. Tracking the most recent read time for a table segment in the SYSAUX tablespace
F. Tracking the most recent write time for a table segment in the SYSAUX tablespace
Correct Answer: ABD
Explanation
Explanation/Reference:
Incorrect:
Not E, Not F When Heat Map is enabled, all accesses are tracked by the in-memory activity tracking
module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and
modification.
Heat Map provides data access tracking at the segment-level and data modification tracking at the
segment and row level.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and
modification. You can also use Automatic Data Optimization (ADO) to automate the compression and
movement of data between different tiers of storage within the database.
Reference: Automatic Data Optimization with Oracle Database 12c with Oracle Database 12c
QUESTION NO:49
Which three statements are true about Automatic Workload Repository (AWR)?
A. All AWR tables belong to the SYSTEM schema.
B. The AWR data is stored in memory and in the database.
C. The snapshots collected by AWR are used by the self-tuning components in the database
D. AWR computes time model statistics based on time usage for activities, which are displayed in the
v$SYS time model and V$SESS_TIME_MODEL views.
E. AWR contains system wide tracing and logging information.
Correct Answer: BCE
Explanation
Explanation/Reference:
* A fundamental aspect of the workload repository is that it collects and persists database performance
data in a manner that enables historical performance analysis. The mechanism for this is the AWR
snapshot. On a periodic basis, AWR takes a “snapshot” of the current statistic values stored in the
database instance\’s memory and persists them to its tables residing in the SYSAUX tablespace.
* AWR is primarily designed to provide input to higherlevel components such as automatic tuning
algorithms and advisors, but can also provide a wealth of information for the manual tuning process.
QUESTION NO:59
Examine the parameter for your database instance:
You generated the execution plan for the following query in the plan table and noticed that the nested loop
join was done. After actual execution of the query, you notice that the hash join was done in the execution
plan:
Identify the reason why the optimizer chose different execution plans.
A. The optimizer used a dynamic plan for the query.
B. The optimizer chose different plans because automatic dynamic sampling was enabled.
C. The optimizer used re-optimization cardinality feedback for the query.
D. The optimizer chose different plan because extended statistics were created for the columns used.
Correct Answer: B
Explanation
Explanation/Reference:
* optimizer_dynamic_sampling
OPTIMIZER_DYNAMIC_SAMPLING controls both when the database gathers dynamic statistics, and the
size of the sample that the optimizer uses to gather the statistics.
Range of values 0 to 11
QUESTION NO:114
You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
` /mydir/rman_change_track.f\’;
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
ExamReal.com — 100% Real QandAs | 100% Real Pass
Which three statements are true?
A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
B. The change tracking file must always be backed up when you perform a full database backup.
C. Block change tracking will always reduce I/O performed during cumulative incremental backups.
D. More than one database block may be read by an incremental backup for a change made to a single
block.
E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not
read the change tracking file to discover changed blocks.
Correct Answer: ADE
Explanation
Explanation/Reference:
A: In a cumulative level 1 backup, RMAN backs up all the blocks used since the most recent level 0
incremental backup.
E: Oracle Block Change Tracking
Once enabled; this new 10g feature records the modified since last backup and stores the log of it in a
block change tracking file using the CTW (Change Tracking Writer) process. During back- ups RMAN uses
the log file to identify the specific blocks that must be backed up. This improves RMAN\’s performance as it
does not have to scan whole datafiles to detect changed blocks. Log- ging of changed blocks is performed
by the CTRW process which is also responsible for writing data to the block change tracking file.
Note:
* An incremental level 0 backup backs up all blocks that have ever been in use in this database.
QUESTION NO:81
You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER
SUCCESSFUL;
Which statement is true about the audit record that generated when auditing after instance restarts?
A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE
command on a table, and contains the SQL text for the SQL Statements.
B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE
command, and contains the execution plan for the SQL statements.
C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or
DELETE command, and contains the execution plan for the SQL statements.
D. One audit record is created for the whole session if JOHN successfully executes a select command,
and contains the SQL text and bind variables used.
E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or
DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
Correct Answer: A
Explanation
Explanation/Reference:
Note:
* BY SESSION
In earlier releases, BY SESSION caused the database to write a single record for all SQL statements or
operations of the same type executed on the same schema objects in the same session. Beginning with
this release (11g) of Oracle Database, both BY SESSION and BY ACCESS cause Oracle Database to
write one audit record for each audited statement and operation.
* BY ACCESS
Specify BY ACCESS if you want Oracle Database to write one record for each audited statement and
operation.
Note:
If you specify either a SQL statement shortcut or a system privilege that audits a data definition language
(DDL) statement, then the database always audits by access. In all other cases, the database honors the
BY SESSION or BY ACCESS specification.
* For each audited operation, Oracle Database produces an audit record containing this information:
/ The user performing the operation
/ The type of operation
/ The object involved in the operation
/ The date and time of the operation
ExamReal.com — 100% Real QandAs | 100% Real Pass
Reference: Oracle Database SQL Language Reference 12c
QUESTION NO:122
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable
response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns?
A. The index remains invisible.
B. The index is not updated by the DML statements on the indexed table.
C. The index automatically becomes visible in order to have it updated by DML on the table.
D. The index becomes unusable but the table is updated by the DML.
E. The index is updated by the DML on the table.
Correct Answer: AE
Explanation
Explanation/Reference:
Unlike unusable indexes, an invisible index is maintained during DML statements.
Note:
* Oracle 11g allows indexes to be marked as invisible. Invisible indexes are maintained like any other
index, but they are ignored by the optimizer unless the
OPTIMIZER_USE_INVISIBLE_INDEXES parameter is set to TRUE at the instance or session level.
Indexes can be created as invisible by using the INVISIBLE keyword, and their visibility can be toggled
using the ALTER INDEX command.
ExamReal.com — 100% Real QandAs | 100% Real Pass
QUESTION NO:33
Which three statements are true concerning unplugging a pluggable database (PDB)?
A. The PDB must be open in read only mode.
B. The PDB must be dosed.
ExamReal.com — 100% Real QandAs | 100% Real Pass
C. The unplugged PDB becomes a non-CDB.
D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
E. The unplugged PDB can be plugged into another CDB.
F. The PDB data files are automatically removed from disk.
Correct Answer: BDE
Explanation
Explanation/Reference:
B, not A: The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode
information in an endianness-sensitive way. There is no supported way to handle the conversion of such
columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an
endianness difference.
E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the
source and destination CDBs should share a filesystem so that the PDB\’s datafiles can remain in place.
Reference: Oracle White Paper, Oracle Multitenant
CertBus exam braindumps are pass guaranteed. We guarantee your pass for the 1Z0-062 exam successfully with our Oracle materials. CertBus Oracle Database 12c: Installation and Administration exam PDF and VCE are the latest and most accurate. We have the best Oracle in our team to make sure CertBus Oracle Database 12c: Installation and Administration exam questions and answers are the most valid. CertBus exam Oracle Database 12c: Installation and Administration exam dumps will help you to be the Oracle specialist, clear your 1Z0-062 exam and get the final success.
1Z0-062 Latest questions and answers on Google Drive(100% Free Download): https://drive.google.com/file/d/0B_3QX8HGRR1mMDVWOHdFb1p1UlE/view?usp=sharing
1Z0-062 Oracle exam dumps (100% Pass Guaranteed) from CertBus: http://www.certgod.com/1Z0-062.html [100% Exam Pass Guaranteed]
Why select/choose CertBus?
Millions of interested professionals can touch the destination of success in exams by certgod.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.