[Free] 2019(Nov) EnsurePass Oracle 1z0-062 Dumps with VCE and PDF 251-260

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-062.html

Question No.251

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

  1. PMON

  2. SMON

  3. MMNL

  4. MMAN

  5. MMON

Correct Answer: D

Question No.252

Which three database operations can be performed only at MOUNT state? (Choose three.)

  1. performing Flashback Database

  2. renaming control files

  3. enabling or disabling ARCHIVELOG mode

  4. re-creating control files

  5. performing full database recovery

Correct Answer: ACE

Question No.253

In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace. Which statement is true about undo retention?

  1. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM tablespace to provide read consistency.

  2. Inactive undo is retained for at least 1000 seconds if free undo space is available.

  3. Inactive undo is retained for 1000 seconds even if new transactions fall due to lack of space in the undo tablespace.

  4. Undo becomes expired obsolete after 1000 seconds.

Correct Answer: B

Question No.254

What must you use to read data from a table in your database and write it to an external table?

  1. Use SQL* LOADER conventional path load.

  2. Use SQL* LOADER direct path load.

  3. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_LOADER access driver.

  4. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_DATAPUMP access driver.

Correct Answer: D

Question No.255

Examine the following ALTER command:

SQLgt; ALTER DISKGROUP dgroup1 UNDROP DISKS;

What is the purpose of the command?

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

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

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

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

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

Correct Answer: A

Question No.256

You create an Oracle 12c database and then import schemas that are required by an application which has not yet been developed.

You want to get advice on creation of or modifications to indexes, materialized views and partitioning in these schemas.

What must you run to achieve this?

  1. SQL Access Advisor with a SQL tuning set

  2. B.Automatic Database Diagnostic Monitor (ADDM) report

  3. SQL Tuning Advisor

  4. SQL Access Advisor with a hypothetical workload

  5. SQL Performance Analyzer

Correct Answer: D

Question No.257

Examine the following steps:

A DBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY. SIDNEY grants the CREATE TABLE system privilege to the HR user.

Which statement is true?

  1. SIDNEY can revoke the CREATE TABLE system privilege only from HR, to whom he granted it.

  2. HR can grant the CREATE TABLE system privilege to other users.

  3. Neither SIDNEY nor HR can create new tables if the DBA revokes the CREATE TABLE privilege from SIDNEY.

  4. HR still retains the CREATE TABLE system privilege if the DBA revokes the CREATE TABLE privilege from SIDNEY.

Correct Answer: D

Explanation:

http://www.dba-oracle.com/t_with_grant_admin_privileges.htm

Question No.258

Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system? (Choose three.)

  1. online redo log files

  2. parameter file

  3. multiplexed copies of the current control file

  4. archived log files

  5. Flashback Data Archive files

  6. Flashback logs

Correct Answer: ADF

Question No.259

What is pre-requisite to alter a role?

  1. You should be granted the DBA role.

  2. You should set the OS_ROLES parameter to true.

  3. You should be granted the role with the GRANT OPTION.

  4. You should have the ALTER ANY ROLE system privilege.

Correct Answer: D

Question No.260

Your database instance has Automatic Memory Management enabled and supports shared server connections.

Examine the following:

  1. Parallel execution messages and control structures

  2. Local variables for a process

  3. Security and resource usage information

  4. Runtime memory values, such as rows retrieved for a SQL statement using a serial execution plan

  5. SQL execution work areas

Which option indicates what is allocated from the large pool in this instance?

  1. only 1

  2. 1, 2, and 5 C. 1, 2, 3, and 5

D. 1, 2, and 4

Correct Answer: D

Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF