1z1-062 by Oracle Actual Free Exam Questions And Answers

Question 1

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

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

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

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

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

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

Discussion 0

Correct Answer: D Vote an answer

Question 2

The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload Repository (AWR) snapshots are collected on an hourly basis.
What is the most efficient way of diagnosing this problem?

A. Create a SQL Tuning Set (STS) for the currently cached SQL statements in the shared pool and run SQL Performance Analyzer (SPA) to generate recommendations.

B. Analyze the hourly ADDM reports generated between 11:00 AM and 3:00 PM.

C. Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and 3:00 PM.

D. Analyze the latest Automatic Database Diagnostic Monitor (ADDM) report.

Discussion 0

Correct Answer: C Vote an answer

Question 3

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and generates lots of redo.
Which two actions would you take to solve this problem? (Choose two.)

A. Enable undo retention guarantee.

B. Increase the size of the temporary tablespace.

C. Enable temporary undo for the database.

D. Increase the size of the redo log buffer.

E. Enable Automatic Memory Management (AMM).

Discussion 0

Correct Answer: B,C Vote an answer

Question 4

You set the following parameters in the parameter file and restart the database instance:

Which two statements are true? (Choose two.)

A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

B. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.

C. The lower limits of the PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB respectively.

D. The instance does not start up because Automatic Memory Management (AMM) is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to nonzero values.

E. The value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.

Discussion 0

Correct Answer: A,C Vote an answer

Question 5

Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)

A. It mounts databases and diskgroups to make ASM files available to database instances.

B. It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgroup.

C. It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load.

D. It automatically places each disk from an external redundancy diskgroup in its own failure group.

E. It divides files into extents and allows an extent to span disks.

Discussion 0

Correct Answer: C,D Vote an answer

Question 6

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 default database configuration

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

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 7

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

A. Take the user data tablespace offline.

B. Place the root container in the nomount stage.

C. Ensure that HR_PDB is open.

D. Place the root container in ARHCHIVELOG mode.

Discussion 0

Correct Answer: D Vote an answer

Question 8

When is the UNDO_RETENTION parameter value ignored by a transaction?

A. when the data file of the undo tablespace is autoextensible

B. when there are multiple undo tablespaces available in a database

C. when Flashback Database is enabled

D. when the undo tablespace is of a fixed size and retention guarantee is not enabled

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 9

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? (Choose two.)

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

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

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

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

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

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 10

Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)

A. Bind Variable Peeking

B. Literals in a SQL statement

C. Adaptive Cursor Sharing

D. SQL Plan Baselines

E. Bind variable used in a SQL statement

Discussion 0

Correct Answer: A,C,E Vote an answer

Question 11

You want to create a test database as a replica of your production database with minimum intervention from a DBA.
Which method would you use?

A. Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

B. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

C. Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

D. Create the database by using the CREATE DATAEASE. . . command and manually import data by using Data Pump.

Discussion 0

Correct Answer: B Vote an answer

Question 12

Which three operations can be performed as multipartition operations in Oracle? (Choose three.)

A. Drop partitions of a list partitioned table

B. Merge partitions of a list partitioned table

C. Merge partitions of a reference partitioned index

D. Move partitions of a range-partitioned table

E. Rename partitions of a range partitioned table

F. Coalesce partitions of a hash-partitioned global index.

Discussion 0

Correct Answer: A,B,C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 13

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)

A. Tracking insert time by row for table rows

B. Tracking the most recent read time for a table segment in a user tablespace

C. Tracking the most recent read time for a table segment in the SYSAUX tablespace

D. Tracking the most recent write time for a table segment in a user tablespace

E. Tracking the most recent write time for a table segment in the SYSAUX tablespace

F. Tracking the most recent write time for a table block

Discussion 0

Correct Answer: B,D,F Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Oracle Database 12c: Installation and Administration - 1z1-062 Exam Practice Test

Contact Us

Useful Links

Latest Updated