As a leading IT exam study material provider, CertBus not only provides you the 1Z0-060 exam questions and answers but also the most comprehensive knowledge of the whole Oracle Database 1Z0-060 Upgrade to Oracle Database 12c certifications. We provide our users with the most accurate 1Z0-060 Upgrade to Oracle Database 12c study material about the Oracle Database 1Z0-060 exam and the guarantee of pass. We assist you to get well prepared for Oracle Database 1Z0-060 certification which is regarded valuable the IT sector.
We CertBus has our own expert team. They selected and published the latest 1Z0-060 preparation materials from Oracle Official Exam-Center: http://www.certgod.com/1Z0-060.html
QUESTION NO:50
You upgraded your database from pre-12c to a multitenant container database (CDB)
containing pluggable databases (PDBs).
Examine the query and its output:
Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM
privilege to the password file?
A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the
FORCE argument set to No.
D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and
FORCE arguments set to Yes.
E. Re-create the password file in the Oracle Database 12c format.
Answer: B,D
Explanation:
* orapwd
/ You can create a database password file using the password file creation utility,
ORAPWD.
The syntax of the ORAPWD command is as follows:
orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}]
[DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}]
[SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname]
force – whether to overwrite existing file (optional),
* v$PWFILE_users
/ 12c: V$PWFILE_USERS lists all users in the password file, and indicates whether the
user has been granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and
SYSKM privileges.
/ 10c: sts users who have been granted SYSDBA and SYSOPER privileges as derived
from the password file.
ColumnDatatypeDescription
USERNAMEVARCHAR2(30)The name of the user that is contained in the password file
SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges
SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges
Incorrect:
not E: The format of the v$PWFILE_users file is already in 12c format.
QUESTION NO:34
Examine the following command:
CREATE TABLE (prod_id number(4),
Prod_name varchar2 (20),
Category_id number(30),
Quantity_on_hand number (3) INVISIBLE);
Which three statements are true about using an invisible column in the PRODUCTS table?
A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the
invisible column in the output.
B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the
output.
C. Referential integrity constraint cannot be set on the invisible column.
D. The invisible column cannot be made visible and can only be marked as unused.
E. A primary key constraint can be added on the invisible column.
Answer: A,B,E
Explanation: AB: You can make individual table columns invisible. Any generic access of
a table does not show the invisible columns in the table. For example, the following
operations do not display invisible columns in the output:
* SELECT * FROM statements in SQL
* DESCRIBE commands in SQL*Plus
* %ROWTYPE attribute declarations in PL/SQL
* Describes in Oracle Call Interface (OCI)
Incorrect:
Not D:You can make invisible columns visible.
You can make a column invisible during table creation or when you add a column to a
table, and you can later alter the table to make the same column visible.
Reference: Understand Invisible Columns
QUESTION NO:63
You executed a DROP USER CASCADE on an Oracle 11g release 1 database and
immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP
schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has
been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the
OCP schema?
A. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME
TO OCP.EXAM_RESULTS; connected as SYSTEM.
B. Recover the table using traditional Tablespace Point In Time Recovery.
C. Recover the table using Automated Tablespace Point In Time Recovery.
D. Recovery the tableusing Database Point In Time Recovery.
E. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME
TO EXAM_RESULTS; connected as the OCP user.
Answer: C
Explanation: RMAN tablespace point-in-time recovery (TSPITR).
Recovery Manager (RMAN) TSPITR enables quick recovery of one or more tablespaces in
a database to an earlier time without affecting the rest of the tablespaces and objects in the
database.
Fully Automated (the default)
In this mode, RMAN manages the entire TSPITR process including the auxiliary instance.
You specify the tablespaces of the recovery set, an auxiliary destination, the target time,
and you allow RMAN to manage all other aspects of TSPITR.
The default mode is recommended unless you specifically need more control over the
location of recovery set files after TSPITR, auxiliary set files during TSPITR, channel
settings and parameters or some other aspect of your auxiliary instance.
QUESTION NO:3
Which two statements are true about the use of the procedures listed in the
v$sysaux_occupants.move_procedure column?
A. The procedure may be used for some components to relocate component data to the
SYSAUX tablespace from its current tablespace.
B. The procedure may be used for some components to relocate component data from the
SYSAUX tablespace to another tablespace.
C. All the components may be moved into SYSAUX tablespace.
D. All the components may be moved from the SYSAUX tablespace.
Answer: A,B
QUESTION NO:45
You notice a high number of waits for the db file scattered read and db file sequential read
events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further
investigation, you find that queries are performing too many full table scans and indexes
are not being used even though the filter columns are indexed.
Identify three possible reasons for this.
A. Missing or stale histogram statistics
B. Undersized shared pool
C. High clustering factor for the indexes
D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
E. Oversized buffer cache
Answer: A,C,D
Explanation: D: DB_FILE_MULTIBLOCK_READ_COUNT is one of the parameters you
can use to minimize I/O during table scans. It specifies the maximum number of blocks
read in one I/O operation during a sequential scan. The total number of I/Os needed to
perform a full table scan depends on such factors as the size of the table, the multiblock
read count, and whether parallel execution is being utilized for the operation.
QUESTION NO:55
Your database supports an online transaction processing (OLTP) application. The
application is undergoing some major schema changes, such as addition of new indexes
and materialized views. You want to check the impact of these changes on workload
performance.
What should you use to achieve this?
A. Database replay
B. SQL Tuning Advisor
C. SQL Access Advisor
D. SQL Performance Analyzer
E. Automatic Workload Repository compare reports
Answer: E
Explanation: While an AWR report shows AWR data between two snapshots (or two
points in time), the AWR Compare Periods report shows the difference between two
periods (or two AWR reports with a total of four snapshots). Using the AWR Compare
Periods report helps you to identify detailed performance attributes and configuration
settings that differ between two time periods.
Reference: Resolving Performance Degradation Over Time
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.
Answer: A,C,D
Explanation: 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.
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:6
Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has
two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for
the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF
data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB
is corrupted.
What should you do before executing the commands to restore and recover the data file in
ACCOUNTS_PDB?
A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in
ACCOUNTS_PDB.
B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE
accounts_pdb CLOSE IMMEDIATE command.
C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.
D. Take the USERDATA tablespace offline in ACCOUNTS_PDB.
Answer: D
Explanation: * You can take an online tablespace offline so that it is temporarily
unavailable for general use. The rest of the database remains open and available for users
to access data. Conversely, you can bring an offline tablespace online to make the schema
objects within the tablespace available to database users. The database must be open to
alter the availability of a tablespace.
QUESTION NO:18
You database is running an ARCHIVELOG mode.
The following parameter are set in your database instance:
LOG_ARCHIVE_FORMAT = arch %t_%r.arc
LOG_ARCHIVE_DEST_1 =
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.
Answer: B
Explanation: * 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 values0 to 11
CertBus exam braindumps are pass guaranteed. We guarantee your pass for the 1Z0-060 exam successfully with our Oracle materials. CertBus Upgrade to Oracle Database 12c exam PDF and VCE are the latest and most accurate. We have the best Oracle in our team to make sure CertBus Upgrade to Oracle Database 12c exam questions and answers are the most valid. CertBus exam Upgrade to Oracle Database 12c exam dumps will help you to be the Oracle specialist, clear your 1Z0-060 exam and get the final success.
1Z0-060 Latest questions and answers on Google Drive(100% Free Download): https://drive.google.com/file/d/0B_3QX8HGRR1mTi1zVzc0bzNQTFE/view?usp=sharing
1Z0-060 Oracle exam dumps (100% Pass Guaranteed) from CertBus: http://www.certgod.com/1Z0-060.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.