[Free] Download Latest (March 2016) Oracle 1Z0-062 Real Exam 61-70

Ensurepass

QUESTION 61

You are required to migrate your 11.2.0.3 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 Data Pump 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 the correct 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

 

Correct Answer: C

Explanation:

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

2. From the Oracle Database 11g Release 2 {11.2.0.3) 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 on the 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 62

You enabled an audit policy by issuing the following statements:

 

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;

 

For which database users and for which executions is the audit policy now active? Select two.

 

A.

SYS, SYSTEM

B.

SCOTT

C.

Only for successful executions

D.

Only for failed executions

E.

Both successful and failed executions

 

Correct Answer: AE

Explanation:

The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.

 

 

QUESTION 63

You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?

 

A.

Enable supplemental logging for the database.

B.

Specify undo retention guarantee for the database.

C.

Create a Flashback Data Archive in the tablespace where the tables are stored.

D.

Create a Flashback Data Archive in any suitable tablespace.

< /td>

E.

Enable Flashback Data Archiving for the tables that require tracking.

 

Correct Answer: DE

Explanation:

E: By default, flashback archiving is disabled for any table. You can enable flashback archiving for a table if you have the FLASHBACK ARCHIVE object privilege on the Flashback Data Archive that you want to use for that table.

D: Creating a Flashback Data Archive

Create a Flashback Data Archive with the CREATE FLASHBACK ARCHIVE statement, specifying the following:

Name of the Flashback Data Archive

Name of the first tablespace of the Flashback Data Archive

(Optional) Maximum amount of space that the Flashback Data Archive can use in the first tablespace

Create a Flashback Data Archive named fla2 that uses tablespace tbs2, whose data will be retained for two years:

CREATE FLASHBACK ARCHIVE fla2 TABLESPACE tbs2 RETENTION 2 YEAR;

 

 

QUESTION 64

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions.

 

The table has a local prefixed, range partitioned index.

 

Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.

 

This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.

 

You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.

 

Which three methods could transparently help to achieve this result?

 

A.

Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.

B.

Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

C.

Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.

D.

Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.

E.

Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.

F.

Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

 

Correct Answer: BCE

Explanation:

Oracle 12c now provides the ability to index a subset of partitions and to exclude the others.

Local and global indexes can now be created on a subset of the partitions of a table. Partial Global indexes provide more flexibility in index creation for partitioned tables. For example, index segments can be omitted for the most recent partitions to ensure maximum data ingest rates without impacting the overall data model and access for the partitioned object.

Partial Global Indexes save space and improve performance during loads and queries. This feature supports global indexes that include or index a certain subset of table partitions or subpartitions, and exclude the others. This operation is supported using a default table indexing property. When a table is created or altered, a default indexing property can be specified for the table or its partitions.

 

 

QUESTION 65

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?

 

A.

BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container

B.

BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

C.

BACKUP DATABASE while connected to the PDB1 container

D.

BACKUP DATABASE while connected to the boot container

E.

BACKUP PLUGGABLE database PDB1 while connected to PDB2

 

Correct Answer: AC

Explanation:

To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB.

(A) If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN commands. For example, to back up a PDB, you use the BACKUP PLUGGABLE DATABASE command.

(C) If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a non-CDB. For example, to back up a PDB, you would use the BACKUP DATABASE command.

Reference: Oracle Database Backup and Recovery User’s Guide 12c, About Backup and Recovery of CDBs

 

 

QUESTION 66

You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema. The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?

 

A.

Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO OCP.EXAM_RESULTS; connected as SYSTEM.

B.

Recover the table using traditional Tablespace Point In Time Recovery.

C.

Recover the table using Automated Tablespace Point In Time Recovery.

D.

Recovery the table using Database Point In Time Recovery.

E.

Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO EXAM_RESULTS; connected as the OCP user.

 

Correct Answer: C

Explanation:

RMAN tablespace point-in-time recovery (TSPITR).

Recovery Manager (RMAN) TSPITR enables quick recovery of one or more tablespaces in a database to an earlier time without affecting the rest of the tablespaces and objects in the database.

Fully Automated (the default)

In this mode, RMAN manages the entire TSPITR process including the auxiliary instance. You specify the tablespaces of the recovery set, an auxiliary destination, the target time, and you allow RMAN to manage all other aspects of TSPITR.

The default mode is recommended unless you specifically need more control over the location of recovery set files after TSPITR, auxiliary set files during TSPITR, channel settings and parameters or some other aspect of your auxiliary instance.

 

QUESTION 67

Examine the parameter for your database instance:

 

clip_image002

 

You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

 

clip_image004

 

Identify the reason why the optimizer chose different execution plans.

 

A.

The optimizer used a dynamic plan for the query.

B.

The optimizer chose different plans because automatic dynamic sampling was enabled.

C.

The optimizer used re-optimization cardinality feedback for the query.

D.

The optimizer chose different plan because extended statistics were created for the columns used.

 

Correct Answer: B

Explanation:

optimizer_dynamic_sampling

OPTIMIZER_DYNAMIC_SAMPLING controls both when the database gathers dynamic statistics, a
nd the size of the sample that the optimizer uses to gather the statistics.

Range of values 0 to 11

 

 

QUESTION 68

What is the effect of specifying the “ENABLE PLUGGABLE DATABASE” clause in a “CREATE DATABASE” statement?

 

A.

It will create a multitenant container database (CDB) with only the root opened.

B.

It will create a CDB with root opened and seed read only.

C.

It will create a CDB with root and seed opened and one PDB mounted.

D.

It will create a CDB that must be plugged into an existing CDB.

E.

It will create a CDB with root opened and seed mounted.

 

Correct Answer: B

Explanation:

The CREATE DATABASE … ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.

Along with the root (CDB$ROOT), Oracle Database automatically creates a seed PDB (PDB$SEED). The following graphic shows a newly created CDB:

 

clip_image006

 

Creating a PDB

Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB

is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation.

 

 

QUESTION 69

Examine the structure of the sales table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled.

 

NameNull?Type

——————————————- ————————————- —————————–

PROD_IDNOT NULL NUMBER

CUST_IDNOT NULL NUMBER

TIME_IDNOT NULL DATE

CHANNEL_IDNOT NULL NUMBER

PROMO_IDNOT NULL NUMBER

QUANT I TY___S OL DNOT NULL NUMBER (10, 2)

AMOUNT SOLDNOT NULL NUMBER (10, 2)

 

You want to perform online segment shrink to reclaim fragmented free space below the high water mark.

 

What should you ensure before the start of the operation?

 

A.

Row movement is enabled.

B.

Referential integrity constraints for the table are disabled.

C.

No queries are running on this table.

D.

Extra disk space equivalent to the size of the segment is available in the tablespace.

E.

No pending transaction exists on the table.

 

Correct Answer: D

QUESTION 70

Which two statements are true about the logical storage structure of an Oracle database?

 

A.

An extent contains data blocks that are always physically contiguous on disk.

B.

An extent can span multiple segments,

C.

Each data block always corresponds to one operating system block.

D.

It is possible to have tablespaces of different block sizes.

E.

A data block is the smallest unit of I/O in data files.

 

Correct Answer: BD

Explanation:

http://docs.oracle.com/cd/E11882_01/server.112/e40540/logical.htm#CNCPT250

 

Free VCE & PDF File for Oracle 1Z0-062 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

This entry was posted in 1Z0-062 Real Exam (March 2016) and tagged , , , , , , , . Bookmark the permalink.