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

Get Full Version of the Exam

Question No.161

You want to flash back a test database by five hours. You issue this command:


Which two statements are true about this flashback scenario? (Choose two.)

  1. The database must have multiplexed redo logs for the flashback to succeed.

  2. The database must be MOUNTED for the flashback to succeed.

  3. The database must use block change tracking for the flashback to succeed.

  4. The database must be opened in restricted mode for the flashback to succeed.

  5. The database must be opened with the RESETLOGS option after the flashback is complete.

  6. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

    Correct Answer: BE

    Question No.162

    You want to create a role that:


    is protected from unauthorized usage



    does not use a password embedded in the application source code or stored in a table is enabled for a user based on security policies defined in a PL/SQL package

    How would you create this role?

    1. as a secure application role

    2. with definer#39;s rights

    3. with global authentication

    4. with external authentication

Correct Answer: A



Question No.163

A database instance is started by using an SPFILE. The database is configured in ARCHIVELOG mode and the control file autobackup is configured. Daily full database backups are performed by using RMAN.

You lost all control files due to media failure.

Given the steps to recover from the error in random order:

  1. Shut down the instance, if it is not already down.

  2. Restore the control file from autobackup to a new location.

  3. Start the database instance to NOMOUNT state.

  4. Recover the database to the point of failure of the control file.

  5. Open the database with the RESETLOGS option.

  6. Mount the database.

  7. Update the SPFILE with the new location of the control file by using the ALTER SYSTEM command.

    Identify the correct sequence of the required steps.


    1, 3, 2, 6, 7, 4, 5


    1, 3, 7, 2, 6, 4, 5


    1, 3, 2, 4, 5


    1, 2, 6, 4, 5


    1, 6, 2, 4, 5

    Correct Answer: A

    Question No.164

    A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:


    There is enough free space in the disk group for mirroring to be done.

    What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

    1. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.

    2. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.

    3. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.

    4. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.

    5. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.

Correct Answer: D

Question No.165

You want to schedule a job to rebuild a table#39;s indexes after a bulk insert, which must be scheduled as soon as a file containing data arrives on the system. What would you do to accomplish this?

  1. Create a file watcher and an event-based job for bulk insert and then create another job to rebuild indexes on the table.

  2. Create a file watcher for the bulk inserts and then create a job to rebuild indexes.

  3. Create a job array and add a job for bulk insert and a job to rebuild indexes to the job array.

  4. Create an event-based job for the file arrival event, then create a job for bulk insert, and then create a job to rebuild indexes.

Correct Answer: A

Question No.166

Which three activities are supported by the Data Recovery Advisor? (Choose three.)

  1. Advising on block checksum failures

  2. Advising on inaccessible control files

  3. Advising on inaccessible block change tracking files

  4. Advising on empty password files

  5. Advising on invalid block header field values

Correct Answer: ABE


Data Recovery Advisor can diagnose failures such as the following:

(B) Components such as datafiles and control files that are not accessible because they do not exist, do not have the correct access permissions, have been taken offline, and so on

(A, E) Physical corruptions such as block checksum failures and invalid block header field values Inconsistencies such as a datafile that is older than other database files / I/O failures such as hardware errors, operating system driver failures, and exceeding operating system resource limits (for example, the number of open files)

The Data Recovery Advisor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user#39;s request. This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR).

Question No.167

You have the following entry in the tnsnames.ors of your hq.us.example.com host machine:


You issue the following command at the command prompt: Sqlplus HR/HR@ORCL

Which statement is true about the connection to the ORCL database instance?

  1. The connection succeeds, provided the NAMES.DEFAULT_DOMAIN parameter is set to us.example.com in the sqlnet.ora file on the client side.

  2. The connection fails because the net service name does not have the suffix us.example.com.

  3. The connection succeeds, provided the SERVICE_NAMES initialization parameter is set to ORCL.

  4. The connection succeeds, provided the ORCL.us.example.com database service is registered with a listener, the listener is up, and the database is open.

Correct Answer: D

Question No.168

You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL gt; ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = `*#39; SCOPE = SPFILE;

Which is true about the result of this command?

  1. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.

  2. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.

  3. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.

  4. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

Correct Answer: A

Question No.169

You want to reduce fragmentation and reclaim unused space for the SALES table but not its dependent objects. During this operation, you want to ensure the following:

  1. Long-running queries are not affected.

  2. No extra space is used.

  3. Data manipulation language (DML) operations on the table succeed at all times throughout the process.

  4. Unused space is reclaimed both above and below the high water mark. Which ALTER TABLE option would you recommend?





Correct Answer: C



Question No.170

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:


HR then opens a second session.

Which two operations wait when executed in HR#39;s second session? (Choose two.)


  2. INSERT INTO employees(empno,ename) VALUES (1289, `Dick#39;);

  3. SELECT job FROM employees WHERE job=#39;CLERK#39; FOR UPDATE OF empno;

  4. SELECT empno,ename FROM employees WHERE job=#39;CLERK#39;;

  5. INSERT INTO employees(empno,ename,job) VALUES (2001,#39;Harry#39;,#39;CLERK);

Correct Answer: AC

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