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

Ensurepass

QUESTION 91

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.

 

SQL> SELECT name, active_sessions, queue_length,

Consumed_cpu_time, cpu_waits, cpu_wait_time

FROM v$rsrc_consumer_group;

NAMEACTIVE_SESSIONS QUEUE_LENGTH CONSUMED_CPU_WAITS

CPU_WAIT_TIME

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

OLTP__ORDER__ENTRY1029690 467

OTHES__GROUPS 0 059823664089

60425

SYS_GROUP 1 02420704 914

19540

DS.S_QUERIES4245946603004

55700

 

Which two statements are true?

 

A.

An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.

B.

An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.

C.

The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.

D.

The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.

E.

A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.

 

Correct Answer: CE

 

 

QUESTION 92

Identify three valid methods of opening, pluggable databases (PDBs).

 

A.

ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root

B.

ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB

C.

ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed

D.

ALTER DATABASE PDB OPEN issued from the root

E.

ALTER DATABASE OPEN issued from that PDB

F.

ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB

G.

ALTER PLUGGABLE DATABASE OPEN issued from that PDB

 

Correct Answer: AEG

Explanation:

E: You can perform all ALTER PLUGGABLE DATABASE tasks by connecting to a PDB and running the corresponding ALTER DATABASE statement. This functionality is provided to maintain backward compatibility for applications that have been migrated to a CDB environment.

AG: When you issue an ALTER PLUGGABLE DATABASE OPEN statement, READ WRITE is the default unless a PDB being opened belongs to a CDB that is used as a physical standby database, in which case READ ONLY is the default.

You can specify which PDBs to modify in the following ways:

List one or more PDBs.

Specify ALL to modify all of the PDBs.

Specify ALL EXCEPT to modify all of the PDBs, except for the PDBs listed.

 

 

QUESTION 93

Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?

 

A.

shutting down the database instance that is being upgraded

B.

executing the catctl.pl script to run the upgrade processes in parallel

C.

running the Pre-Upgrade Information Tool

D.

copying the listener.ora file to the new ORACLE_HOME

 

Correct Answer: C

Explanation:

http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#UPGRD12395

 

 

QUESTION 94

Which statement is true about Oracle Net Listener?

 

A.

It acts as the listening endpoint for the Oracle database instance for all local and non- local user connections.

B.

A single listener can service only one database instance and multiple remote client connections.

C.

Service registration with the listener is performed by the process monitor (PMON) process of each database instance.

D.

The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

E.

The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.

 

Correct Answer: C

Explanation:

Supported services, that is, the services to which the listener forwards client requests, can be configured in the listener.ora file or this information can be dynamically registered with the listener. This dynamic registration feature is called service registration. The registration is performed by the PMON process–an instance background process–of each database instance that has the necessary configuration in the database initialization parameter file. Dynamic service registration does not require any configuration in the listener.ora file.

Incorrect:

Not B: Service registration reduces the need for the SID_LIST_listener_name parameter setting, which specifies information about the databases served by the listener, in the listener.ora file.

Note:

Oracle Net Listener is a separate process that runs on the database server computer. It receives incoming client connection requests and manages the traffic of these requests to the database server.

A remote listener is a listener residing on one computer that redirects connections to a database instance on another computer. Remote listeners are typically used in an Oracle Real Application Clusters (Oracle RAC) environment. You can configure registration to remote listeners, such as in the case of Oracle RAC, for dedicated server or shared server environments.

 

 

 

 

 

 

QUESTION 95

You execute the following PL/SQL:

 

clip_image002

 

Which two statements are true?

 

A.

Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.

B.

FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.

C.

FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.

D.

FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

 

Correct Answer: AB

Explanation:

DBMS_FGA.add_policy

The DBMS_FGA package provides fine-grained security functions.

ADD_POLICY Procedure

This procedure creates an audit policy using the supplied predicate as the audit condition.

Incorrect:

Not C: object_schema

The schema of the object to be audited. (If NULL, the current log-on user schema is assumed.)

 

 

QUESTION 96

Which three statements are true about SQL plan directives?

 

A.

They are tied to a specific statement or SQL ID.

B.

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

C.

They are used to gather only missing statistics.

D.

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

E.

They instruct the optimizer to create only column group statistics.

F.

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

 

Correct Answer: BDE

Explanation:

During SQL execution, if a cardinality misestimate occurs, then the database creates SQL plan directives. During SQL compilation, the optimizer examines the query corresponding to the directive to determine whether missing extensions or histograms exist (D). The optimizer records any missing extensions. Subsequent DBMS_STATS calls
collect statistics for the extensions.

The optimizer uses dynamic sampling whenever it does not have sufficient statistics corresponding to the directive. (B, not C)

E: Currently, the optimizer monitors only column groups. The optimizer does not create an extension on expressions.

Incorrect:

Not A: SQL plan directives are not tied to a specific SQL statement or SQL ID.

Note:

A SQL plan directive is additional information and instructions that the optimizer can use to generate a more optimal plan. For example, a SQL plan directive can instruct the optimizer to record a missing extension.

 

 

QUESTION 97

Which three statements are true about Automatic Workload Repository (AWR)?

 

A.

All AWR tables belong to the SYSTEM schema.

B.

The AWR data is stored in memory and in the database.

C.

The snapshots collected by AWR are used by the self-tuning components in the database

D.

AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

E.

AWR contains system wide tracing and logging information.

 

Correct Answer: BCE

Explanation:

A fundamental aspect of the workload repository is that it collects and persists database performance data in a manner that enables historical performance analysis. The mechanism for this is the AWR snapshot. On a periodic basis, AWR takes a “snapshot” of the current statistic values stored in the database instance’s memory and persists them to its tables residing in the SYSAUX tablespace.

AWR is primarily designed to provide input to higherlevel components such as automatic tuning algorithms and advisors, but can also provide a wealth of information for the manual tuning process.

 

 

QUESTION 98

To implement Automatic Management (AMM), you set the following parameters:

 

clip_image004

 

When you try to start the database instance with these parameter settings, you receive the following error message:

 

SQL > startup

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.

 

Identify the reason the instance failed to start.

 

A.

The PGA_AGGREGATE_TARGET parameter is set to zero.

B.

The STATISTICS_LEVEL parameter is set to BASIC.

C.

Both the SGA_TARGET and MEMORY_TARGET parameters are set.

D.

The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

 

Correct Answer: B

Explanation:

Example:

SQL> startup force

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings

ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET

 

 

QUESTION 99

The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.

 

A.

BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

B.

BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

C.

BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

D.

BACKUP TABLESPACE “TEMP” SECTION SIZE 10M;

E.

BACKUP TABLESPACE “UNDO” INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

F.

BACKUP SPFILE SECTION SIZE 1M;

G.

BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

 

Correct Answer: ABCG

 

 

QUESTION 100

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

 

A.

Tracking the most recent read time for a table segment in a user tablespace

B.

Tracking the most recent write time for a table segment in a user tablespace

C.

Tracking insert time by row for table rows

D.

Tracking the most recent write time for a table block

E.

Tracking the most recent read time for a table segment in the SYSAUX tablespace

F.

Tracking the most recent write time for a table segment in the SYSAUX tablespace

 

Correct Answer: ABD

Explanation:

Incorrect:

Not E, Not F When Heat Map is enabled, all accesses are tracked by the in-memory activity tracking module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked.

To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification.

Heat Map provides data access tracking at the segment-level and data modification tracking at the segment and row level.

To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. You can also use Automatic Data Optimization (ADO) to automate the compression and movement of data between different tiers of storage within the database.

Reference: Automatic Data Optimization with Oracle Database 12c with Oracle Database 12c

 

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.