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

Ensurepass

QUESTION 81

Which three statements are true about Oracle Data Pump export and import operations?

 

A.

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

B.

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

C.

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

D.

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

E.

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

 

Correct Answer: ABD

Explanation:

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 82

Examine the commands executed to monitor database operations:

 

$> conn sys oracle/oracle@prod as sysdba

SQL > VAR eid NUMBER

SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (`batch_job’ , FORCED_TRACKING => `Y’);

 

Which two statements are true?

 

A.

Database operations will be monitored only when they consume a significant amount of resource.

B.

Database operations for all sessions will be monitored.

C.

Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.

D.

Only DML and DDL statements will be monitored for the session.

E.

All subsequent statements in the session will be treated as one database operation and will be monitored.

 

Correct Answer: CE

Explanation:

C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.

Note:

The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-time Database Operation Monitoring.

(not B) BEGIN_OPERATION Function starts a composite database operation in the current session.

(E) FORCE_TRACKING – forces the composite database operation to be tracked when the operation starts. You can also use the string variable ‘Y’.

(not A) NO_FORCE_TRACKING – the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable ‘N’.

 

 

QUESTION 83

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

 

A.

Reduced logical I/O

B.

Reduced virtual memory utilization

C.

Improved parallel Execution performance

D.

Improved Serial Execution performance

E.

Reduced physical I/O

F.

Reduced CPU utilization

 

Correct Answer: BCF

Explanation:

Multiprocess and Multithreaded Oracle Database Systems

Multiprocess Oracle Database (also called multiuser Oracle Database) uses several processes to run different parts of the Oracle Database code and additional Oracle processes for the users–either one process for each connected user or one or more processes shared by multiple users. Most databases are multiuser because a primary advantage of a database is managing data needed by multiple users simultaneously.

Each process in a database instance performs a specific job. By dividing the work of the database and applications into several processes, multiple users and applications can connect to an instance simultaneously while the system gives good performance.

In previous releases, Oracle processes did not run as threads on UNIX and Linux systems. Starting in Oracle Database 12c, the multithreaded Oracle Database model enables Oracle processes to execute as operating system threads in separate address spaces.

 

 

QUESTION 84

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

 

A.

ALTER TABLE SPLIT PARTITION

B.

ALTER TABLE MERGE PARTITION

C.

ALTER TABLE TRUNCATE PARTITION

D.

ALTER TABLE ADD PARTITION

E.

ALTER TABLE DROP PARTITION

F.

ALTER TABLE MOVE PARTITION

 

Correct Answer: CE

Explanation:

Asynchronous Global Index Maintenance for DROP and TRUNCATE PARTITION

This feature enables global index maintenance to be delayed and decoupled from a DROP and TRUNCATE partition without making a global index unusable. Enhancements include faster DROP and TRUNCATE partition operations and the ability to delay index maintenance to off-peak time.

Reference: Oracle Database VLDB and Partitioning Guide 12c

 

 

QUESTION 85

Identify three benefits of Unified Auditing.

 

A.

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

B.

It improves overall auditing performance.

C.

It guarantees zero-loss auditing.

D.

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

E.

It automatically audits Recovery Manager (RMAN) events.

 

Correct Answer: ABE

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.

Note:

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 error occurred 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 single audit 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 86

Which two statements are true about Oracle Managed Files (OMF)?

 

A.

OMF cannot be used in a database that already has data files created with user- specified directions.

B.

The file system directions that are specified by OMF parameters are created automatically.

C.

OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

D.

OMF automatically creates unique file names for table spaces and control files.

E.

OMF may affect the location of the redo log files and archived log files.

 

Correct Answer: DE

Explanation:

D: The database internally uses standard file system interfaces to create and delete files as needed for the following database structures:

Tablespaces

Redo log files

Control files

Archived logs

Block change tracking files

Flashback logs

RMAN backups

Note:

Using Oracle-managed files simplifies the administration of an Oracle Database. Oracle- managed files eliminate the need for you, the DBA, to directly manage the operating system files that make up an Oracle Database. With Oracle-managed files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level. For example, you need only specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace’s datafile with the DATAFILE clause.

http://www.oracle-base.com/articles/9i/oracle-managed-files.php

http://docs.oracle.com/cd/B10500_01/server.920/a96521/omf.htm

Reference: What Are Oracle-Managed Files?

 

 

QUESTION 87

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?

 

A.

Use Oracle Managed Files (OMF).

B.

Specify the SEED FILE_NAME_CONVERT clause.

C.

Specify the PDB_FILE_NAME_CONVERT initialization parameter.

D.

Specify the DB_FILE_NAMECONVERT initialization parameter.

E.

Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

 

Correct Answer: ABC

Explanation:

You must specify the names and locations of the seed’s files in one of the following ways:

(A) Oracle Managed Files

(B) The SEED FILE_NAME_CONVERT Clause

(C) The PDB_FILE_NAME_CONVERT Initialization
Parameter

 

 

QUESTION 88

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:

 

clip_image002

 

After changing the value, you notice that FULL redaction continues to redact numeric data with zero.

 

What must you do to activate the new default value for numeric full redaction?

 

A.

Re-enable redaction policies that use FULL data redaction.

B.

Re-create redaction policies that use FULL data redaction.

C.

Re-connect the sessions that access objects with redaction policies defined on them.

D.

Flush the shared pool.

E.

Restart the database instance.

 

Correct Answer: E

Explanation:

About Altering the Default Full Data Redaction Value

You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.

Note:

The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.

UPDATE_FULL_REDACTION_VALUES Procedure

This procedure modifies the default displayed values for a Data Redaction policy for full redaction.

After you create the Data Redaction policy, it is automatically enabled and ready to redact data.

Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by low-privileged users or applications. You can redact column data by using one of the following methods:

Full redaction.

Partial redaction.

Regular expressions.

Random redaction.

No redaction.

Reference: Oracle Database Advanced Security Guide 12c, About Altering the Default Full Data Redaction Value

 

 

QUESTION 89

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).

 

The characteristics of the non-CDB are as follows:

 

clip_image004Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit

clip_image004[1]Character set: AL32UTF8

clip_image004[2]National character set: AL16UTF16

clip_image004[3]O/S: Oracle Linux 6 64-bit

 

The characteristics of the CDB are as follows:

 

clip_image004[4]Version: Oracle Database 12c Release 1 64-bit

clip_image004[5]Character Set: AL32UTF8

clip_image004[6]National character set: AL16UTF16

clip_image004[7]O/S: Oracle Linux 6 64-bit

 

Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

 

A.

Transportable database

B.

Transportable tablespace

C.

Data Pump full export/import

D.

The DBMS_PDB package

E.

RMAN

 

Correct Answer: B

Explanation:

Overview, example:

Log into ncdb12c as sys

Get the database in a consistent state by shutting it down cleanly.

Open the database in read only mode

Run DBMS_PDB.DESCRIBE to create an XML file describing the database.

Shut down ncdb12c

Connect to target CDB (CDB2)

Check whether non-cdb (NCDB12c) can be plugged into CDB(CDB2)

Plug-in Non-CDB (NCDB12c) as PDB(NCDB12c) into target CDB(CDB2).

Access the PDB and run the noncdb_to_pdb.sql script.

Open the new PDB in read/write mode.

You can easily plug an Oracle Database 12c non-CDB into a CDB. Just create a PDB manifest file for the non-CDB, and then use the manifest file to create a cloned PDB in the CDB.

Note that to plugin a non-CDB database into a CDB, the non-CDB database needs to be of version 12c as well. So existing 11g databases will need to be upgraded to 12c before they can be part of a 12c CDB.

 

 

QUESTION 90

You execute the following commands to audit database activities:

 

SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;

SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;

 

Which statement is true about the audit record that generated when auditing after instance restarts?

 

A.

One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

B.

One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.

C.

One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

D.

One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.

E.

One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

 

Correct Answer: A

Explanation:

Note:

BY SESSION

In earlier releases, BY SESSION caused the database to write a single record for all SQL statements or operations of the same type executed on the same schema objects in the same session. Beginning with this release (11g) of Oracle Database, both BY SESSION and BY ACCESS cause Oracle Database to write one audit record for each audited statement and operation.

BY ACCESS

Specify BY ACCESS if you want Oracle Database to write one record for each audited statement and operation.

Note:

If you specify either a SQL statement shortcut or a system privilege that audits a data definition language (DDL) statement, then the database always audits by access. In all other cases, the database honors the BY SESSION or BY ACCESS specification.

For each audited operation, Oracle Database produces an audit record containing this information:

The user performing the operation

The type of operation

The object involved in the operation

The date and time of the operation

Reference: Oracle Database SQL Language Reference 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.