oracle 1z0-060 practice test

Upgrade to Oracle Database 12c Exam


Question 1

Examine the memory-related parameters of an Oracle database instance:

Which statement is true?

  • A. The value of the memory_target parameter cannot be changed dynamically.
  • B. PGA size is limited to a maximum of 500 MB.
  • C. Only the components of SGA are managed automatically.
  • D. Memory is dynamically re-allocated between SGA and PGA as needed.
Answer:

D

Explanation:
Reference:
https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN11200

Discussions

Question 2

In your database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data
movement?

  • A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
  • B. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
  • C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
  • D. Setting the target tablespace to read-only after the segments are moved
  • E. Taking the target tablespace offline after the segments are moved
Answer:

C D

Discussions

Question 3

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED
container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this? (Choose three.)

  • A. Use Oracle Managed Files (OMF).
  • B. Specify the SEED FILE_NAME_CONVERT clause.
  • C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.
  • D. Specify the DB_FILE_NAME_CONVERT initialization parameter.
  • E. Specify all files names in the CREATE DATABASE statement without using Oracle managed Files (OMF).
Answer:

A B C

Explanation:
You must specify the names and locations of the seed's files in one of the following ways:
* (A) Oracle Managed Files
* (B) The SEED FILE_NAME_CONVERT Clause
* (C) The PDB_FILE_NAME_CONVERT Initialization Parameter

Discussions

Question 4

In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following
commands in the root container:

Which two statements are true?

  • A. The C # # ROLE1 role is created in the root database and all the PDBs.
  • B. The C # # ROLE1 role is created only in the root database because the container clause is not used.
  • C. Privileges are granted to the C##A_ADMIN user only in the root database.
  • D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
  • E. The statement for granting a role to a user fails because the CONTAINER clause is not used.
Answer:

A C

Explanation:
* You can include the CONTAINER clause in several SQL statements, such as the CREATE USER, ALTER USER,
CREATE ROLE, GRANT, REVOKE, and ALTER SYSTEM statements.
* * CREATE ROLE with CONTAINER (optional) clause/ CONTAINER = ALL
Creates a common role.
/ CONTAINER = CURRENT
Creates a local role in the current PDB.

Discussions

Question 5

Which two statements are true about variable extent size support for large ASM files?

  • A. The metadata used to track extents in SGA is reduced.
  • B. Rebalance operations are completed faster than with a fixed extent size.
  • C. An ASM Instance automatically allocates an appropriate extent size.
  • D. Resync operations are completed faster when a disk comes online after being taken offline.
  • E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.
Answer:

A C

Explanation:
A: Variable size extents enable support for larger ASM datafiles, reduce SGA memory requirements for very large databases
(A), and improve performance for file create and open operations.
C: You don't have to worry about the sizes; the ASM instance automatically allocates the appropriate extent size.
Note:
* The contents of ASM files are stored in a disk group as a set, or collection, of data extents that are stored on individual
disks within disk groups. Each extent resides on an individual disk. Extents consist of one or more allocation units (AU).
Toaccommodate increasingly larger files, ASM uses variable size extents.
* The size of the extent map that defines a file can be smaller by a factor of 8 and 64 depending on the file size. The initial
extent size is equal to the allocation unit size and it increases by a factor of 8 and 64 at predefined thresholds. This feature
isautomatic for newly created and resized datafiles when the disk group compatibility attributes are set to Oracle Release 11
or higher.

Discussions

Question 6

Your database is running an ARCHIVELOG mode.
The following parameters are set in your database instance:

Which statement is true about the archived redo log files?

  • A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
  • B. They are created only in the Fast Recovery Area because configuring the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters automatically enables flashback for the database.
  • C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
  • D. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the location specified by the DB_RECOVERY_FILE_DEST parameter.
Answer:

A

Explanation:
You can choose to archive redo logs to a single destination or to multiple destinations.
Destinations can be localwithin the local file system or an Oracle Automatic Storage Management (Oracle ASM) disk
groupor remote (on a standby database). When you archive to multiple destinations, a copy of each filled redo log file is
written to each destination. These redundant copies help ensure that archived logs are always available in the event of a
failure at one of the destinations.
To archive to only a single destination, specify that destination using the LOG_ARCHIVE_DEST and
LOG_ARCHIVE_DUPLEX_DEST initialization parameters.
ARCHIVE_DEST initialization parameter. To archive to multiple destinations, you can choose to archive to two or more
locations using the LOG_ARCHIVE_DEST_n initialization parameters, or to archive only to a primary and secondary
destination using the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters.

Discussions

Question 7

You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE
DATABASE" clause.
What are two effects of not using the "ENABLE PLUGGABLE database" clause?

  • A. The database is created as a non-CDB and can never contain a PDB.
  • B. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).
  • C. The database is created as a non-CDB and can never be plugged into a CDB.
  • D. The database is created as a non-CDB but can be plugged into an existing CDB.
  • E. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.
Answer:

A D

Explanation:
A (not B, not E): The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you
do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never
contain PDBs.
D: You can create a PDB by plugging in a Non-CDB as a PDB. The following graphic depicts the options for creating a PDB:

Incorrect Answers:
E: For the duration of its existence, a database is either a CDB or a non-CDB. You cannot transform a non-CDB into a CDB
or vice versa. You must define a database as a CDB at creation, and then create PDBs within this CDB.

Discussions

Question 8

Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is
damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which
three steps should you perform to recover the control file and make the database fully operational? (Choose three.)

  • A. Mount the container database (CDB) and restore the control file from the control file autobackup.
  • B. Recover and open the CDB in NORMAL mode.
  • C. Mount the CDB and then recover and open the database, with the RESETLOGS option.
  • D. Open all the pluggable databases.
  • E. Recover each pluggable database.
  • F. Start the database instance in the nomount stage and restore the control file from control file autobackup.
Answer:

C D F

Explanation:
Step 1: Start the database instance in the nomount stage and restore the control file from control file auto backup Step 2:
Open all the pluggable databases.
Step 3: If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file.
You must then run the RECOVER command, even if no data files have been restored, and open the database with the
RESETLOGS option.
Note:
* RMAN and Oracle Enterprise Manager Cloud Control (Cloud Control) provide full support for backup and recovery in a
multitenant environment. You can back up and recover a whole multitenant container database (CDB), root only, or one or
more pluggable databases (PDBs).

Discussions

Question 9

You are administering a database stored in Automatic Storage Management (ASM). One of the ASM
disks is dropped because of hardware failure. You replace the failed disk and want the resulting
rebalance operations to occur with minimal impact on database performance.
Which two settings will help to maintain consistent database performance during the rebalance?
A. Decrease the value of the disk_repair_time attribute for the disk group.
B. Increase the number of slave DBWR processes by setting a higher value for dbwrioslaves.
C. Increase the number of DBWR processes by setting a higher value for db_writer_processes.
D. Increase the number of ARB processes by setting a higher value for asm_power_limit.
118/119
Questions & Answers PDF
P-
E. Define the power option while adding or removing the disks.
F. Increase the number of RBAL processes.

  • A. 1 and 3
  • B. 1 and 5
  • C. 1 and 2
  • D. only 6
  • E. 1 and 4
  • F. only 2
Answer:

BD
119/119

Discussions

Question 10

In which two scenarios is an RMAN recovery catalog automatically resynchronized?

  • A. The AUGUST_SALES tablespace is created with its data file in the DB_CREATE_FILE_DEST location and the TEMP101 tablespace is created with its temp file in the '/u01/app/oracle/mydata' location.
  • A. when a registered database is opened with the resetlogs option
  • B. The TEMP101 tablespace is created with its temp file in the DB_CREATE_FILE_DEST location and the AUGUST_SALES tablespace is created with its data file in the '/u01/app/oracle/mydata/mysales.dbf' location.
  • B. when the backup retention policy configuration is changed for a registered database
  • C. The two tablespaces are created with the data file and temp file in their respective locations as specified in the CREATE commands.
  • C. when a redo log Is archived
  • D. Tablespace creation ignores the data file and temp file locations specified in the CREATE commands, and creates both the tablespaces in the DB_CREATE_FILE_DEST location.
  • D. when a manual redo log switch is performed
  • E. when backup metadata records are aged out of the control file based on the control_file_record_keep_time parameter value
Answer:

CD

Discussions
To page 2