1Z0-060 Real Exam Questions and Verified Answers

Question 1 Multiple choice

Which three statements are true about RMAN compressed backups?

A
Media manager compression should not be enabled if compressed backups are being written to tape.
B
Compressed backups can be written to media only if using proxy copies.
C
File system compression should be enabled if compressed backups are being written to disk.
D
Compression creates some performance overhead during backups to tape.
E
Compression creates some performance overhead during backups to disk.

Show answer and explanation

Correct answers: B, C, E

Question 2 Multiple choice

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.

Show answer and explanation

Correct answers: B, C, D

Explanation

5.2 Overview of the Automatic Workload Repository
The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views.

The statistics collected and processed by AWR include:

Object statistics that determine both access and usage statistics of database segments Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views

References:
http://docs.oracle.com/cd/B28359_01/server.111/b28274/autostat.htm#PFGRF02601

Question 3 Single choice

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

Show answer and explanation

Correct answer: C

Question 4 Single choice

Which action takes place when an incremental checkpoint occurs?

A
The checkpoint position is advanced by the checkpoint process.
B
Redo entries are written by the checkpoint process to the online redo log files.
C
All dirty buffers are written to data files by the checkpoint process.
D
The checkpoint position is written to all the data file headers and the control file by the checkpoint process.
E
The checkpoint position is written to the control file by the checkpoint process.

Show answer and explanation

Correct answer: C

Explanation

References:
http://www.dba-oracle.com/t_incremental_checkpoint.htm

Question 5 Multiple choice

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.

Show answer and explanation

Correct answers: 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 6 Multiple choice

Which three statements are true concerning the multitenant architecture? (Choose three.)

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.

Show answer and explanation

Correct answers: B, D, G

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.
D:
* 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.
Incorrect Answers:
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.

C: There is a separate SYSAUX tablespace for the root and for each PDB.

F: There is a separate SYSTEM tablespace for the root and for each PDB. -

Question 7 Multiple choice

Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file?

A
An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
B
The SQL* Loader data file myfile1.dat has the column names for the EMP table.
C
The SQL* Loader operation fails because no record terminators are specified.
D
Field names should be the first line in the both the SQL* Loader data files.
E
The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

Show answer and explanation

Correct answers: A, B, E

Explanation

A: The APPEND keyword tells SQL*Loader to preserve any preexisting data in the table. Other options allow you to delete preexisting data, or to fail with an error if the table is not empty to begin with.

B (not D):
Note:
* SQL*Loader-00210: first data file is empty, cannot process the FIELD NAMES record
Cause: The data file listed in the next message was empty. Therefore, the FIELD NAMES FIRST FILE directive could not be processed.
Action: Check the listed data file and fix it. Then retry the operation

E:
* A comma-separated values (CSV) (also sometimes called character-separated values, because the separator character does not have to be a comma) file stores tabular data (numbers and text) in plain-text form. Plain text means that the file is a sequence of characters, with no data that has to be interpreted instead, as binary numbers. A CSV file consists of any number of records, separated by line breaks of
some kind; each record consists of fields, separated by some other character or string, most commonly a literal comma or tab. Usually, all records have an identical sequence of fields.
* Fields with embedded commas must be quoted.
Example:
1997,Ford,E350,"Super, luxurious truck"

Note:
* SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database.

Question 8 Multiple choice

Which three statements are true about using flashback database in a multitenant container database (CDB)?

A
The root container can be flashed back without flashing back the pluggable databases (PDBs).
B
To enable flashback database, the CDB must be mounted.
C
Individual PDBs can be flashed back without flashing back the entire CDB.
D
The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
E
A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

Show answer and explanation

Correct answers: B, D, E

Question 9 Single choice

An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is inadequately sized. You diagnose that this is due to the different kinds of workloads and this occurs only during peak hours. The following are the parameter settings for the database instance:

You want to balance the memory between the System Global Area (SGA) components depending on the workload.

Which option would solve this problem?

A
setting the PGA_AGGREGATE_TARGET parameter to 200M and the SGA_MAX_SIZE parameter to
400M
B
setting the MEMORY_TARGET and SGA_MAX_SIZE parameters to 400M
C
setting the SGA_TARGET parameter to 300M
D
setting the SGA_MAX_SIZE parameter to 400M

Show answer and explanation

Correct answer: C

Question 10 Single choice

Your database runs in NOARCHIVELOG mode.

Whole database backups are taken daily.

A media failure damages data files belonging to the USERS tablespace and the online redo log files.

The hardware that is causing this damage is not repairable.

You issue the SHUTDOWN ABORT command.

Examine these steps:

1. Restore only the damaged files from the whole database backup to a new location.
2. Restore the whole database backup to a new location.
3. Edit the restored initialization parameter file to indicate the new location of the control files.
4. Issue the STARTUP MOUNT command.
5. Issue the STARTUP NOMOUNT command.
6. Issue the RECOVER DATABASE command.
7. Update the control file to reflect the new data file locations by using the ALTER DATABASE RENAME
FILE command.
8. Specify a new location for each affected online log by issuing the command:
RECOVER DATABASE UNTIL CANCEL
9. Open the database in RESETLOGS mode.

Identify the minimum steps required in the correct sequence to recover your database.

A
1, 3, 5, 8, 9
B
1, 4, 7, 8, 9
C
1, 3, 4, 6
D
2, 5, 6, 7, 9

Show answer and explanation

Correct answer: B