Ensurepass

QUESTION 21

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.All databases of all versions use Automatic Storage Management (ASM).Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?

 

A.

The ASM compatibility attribute controls the format of the disk group metadata.

B.

RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

C.

The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

D.

The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

E.

The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

 

Correct Answer: ABD

Explanation:

AD: The value for the disk group COMPATIBLE.ASM attribute determines the minimum software version for an Oracle ASM instance that can use the disk group. This setting also affects the format of the data structures for the Oracle ASM metadata on the disk.

B: The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.

For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1 or 11.2, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively.

Not E:

/The value for the disk group COMPATIBLE.ADVM attribute determines whether the disk group can contain Oracle ASM volumes. The value must be set to 11.2 or higher. Before setting this attribute, the COMPATIBLE.ASM value must be 11.2 or higher. Also, the Oracle ADVM volume drivers must be loaded in the supported environment.

/ You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk group. The volume device associated with the dynamic volume can then be used to host an Oracle ACFS file system.

The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the disk group.

Note:

The disk group attributes that determine compatibility are COMPATIBLE.ASM, COMPATIBLE.RDBMS. and COMPATIBLE.ADVM. The COMPATIBLE.ASM and COMPATIBLE.RDBMS attribute settings determine the minimum Oracle Database software version numbers that a system can use for Oracle ASM and the database instance types respectively. For example, if the Oracle ASM compatibility setting is 11.2, and RDBMS compatibility is set to 11.1, then the Oracle ASM software version must be at least 11.2, and the Oracle Database client software version must be at least 11.1. The COMPATIBLE.ADVM attribute determines whether the Oracle ASM Dynamic Volume Manager feature can create an volume in a disk group.

 

QUESTION 22

Examine the contents of SQL loader control file:

 

clip_image002

 

Which three statements are true regarding the SQL* Loader operation performed using the control file?

 

A.

An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.

B.

The SQL* Loader data file myfile1.dat has the column names for the EMP table.

C.

The SQL* Loader operation fails because no record terminators are specified.

D.

Field names should be the first line in the both the SQL* Loader data files.

E.

The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

 

Correct Answer: ABE

Explanation:

A: The APPEND keyword tells SQL*Loader to preserve any preexisting data in the table. Other options allow you to delete preexisting data, or to fail with an error if the table is not empty to begin with.

B (not D):

Note:

* SQL*Loader-00210: first data file is empty, cannot process the FIELD NAMES record Cause: The data file listed in the next message was empty. Therefore, the FIELD NAMES FIRST FILE directive could not be processed.

Action: Check the listed data file and fix it. Then retry the operation

E:* A comma-separated values (CSV) (also sometimes called character-separated values, because the separator character does not have to be a comma) file stores tabular data (numbers and text) in plain-text form. Plain text means that the file is a sequence of characters, with no data that has to be interpreted instead, as binary numbers. A CSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by some other character or string, most commonly a literal comma or tab. Usually, all records have an identical sequence of fields.

* Fields with embedded commas must be quoted.

Example:

1997,Ford,E350,”Super, luxurious truck”

Note:

* SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database.

 

 

QUESTION 23

Which three statements are true concerning unplugging a pluggable database (PDB)?

 

< /tr>

A.

The PDB must be open in read only mode.

B.

The PDB must be dosed.

C.

The unplugged PDB becomes a non-CDB.

D.

The unplugged PDB can be plugged into the same multitenant container database (CDB)

E.

The unplugged PDB can be plugged into another CDB.

F.

The PDB data files are automatically removed from disk.

 

Correct Answer: BDE

Explanation:

B, not A: The PDB must be closed before unplugging it.

D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference.

E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB’s datafiles can remain in place.

Reference: Oracle White Paper, Oracle Multitenant

 

 

QUESTION 24

Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

 

A.

If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

B.

In a PDB plan, subplans may be used with up to eight consumer groups.

C.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

D.

If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

E.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

 

Correct Answer: AE

Explanation:

A: Setting a PDB resource plan is optional. If not specified, all sessions within the PDB are treated equally.

In a non-CDB database, workloads within a database are managed with resource plans.

In a PDB, workloads are also managed with resource plans, also called PDB resource plans.

The functionality is similar except for the following differences:

/ Non-CDB Database

Multi-level resource plans

Up to 32 consumer groups

Subplans

/ PDB Database

Single-level resource plans only

Up to 8 consumer groups

(not B) No subplans

 

 

QUESTION 25

Which three activities are supported by the Data Recovery Advisor?

 

A.

Advising on block checksum failures

B.

Advising on inaccessible control files

C.

Advising on inaccessible block change tracking files

D.

Advising on empty password files

E.

Advising on invalid block header field values

 

Correct Answer: ABE

Explanation:

Data Recovery Advisor can diagnose failures such as the following:

/ (B) Components such as datafiles and control files that are not accessible because they do not exist, do not have the
correct access permissions, have been taken offline, and so on

/ (A, E) Physical corruptions such as block checksum failures and invalid block header field values

/ Inconsistencies such as a datafile that is older than other database files

/ I/O failures such as hardware errors, operating system driver failures, and exceeding operating system resource limits (for example, the number of open files)

The Data Recovery Advisor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user’s request. This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR).

 

 

QUESTION 26

On your Oracle 12c database, you Issue the following commands to create indexes

 

SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;

SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);

 

Which two statement are correct?

 

A.

Both the indexes are created; however, only the ORD_COSTOMER index is visible.

B.

The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan
.

C.

Only the ORD_CUSTOMER_IX1 index is created.

D.

Only the ORD_CUSTOMER_IX2 index is created.

E.

Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

 

Correct Answer: AE

Explanation:

11G has a new feature called Invisible Indexes. An invisible index is invisible to the optimizer as default. Using this feature we can test a new index without effecting the execution plans of the existing sql statements or we can test the effect of dropping an index without dropping it.

QUESTION 27

The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely to the database instance has a one-to-one ratio between client and server processes.Which connection method guarantees that this requirement is met?

 

A.

connecting by using an external naming method

B.

connecting by using the easy connect method

C.

creating a service in the database by using the dbms_service.create_service procedure and using this service for creating a local naming service”

D.

connecting by using the local naming method with the server = dedicated parameter set in the tnsnames.ora file for the net service

E.

connecting by using a directory naming method

 

Correct Answer: CE

 

 

QUESTION 28

You notice that the elapsed time for an important database scheduler Job is unacceptably long.The job belongs to a scheduler job class and window.Which two actions would reduce the job’s elapsed time?

 

A.

Increasing the priority of the job class to which the job belongs

B.

Increasing the job’s relative priority within the Job class to which it belongs

C.

Increasing the resource allocation for the consumer group mapped to the scheduler job’s job class within the plan mapped to the scheduler window

D.

Moving the job to an existing higher priority scheduler window with the same schedule and duration

E.

Increasing the value of the JOB_QUEUE_PROCESSES parameter

F.

Increasing the priority of the scheduler window to which the job belongs

 

Correct Answer: BC

Explanation:

B: Job priorities are used only to prioritize among jobs in the same class.

Note: Group jobs for prioritization

Within the same job class, you can assign priority values of 1-5 to individual jobs so that if two jobs in the class are scheduled to start at the same time, the one with the higher priority takes precedence. This ensures that you do not have a less important job preventing the timely completion of a more important one.

C: Set resource allocation for member jobs

Job classes provide the link between the Database Resource Manager and the Scheduler, because each job class can specify a resource consumer group as an attribute. Member jobs then belong to the specified consumer group and are assigned resources according to settings in the current resource plan.

 

 

QUESTION 29

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:

 

$> sqlldr hr/hr@pdb table=employees

 

Which two statements are true regarding the command?

 

A.

It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

B.

It fails because no SQL *Loader data file location is specified.

C.

It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

D.

It fails because no SQL *Loader control file location is specified.

 

Correct Answer: AC

Explanation:

SQL*Loader is invoked when you specify the sqlldr command and, optionally, parameters that establish session characteristics.

 

 

QUESTION 30

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.

 

Examine the table definition:

clip_image004

 

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

 

A.

The valid time columns employee_time_start and employee_time_end are automatically created.

B.

The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

C.

The valid time columns are not populated by the Oracle Server automatically.

D.

The valid time columns are visible by default when the table is described.

E.

Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

 

Correct Answer: ABE

Explanation:

A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for the existing ones. The columns that are used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table’s definition in the case of which, the Period For clause would be creating them internally.

E: ENABLE_AT_VALID_TIME Procedure

This procedure enables session level valid time flashback.

 

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.