Ensurepass

QUESTION 11

To enable the Database Smart Flash Cache, you configure the following parameters:

 

DB_FLASH_CACHE_FILE = `/dev/flash_device_1′ , `/dev/flash_device_2′

DB_FLASH_CACHE_SIZE=64G

 

What is the result when you start up the database instance?

 

A.

It results in an error because these parameter settings are invalid.

B.

One 64G flash cache file will be used.

C.

Two 64G flash cache files will be used.

D.

Two 32G flash cache files will be used.

 

Correct Answer: A

 

 

QUESTION 12

Identify two correct statements about multitenant architectures.

 

A.

Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.

B.

Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.

C.

Multiple CDBs share certain PDB resources.

D.

Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.

E.

Patches are always applied at the CDB level.

F.

A PDB can have a private undo tablespace.

 

Correct Answer: BE

Explanation:

B: Using 12c Resource manager you will be able control CPU, Exadata I/O, sessions and parallel servers. A new 12c CDB Resource Manager Plan will use so-called “Shares” (resource allocations) to specify how CPU is distributed between PDBs. A CDB Resource Manager Plan also can use “utilization limits” to limit the CPU usage for a PDB. With a default directive, you do not need to modify the resource plan for each PDB plug and unplug.

E: New paradigms for rapid patching and upgrades.

The investment of time and effort to patch one multitenant container database results in patching all of its many pluggable databases. To patch a single pluggable database, you simply unplug/plug to a multitenant container database at a different Oracle Database software version.

Incorrect:

Not A:

* The Oracle RAC documentation describes special considerations for a CDB in an Oracle RAC environment.

* Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps customers reduce IT costs by simplifying consolidation, provisioning, upgrades, and more. It is supported by a new architecture that allows a container database to hold many pluggable databases. And it fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard. An existing database can be simply adopted, with no change, as a pluggable database; and no changes are needed in the other tiers of the application.

Not D: You can unplug a PDB from one CDB and plug it into a different CDB without altering your schemas or applications. A PDB can be plugged into only one CDB at a time.

Not F:

* UNDO tablespace can NOT be local and stays on the CDB level.

* Redo and undo go hand in hand, and so the CDB as a whole has a single undo tablespace per RAC instance.

 

 

QUESTION 13

A senior DBA asked you to execute the following command to improve performance:

 

SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);

 

You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation?

 

A.

The keep pool is not configured.

B.

Automatic Workarea Management is not configured.

C.

Automatic Shared Memory Management is not enabled.

D.

The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

E.

All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.

 

Correct Answer: D

Explanation:

The most of the rows in SUBSCRIBE_LOG table are accessed once a week.

 

 

QUESTION 14

Examine the parameters for your database instance:

 

NAMETYPE VALUE

————————- ——————————- —————————

undo_management string AUTO

undo_retentioninteger 12 00

undo_tablespace string UNDOTBS1

 

You execute the following command:

 

SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;

 

Which statement is true in this scena
rio?

 

A.

Undo data is written to flashback logs after 1200 seconds.

B.

Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.

C.

You can perform a Flashback Database operation only within the duration of 1200 seconds.

D.

An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

 

Correct Answer: A

 

 

QUESTION 15

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.

 

A.

Missing or stale histogram statistics

B.

Undersized shared pool

C.

High clustering factor for the indexes

D.

High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter

E.

Oversized buffer cache

 

Correct Answer: ACD

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 16

Which statement is true about the Log Writer process?

 

A.

It writes when it receives a signal from the checkpoint process (CKPT).

B.

It writes concurrently to all members of multiplexed redo log groups.

C.

It writes after the Database Writer process writes dirty buffers to disk.

D.

It writes when a user commits a transaction.

 

Correct Answer: D

Explanation:

http://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm (see log writer process (LGWR))

 

 

QUESTION 17

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.

 

You issue the following statements:

 

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;

 

For which database users is the audit policy now active?

 

A.

All users except SYS

B.

All users except SCOTT

C.

All users except sys and SCOTT

D.

All users except sys, system, and SCOTT

 

Correct Answer: B

Explanation:

If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists. This means the effect of the earlier AUDIT POLICY … EXCEPT statements are overridden by the latest AUDIT POLICY … EXCEPT statement.

Note:

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

* You can use the keyword ALL to audit all actions. The following example shows how to audit all actions on the HR.EMPLOYEES table, except actions by user pmulligan.

Example Auditing All Actions on a Table

CREATE AUDIT POLICY all_actions_on_hr_emp_pol

ACTIONS ALL ON HR.EMPLOYEES;

AUDIT POLICY all_actions_on_hr_emp_pol EXCEPT pmulligan;

Reference: Oracle Database Security Guide 12c, About Enabling Unified Audit Policies

 

 

QUESTION 18

Which four actions are possible during an Online Data file Move operation?

 

A.

Creating and dropping tables in the data file being moved

B.

Performing file shrink of the data file being moved

C.

Querying tables in the data file being moved

D.

Performing Block Media Recovery for a data block in the data file being moved

E.

Flashing back the database

F.

Executing DML statements on objects stored in the data file being moved

 

Correct Answer: ACEF

Explanation:

You can now move On line Datafile without hove to stop Monoged Recovery and manually copy and rename Files. This can even be used to move Datafiles from or to ASM.  New in Oracle Database 12c: FROM METAUNK. Physical Standby Database is in Active Data Guard Mode (opened READ ONLY and Managed Recovery is running):

It is now possible to online move a Datafile while Managed Recovery is running, ie. the Physical Standby Database is in Active Data Guard Mode. You con use this Command to move the Datafile  A flashback operation does not relocate a moved data file to its previous location. If you move a data file online from one location to another and later flash back the database to a point in time before the move, then the Data file remains in the new location, but the contents of the Data file ore changed to the contents at the time specified in the flashback. Oracle0 Database Administrator’s Guide 12c Release 1 (12.1)

 

 

QUESTION 19

In your production database, data manipulation language (DML) operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.What action would you take to achieve this task?

 

A.

Apply fine-grained auditing.

B.

Implement value-based auditing.

C.

Impose standard database auditing to audit object privileges.

D.

Impose standard database auditing to audit SQL statements.

 

Correct Answer: B

 

 

QUESTION 20

Which statement is true concerning dropping a pluggable database (PDB)?

 

A.

The PDB must be open in read-only mode.

B.

The PDB must be in mount state.

C.

The PDB must be unplugged.

D.

The PDB data files are always removed from disk.

E.

A dropped PDB can never be plugged back into a multitenant container database (CDB).

 

Correct Answer: C

 

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 …

Comments are closed.