1z0-060 Oracle Exam Questions and Free Practice Test

Question 7

You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12C. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.
After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.
How do you accomplish this?

A. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.

B. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.

C. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.

D. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.

Correct Answer:D

Question 8

In which two scenarios do you use SQL* Loader to load data?

A. Transform the data while it is being loaded into the database.

B. Use transparent parallel processing without having to split the external data first.

C. Load data into multiple tables during the same load statement.

D. Generate unique sequential key values in specified columns.

Correct Answer:CD

Question 9

Which three activities are supported by the Data Recovery Advisor?

A. Advising on block checksum failures

B. Advising on inaccessible control files

C. Advising on inaccessible block change tracking files

D. Advising on empty password files

E. Advising on invalid block header field values

Correct Answer:ABE

Question 10

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 mounte

C. Individual PDBs can be flashed back without flashing back the entire CD

D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CD

E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

Correct Answer:BDE

Question 11

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.
On further investigation, you find that buffer busy waits is caused by contention on data blocks.
Which option would you consider first to decrease the wait event immediately?

A. Decreasing PCTUSED

B. Decreasing PCTFREE

C. Increasing the number of DBWN process

D. Using Automatic Segment Space Management (ASSM)

E. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

Correct Answer:D

Question 12

You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" 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 PD

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 CD

D. The database is created as a non-CDB but can be plugged into an existing CD

E. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

Correct Answer:AD

START 1z0-060 EXAM