Limited Time Discount Offer 30% Off - Ends in 02:00:00


Oracle 1z0-060 Exam - Upgrade to Oracle Database 12c

Purchase Individually

  • Premium File

    205 Questions & Answers
    Last Update: Feb 10, 2020

  • Study Guide

    269 Pages


Download Free Oracle 1z0-060 Exam Questions

Questions & Answers for Oracle 1z0-060

Showing 1-15 of 150 Questions

Question #1

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2,
and PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database?

A. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container

B. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

C. BACKUP DATABASE while connected to the PDB1 container

D. BACKUP DATABASE while connected to the boot container

E. BACKUP PLUGGABLE database PDB1 while connected to PDB2

Explanation: To perform operations on a single PDB, you can connect as target either to
the root or directly to the PDB.
* (A) If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your
RMAN commands. For example, to back up a PDB, you use the BACKUP PLUGGABLE
DATABASE command.
* (C)If instead you connect directly to a PDB, you can use the same commands that you
would use when connecting to a non-CDB. For example, to back up a PDB, you would use
the BACKUP DATABASE command.
Reference: Oracle Database Backup and Recovery User's Guide 12c, About Backup and
Recovery of CDBs

Question #2

Which two partitioned table maintenance operations support asynchronous Global Index
Maintenance in Oracle database 12c?







Explanation: Asynchronous Global Index Maintenance for DROP and TRUNCATE
This feature enables global index maintenance to be delayed and decoupled from a DROP
and TRUNCATE partition without making a global index unusable. Enhancements include
faster DROP and TRUNCATE partition operations and the ability to delay index
maintenance to off-peak time.
Reference: Oracle Database VLDB and Partitioning Guide 12c

Question #3

Which three statements are true concerning the multitenant architecture?

A. Each pluggable database (PDB) has its own set of background processes.

B. A PDB can have a private temp tablespace.

C. PDBs can share the sysaux tablespace.

D. Log switches occur only at the multitenant container database (CDB) level.

E. Different PDBs can have different default block sizes.

F. PDBs share a common system tablespace.

G. Instance recovery is always performed at the CDB level.

Explanation: B:
* A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains other
user created tablespaces in it.
* There is one default temporary tablespace for the entire CDB. However, you can create
additional temporary tablespaces in individual PDBs.
* There is a single redo log and a single control file for an entire CDB
* A log switch is the point at which the database stops writing to one redo log file and
begins writing to another. Normally, a log switch occurs when the current redo log file is
completely filled and writing must continue to the next redo log file.
G: instance recovery
The automatic application of redo log records to uncommitted data blocks when an
database instance is restarted after a failure.
Not A:
* There is one set of background processes shared by the root and all PDBs.
* High consolidation density. The many pluggable databases in a single
container database share its memory and background processes, letting you operate
many more pluggable databases on a particular platform than you can single databases
that use the old architecture.
Not C: There is a separate SYSAUX tablespace for the root and for each PDB.
Not F: There is a separate SYSTEM tablespace for the root and for each PDB. -

Question #4

You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

A. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows

B. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.

C. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

D. A TOP-N query is created to limit the rows to 20 percent of the total rows

Question #5

Which two statements are true about the RMAN validate database command?

A. It checks the database for intrablock corruptions.

B. It can detect corrupt pfiles.

C. It can detect corrupt spfiles.

D. It checks the database for interblock corruptions.

E. It can detect corrupt block change tracking files.

Block corruptions can be divided Into Interblock corruption and intrablock corruption. In
intrablock corruption. th corruption occurs within the block itself and can be either physical
or logical corruption. In interblock corruption, the corruption occurs between blocks and can
only be logical corruption.
(key word) * The VALIDATE command checks for intrablock corruptions only. Only
DBVERIFY and the ANALYZE statement detect Interblock corruption.
VALIDATE Command Output > List of Control File and SPFILE.
File TYPE > SPFILE or Control File.
Status > OK if no corruption, or FAILED If block corruption is found.
Blocks Failing The number of blocks that fail the corruption check. These
blocks are newly corrupt.
Blocks Examined Total number of blocks in the file.
Oracle' Database Backup and Recovery User's Guide
12c Release 1 (12.1) - 16 Validating Database Files and Backups

Question #6

Which two statements are true about Oracle Managed Files (OMF)?

A. OMF cannot be used in a database that already has data files created with user- specified directions.

B. The file system directions that are specified by OMF parameters are created automatically.

C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

D. OMF automatically creates unique file names for table spaces and control files.

E. OMF may affect the location of the redo log files and archived log files.

D: The database internally uses standard file system interfaces to create and delete files as
needed for the following database structures:
Redo log files
Control files
Archived logs
Block change tracking files
Flashback logs
RMAN backups
* Using Oracle-managed files simplifies the administration of an Oracle Database. Oracle-
managed files eliminate the need for you, the DBA, to directly manage the operating
system files that make up an Oracle Database. With Oracle-managed files, you specify file
system directories in which the database automatically creates, names, and manages files
at the database object level. For example, you need only specify that you want to create a
tablespace; you do not need to specify the name and path of the tablespace's datafile with
the DATAFILE clause.
Reference: What Are Oracle-Managed Files?

Question #7

You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL
column in the view and the table?

A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

C. Data is never redacted for the EMP_V.SAL column.

D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

* DBMS_REDACT.FULL completely redacts the column data.
* DBMS_REDACT.NONE applies no redaction on the column data. Use this function for
development testing purposes. LOB columns are not supported.
* The DBMS_REDACT package provides an interface to Oracle Data Redaction, which
enables you to mask (redact) data that is returned from queries issued by low-privileged
users or an application.
* If you create a view chain (that is, a view based on another view), then the Data
Redaction policy also applies throughout this view chain. The policies remain in effect all of
the way up through this view chain, but if another policy is created for one of these views,
then for the columns affected in the subsequent views, this new policy takes precedence.

Question #8

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

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.

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 #9

Which statement is true about Oracle Net Listener?

A. It acts as the listening endpoint for the Oracle database instance for all local and non- local user connections.

B. A single listener can service only one database instance and multiple remote client connections.

C. Service registration with the listener is performed by the process monitor (LREG) process of each database instance.

D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

E. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.

Question #10

You executed this command to create a password file:
$ orapwd file = orapworcl entries = 10 ignorecase = N
Which two statements are true about the password file?

A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

B. It contains username and passwords of database users who are members of the OSOPER operating system group.

C. It contains usernames and passwords of database users who are members of the OSDBA operating system group.

D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

E. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

Explanation: * You can create a password file using the password file creation utility,
* Adding Users to a Password File
When you grant SYSDBA or SYSOPER privileges to a user, that user's name and privilege
information are added to the password file. If the server does not have an EXCLUSIVE
password file (that is, if the initialization parameter REMOTE_LOGIN_PASSWORDFILE is
NONE or SHARED, or the password file is missing), Oracle Database issues an error if you
attempt to grant these privileges.
A user's name remains in the password file only as long as that user has at least one of
these two privileges. If you revoke both of these privileges, Oracle Database removes the
user from the password file.
* The syntax of the ORAPWD command is as follows:
ORAPWD FILE=filename [ENTRIES=numusers]
If this argument is set to y, passwords are case-insensitive. That is, case is ignored when
comparing the password that the user supplies during login with the password in the
password file.

Question #11

Identify two valid options for adding a pluggable database (PDB) to an existing multitenant
container database (CDB).

A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.

B. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.

C. Use the DBMS_PDB package to clone an existing PDB.

D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.

E. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 ( non-CDB database into an existing CDB.

Question #12

Which three resources might be prioritized between competing pluggable databases when
creating a multitenant container database plan (CDB plan) using Oracle Database
Resource Manager?

A. Maximum Undo per consumer group

B. Maximum Idle time

C. Parallel server limit


E. Exadata I/O

F. Local file system I/O


Question #13

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The

A. Place the root container in ARHCHIVELOG mode.

B. Take the user data tablespace offline.

C. Place the root container in the nomount stage.

D. Ensure that HR_PDB is open.

Explanation: RMAN> select name,open_mode from v$pdbs;
using target database control file instead of recovery catalogNAME
RMAN> backup tablespace ora12p2:users;
Starting backup at 31-MAR-14allocated channel: ORA_DISK_1channel ORA_DISK_1:
SID=137 device type=DISKchannel ORA_DISK_1: starting full datafile backup setchannel
ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00013
o1_mf_users_9mhr0o5l_.dbfchannel ORA_DISK_1: starting piece 1 at 31-MAR-14channel
ORA_DISK_1: finished piece 1 at 31-MAR-14piece
tag=TAG20140331T001832 comment=NONEchannel ORA_DISK_1: backup set complete,
elapsed time: 00:00:01Finished backup at 31-MAR-14
Starting Control File and SPFILE Autobackup at 31-MAR-14piece
715_9mhzdcv8_.bkp comment=NONEFinished Control File and SPFILE Autobackup at 31-
The above example illustrates that if root container is open and in archivelog it can do the
backup of tablespace whether the pdb is mounted or open.

Question #14

Which three statements are true about adaptive SQL plan management?

A. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

B. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.

C. It adds new, bettor plans automatically as fixed plans to the baseline.

D. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

E. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

Explanation: With adaptive SQL plan management, DBAs no longer have to manually run
the verification or evolve process for non-accepted plans. When automatic SQL tuning is in
COMPREHENSIVE mode, it runs a verification or evolve process for all SQL statements
that have non-accepted plans during the nightly maintenance window. If the non-accepted
plan performs better than the existing accepted plan (or plans) in the SQL plan baseline,
then the plan is automatically accepted and becomes usable by the optimizer. After the
verification is complete, a persistent report is generated detailing how the non-accepted
plan performs compared to the accepted plan performance. Because the evolve process is
now an AUTOTASK, DBAs can also schedule their own evolve job at end time.
* The optimizer is able to adapt plans on the fly by predetermining multiple subplans for
portions of the
* Adaptive plans, introduced in Oracle Database 12c, enable the optimizer to defer the final
plan decision for a statement until execution time. The optimizer instruments its chosen
plan (the default plan) with statistics collectors so that it can detect at runtime, if its
cardinality estimates differ greatly from the actual number of rows seen by the operations in
the plan. If there is a significant difference, then the plan or a portion of it will be
automatically adapted to avoid suboptimal performance on the first execution of a SQL
Reference: SQL Plan Management with Oracle Database 12c

Question #15

You notice that the elapsed time for an important database scheduler Job is unacceptably
The job belongs to a scheduler job class and window.
Which two actions would reduce the job's elapsed time?

A. Increasing the priority of the job class to which the job belongs

B. Increasing the job's relative priority within the Job class to which it belongs

C. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window

D. Moving the job to an existing higher priority scheduler window with the same schedule and duration

E. Increasing the value of the JOB_QUEUE_PROCESSES parameter

F. Increasing the priority of the scheduler window to which the job belongs

Explanation: http://www.dba-

Purchase Individually

  • Premium File

    205 Questions & Answers
    Last Update: Feb 10, 2020

  • Study Guide

    269 Pages


Try Our Special 30% Discount Offer for
Premium 1z0-060 VCE File

  • Verified by experts

1z0-060 Premium File

  • Real Questions
  • Last Update: Feb 10, 2020
  • 100% Accurate Answers
  • Fast Exam Update




You save

Enter Your Email Address to Receive Your 30% Discount Code


You save

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from [email protected] and follow the directions.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

  • Realistic exam simulation and exam editor with preview functions
  • Whole exam in a single file with several different question types
  • Customizable exam-taking mode & detailed score reports