1Z0-062 Oracle Exam Questions and Free Practice Test

Question 19

Examine the following ALTER command:
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?

A. It cancels all pending disk drops within the disk group

B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.

C. It mounts disks in the disk group for which the drop-disk operation has already been co pleted

D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed

E. It adds previously dropped disks back into the disk group

Correct Answer:A

Question 20

You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
– Applications will connect to the database via a middle tier.
– The number of concurrent user connections will be high.
– The database will have mixed workload, with the execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?

A. a General Purpose database template with default memory allocation

B. a Data Warehouse database template, with the dedicated server mode option and AMM enabled

C. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled

D. a default database configuration

Correct Answer:C
References:
http://www.oracledistilled.com/oracle-database/administration/creating-a-database-using-database-configuration

Question 21

The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that:
1Z0-062 dumps exhibit
HR then opens a second session.
Which two operations wait when executed in HR’s second session? (Choose two.)

A. LOCK TABLE employees IN EXCLUSIVE MODE;

B. INSERT INTO employees(empno,ename) VALUES (1289, ‘Dick’);

C. SELECT job FROM employees WHERE job=’CLERK’ FOR UPDATE OF empno;

D. SELECT empno,ename FROM employees WHERE job=’CLERK’;

E. INSERT INTO employees(empno,ename,job) VALUES (2001,’Harry’,’CLERK);

Correct Answer:AC

Question 22

When does a database checkpoint occur?

A. When there is an online redo log switch.

B. When a user session terminates abnormally.

C. When a server process terminates abnormally.

D. When the SHUTDOWN ABORT command is issue

Correct Answer:A

Question 23

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
* Monitoring database operations
Real-Time Database Operations Monitoring enables you to monitor long running database tasks such as batch jobs, scheduler jobs, and Extraction, Transformation, and Loading (ETL) jobs as a composite business operation. This feature tracks the progress of SQL and PL/SQL queries associated with the business operation being monitored. As a DBA or developer, you can define business operations for monitoring by explicitly specifying the start and end of the operation or implicitly with tags that identify the operation.

Question 24

You ran this command on a source database:
$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept On the target database, you run this command:
$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept Which two statements are true? (Choose two.)

A. The expdp operation exports all rows for tables contained in the defining query of the EMP_DEPT view

B. The impdp operation creates separate tables for each table contained in the defining query of the EMP_DEPT view

C. The expdp operation exports all rows that are displayed when querying the EMP_DEPT view with no filter

D. The impdp operation creates EMP_DEPT as a table

E. The expdp operation exports the table definitions for tables that are queried in the EMP_DEPT view.

F. The impdp operation creates EMP_DEPT as a view

Correct Answer:DE

START 1Z0-062 EXAM