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

Get Full Version of the Exam

Question No.141

Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)? (Choose three.)

  1. System privileges apply only to the PDB in which they are used.

  2. Local users cannot use local system privileges on the schema of a common user.

  3. The granter of system privileges must possess the set container privilege.

  4. Common users connected to a PDB can exercise privileges across other PDBs.

  5. System privileges with the with grant option container all clause must be granted to a common

    user before the common user can grant privileges to other users.

    Correct Answer: ACE


    A, Not D: In a CDB, PUBLIC is a common role. In a PDB, privileges granted locally to PUBLIC enable all local and common users to exercise these privileges in this PDB only.

    C: A user can only perform common operations on a common role, for example, granting privileges commonly to the role, when the following criteria are met:

    The user is a common user whose current container is root. The user has the SET CONTAINER privilege granted commonly, which means that the privilege applies in all containers.

    The user has privilege controlling the ability to perform the specified operation, and this privilege has been granted commonly


    Every privilege and role granted to Oracle-supplied users and roles is granted commonly except for system privileges granted to PUBLIC, which are granted locally.

    Question No.142

    Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.

    The steps to recover the tablespace are as follows:

    1. Mount the CDB.

    2. Close all the PDBs.

    3. Open the database.

    4. Apply the archive redo logs.

    5. Restore the data file.

    6. Take the SYSAUX tablespace offline.

    7. Place the SYSAUX tablespace online.

    8. Open all the PDBs with RESETLOGS.

    9. Open the database with RESETLOGS.

    10. Execute the command SHUTDOWN ABORT.

Which option identifies the correct sequence to recover the SYSAUX tablespace?


6, 5, 4, 7


10, 1, 2, 5, 8


10, 1, 2, 5, 4, 9, 8


10, 1, 5, 8, 10

Correct Answer: A





While evaluating the 12c beta3 I was not able to do the recover while testing quot;all pdb files lostquot;. Cannot close the pdb as the system datafile was missing…

So only option to recover was: Shutdown cdb (10)

startup mount; (1)

restore pluggable database

recover pluggable database alter database open;

alter pluggable database name open;

Oracle support says: You should be able to close the pdb and restore/recover the system tablespace of PDB.

Inconsistent backups are usually created by taking online database backups. You can also make an inconsistent backup by backing up data files while a database is closed, either:

Immediately after the crash of an Oracle instance (or, in an Oracle RAC configuration, all instances)

After shutting down the database using SHUTDOWN ABORT Inconsistent backups are only useful if the database is in ARCHIVELOG mode and all archived redo logs created since the backup are available.

Open the database with the RESETLOGS option after finishing recovery: SQLgt; ALTER DATABASE OPEN RESETLOGS;

Question No.143

Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

  1. You can detach from a data pump export job and reattach later.

  2. Data pump uses parallel execution server processes to implement parallel import.

  3. Data pump import requires the import file to be in a directory owned by the oracle owner.

  4. The master table is the last object to be exported by the data pump.

  5. You can detach from a data pump import job and reattach later.

Correct Answer: AB


B: Data Pump can employ multiple worker processes, running in parallel, to increase job performance.

D: For export jobs, the master table records the location of database objects within a dump file set.

Export builds and maintains the master table for the duration of the job. At the end of an export job, the content of the master table is written to a file in the dump file set.

For import jobs, the master table is loaded from the dump file set and is used to control the sequence of operations for locating objects that need to be imported into the target database.

Question No.144

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.

Examine the table definition:


Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

  1. The valid time columns employee_time_start and employee_time_end are automatically created.

  2. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

  3. The valid time columns are not populated by the Oracle Server automatically.

  4. The valid time columns are visible by default when the table is described.

  5. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Correct Answer: ABC

Question No.145

Which three statements are true about SQL plan directives? (Choose three.)

  1. They are tied to a specific statement or SQL ID.

  2. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

  3. They are used to gather only missing statistics.

  4. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

  5. They instruct the optimizer to create only column group statistics.

  6. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

Correct Answer: BDF

Question No.146

You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)

  1. Performance improves because less redo is written to the redo log.

  2. Temporary undo reduces the amount of undo stored in undo tablespaces.

  3. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache.

  4. Performance improves because no redo and undo are generated for the temporary tables.

Correct Answer: AB

Question No.147

You Execute the Following command to create a password file in the database server:

$ orapwd file = ` DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12#39; Which two statements are true about the password file? (Choose two.)

  1. It records the usernames and passwords of users when granted the DBA role.

  2. It contains the usernames and passwords of users for whom auditing is enabled.

  3. Is used by Oracle to authenticate users for remote database administration.

  4. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.

  5. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

Correct Answer: CE

Question No.148

Examine the query and its output executed In an RDBMS Instance:


Which three statements are true about the users (other than sys) in the output? (Choose three.)

  1. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.

  2. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.

  3. The C # # A_ADMIN user can perform wallet operations.

  4. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).

  5. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

Correct Answer: BDE


B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl.


The new (introduced in 11g) SYSASM role to manage the ASM instance, variable extent sizes to reduce shared pool usage, and the ability of an instance to read from a specific disk of a diskgroup

E (Not A): SYSDBA is like a role in the sense that it is granted, but SYSDBA is a special built-in privilege to allow the DBA full control over the database Incorrect:

Not C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption wallet operations.


Use the V$PWFILE_USERS view to see the users who have been granted administrative privileges.

Question No.149

You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data? (Choose three.)

  1. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.

  2. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.

  3. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.

  4. Use the MKDG command to restore the disk group with the same configuration as the backed-up

    disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.

  5. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

  6. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

Correct Answer: ACF


AC (not E):

The md_restore command allows you to restore a disk group from the metadata created by the md_backup command.

md_restore can#39;t restore data, only metadata.

Question No.150

Which Oracle Database component is audited by default if the unified Auditing option is enabled?

  1. Oracle Data Pump

  2. Oracle Recovery Manager (RMAN)

  3. Oracle Label Security

  4. Oracle Database Vault

  5. Oracle Real Application Security

Correct Answer: B

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.