[Free] 2018(Jan) EnsurePass Testinsides Oracle 1z0-062 Dumps with VCE and PDF 31-40

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-062
100% Free Download! 100% Pass Guaranteed!

Oracle Database 12c: Installation and Administration

Question No: 31

TheHR user receives the following error while inserting data into the sales table:

Ensurepass 2018 PDF and VCE

On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.

Which two methods would you use to resolve this error?

  1. Altering the data file associated with the USERS tablespace to ex automatically

  2. Adding a data file to the USERS tablespace

  3. Changing segment space management for the USERS tablespace tomanual

  4. Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace

  5. Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value

    Answer: A,D

    Question No: 32

    You are required to migrate your database as a pluggable database (PDB) to a multitenant container database (CDB).

    The following are the possible steps to accomplish this task:

    1. Place all the user-defined tablespace in read-only mode on the source database.

    2. Upgrade the source database to a 12c version.

    3. Create a new PDB in the target container database.

    4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.

    5. Copy the associated data files and export the dump file to the desired location in the target database.

    6. Invoke the DataPump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.

    7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.

Identify thecorrect order of the required steps.

A. 2, 1, 3, 4, 5, 6

B. 1, 3, 4, 5, 6, 7

C. 1, 4, 3, 5, 6, 7

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

E. 1, 5, 6, 4, 3, 2

Answer: C Explanation:

  1. Set user tablespaces in the source database to READ ONLY.

  2. From the OracleDatabase 11g Release 2 { environment, export the metadata and any data residing in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS parameters. Note that the VER$ION=12 parameter is required only when exporting from an Oracle Database llg Release 2 database:

  3. Copy the tablespace data files from the source system to the destination system. Note that the log file from the export operation will list the data files required to be moved.

  4. Create a COB onthe destination system, including a PDB into which you will import the source database.

  5. In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file. The act of importing the dump file will plug the tablespace data files into the destination PDB

    Oracle White Paper – Upgrading to Oracle Database 12c -August 2013

    Question No: 33

    In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?

    Both local and global partitioned B-tree Indexes are defined on the table.

    A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.

    Minimal disrupt ion to availability is required.

    Which three statements aretrue about this requirement?

    1. The partitions can be moved online to new tablespaces.

    2. Global indexes must be rebuilt manually after moving the partitions.

    3. The partitions can be compressed in the same tablespaces.

    4. The partitions can becompressed in the new tablespaces.

    5. Local indexes must be rebuilt manually after moving the partitions.

Answer: A,C,D Explanation:

A: You can create and rebuild indexes online. Therefore, you can update base tables at the same time you are building orrebuilding indexes on that table. You can perform DML operations while the index build is taking place, but DDL operations are not allowed.

Parallel execution is not supported when creating or rebuilding an index online. D: Moving (Rebuilding) Index-Organized Tables

Because index-organized tables are primarily stored in a B-tree index, you can encounter fragmentation as a consequence of incremental updates. However, you can use the ALTER TABLE…MOVE statement to rebuild the index and reduce this fragmentation.

C: If a table can be compressed in the new tablespace, also it can be compressed in the same tablespace.


Not B, not E: Local and Global indexes can be automatically rebuild with UPDATE INDEXES when you move the table.

Question No: 34

Which two actions does an incremental checkpoint perform?

  1. It signals CKPT to write thecheckpoint position to the data file headers.

  2. It writes the checkpoint position to the data file headers.

  3. It advances the checkpoint position in the checkpoint queue.

  4. It writes the checkpoint position to the control file.

Answer: C,D Explanation:

References: http://www.dba-oracle.com/t_incremental_checkpoint.htm

Question No: 35

Identify three benefits of Unified Auditing.

  1. Decreased use of storage to store audit trail rows in the database.

  2. It improves overall auditing performance.

  3. It guarantees zero-loss auditing.

  4. The audit trail cannot be easily modified because it is read-only.

  5. It automaticallyaudits Recovery Manager (RMAN) events.

Answer: A,B,E Explanation:

A: Starting with 12c, Oracle has unified all of the auditing types into one single unit called

Unified auditing. You don’t have to turn on or off all of the different auidting types individually and as a matter of fact auditing is enabled by default right out of the box. The AUD$ and FGA$ tables have been replaced with one single audit trail table. All of the audit data is now stored in Secure Files table thus improving the overall management aspects of audit data itself.

B: Further the audit data can also be buffered solving most of the common performance related problems seen on busy environments.

E: Unified Auditing is able to collect audit data for Fine Grained Audit, RMAN, Data Pump, Label Security, Database Vault and Real Application Security operations.


* Benefits of the Unified Audit Trail

The benefits of a unified audit trail are many:

/ (B) Overall auditing performance is greatly improved. The default mode that unified audit works is Queued Write mode. In this mode, the audit records are batched in SGA queue and is persisted in a periodic way. Because the audit records are written to SGA queue, there is a significant performance improvement.

/ The unified auditing functionality is always enabled and does not depend on the initialization parameters that were used in previous releases

/ (A) The audit records, including records from the SYS audit trail, for all the audited components of your Oracle Database installation are placed in one location and in one format, rather than your having to look in different places to find audit trails in varying formats. This consolidated view enables auditors to co-relate audit information from different components. For example, if an erroroccurred during an INSERT statement, standard auditing can indicate the error number and the SQL that was executed. Oracle Database Vault-specific information can indicate whether this error happened because of a command rule violation or realm violation.Note that there will be two audit records with a distinct AUDIT_TYPE. With this unification in place, SYS audit records appear with AUDIT_TYPE set to Standard Audit.

/ The management and security of the audit trail is also improved by having it in singleaudit trail.

/ You can create named audit policies that enable you to audit the supported components listed at the beginning of this section, as well as SYS administrative users. Furthermore,

you can build conditions and exclusions into your policies.

  • Oracle Database 12c Unified Auditing enables selective and effective auditing inside the Oracle database using policies and conditions. The new policy based syntax simplifies management of auditing within the database and provides the ability to accelerate auditing based on conditions.

  • The new architecture unifies the existing audit trails into a single audit trail, enabling simplified management and increasing the security of audit data generated by the database.

Question No: 36

Which statement is true about redo log files during instance recovery?

  1. All current, online, and archived redo logs are required to complete instance recovery.

  2. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.

  3. All redo log entries in the current log are applied to data files until the checkpoint position is reached.

  4. All current, active, and inactive redo logs are required to complete instance recovery.

Answer: C

Question No: 37

Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Ensurepass 2018 PDF and VCE

Which two statements are true about redefining the table?

  1. All the triggers for the table aredisabled without changing any of the column names or column types in the table.

  2. The primary key constraint on the EMPLOYEES table is disabled during redefinition.

  3. VPD policies are copied from the original table to the new table during onlineredefinition.

  4. You must copy the VPD policies manually from the original table to the new table during online redefinition.

Answer: B,C Explanation:


Used to indicate to copy VPD policies automatically


    /The DBMS_RLS package contains the fine-grained access control administrative interface, which is used to implement Virtual Private Database (VPD).DBMS_RLS is available with the Enterprise Edition only.


  • CONS_USE_PK and CONS_USE_ROWID are constantsused as input to the quot;options_flagquot; parameter in both the START_REDEF_TABLE Procedure and CAN_REDEF_TABLE Procedure. CONS_USE_ROWID is used to indicate that the redefinition should be done using rowids while CONS_USE_PK implies that the redefinition shouldbe done using primary keys or pseudo-primary keys (which are unique keys with all

    component columns having NOT NULL constraints).


    To achieve online redefinition, incrementally maintainable local materialized views areused. These logs keep track of the changes to the master tables and are used by the materialized views during refresh synchronization.


Prior to calling this procedure, you must manually create an empty interim table (in thesame schema as the table to be redefined) with the desired attributes of the post- redefinition table, and then call this procedure to initiate the redefinition.

Question No: 38

You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.

Identify three possible reasons for this.

  1. Missing or stale histogram statistics

  2. Undersized shared pool

  3. High clustering factor for the indexes

  4. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter

  5. Oversized buffer cache

Answer: A,C,D Explanation:

D:DB_FILE_MULTIBLOCK_READ_COUNT is one of the parameters you can use to minimize I/O during table scans. It specifies the maximum number of blocks read in one I/O operation during a sequential scan. The total number of I/Os needed to perform a full table scan depends on such factors as the size of the table, the multiblock read count, and whether parallel execution is being utilized for the operation.

Question No: 39

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

  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 containerprivilege.

  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.

Answer: A,C,E Explanation:

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 appliesin all containers.

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

Incorrect: Note:

Leave a Reply

Your email address will not be published. Required fields are marked *

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