Note! Following 1z0-062 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

1z0-062 Exam Dumps - Oracle Database 12c: Installation and Administration

Go to page:

<< First
Prev
1
2
3
4
5
6
7
Next
Last >>

Question # 17

Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

It calls SQL advisors automatically if required.

It provides recommendations only for poorly performing SQL statements.

Its results are stored in AWR.

It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis.

It requires at least one Automatic Workload Repository (AWR) snapshot for analysis.

Full Access

Question # 18

Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.)

Put all readonly tablespaces in read write mode

Recompile all invalid objects

Set the compatible parameter to 12.1.0.1

Gather dictionary statistics

Empty all user recycle bins

Full Access

Question # 19

Examine the parameters for your database instance:

You execute the following command:

SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;

Which statement is true in this scenario?

Undo data is written to flashback logs after 1200 seconds.

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

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

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

Full Access

Question # 20

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? (Choose two.)

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

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

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

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

Full Access

Question # 21

Examine this command:

SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;

Which two statements are true? (Choose two.)

All data definition language (DDL) statements are written to the control file

Some DDL statements are written to an XML file in the ADR home

All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home

Some data definition language (DDL) statements are written to the control file

Some DDL statements are written to a text file in the ADR home

The Alert Log still contains some DDL statements

Full Access

Question # 22

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

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.

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

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

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

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.

Full Access

Question # 23

Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity.

Which action generates recommendations to overcome the performance issues?

running the Memory Advisor for the buffer cache

running the Memory Advisor for the library cache

running the Memory Advisor for the SGA

running the Memory Advisor for the PGA

Full Access

Question # 24

You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the tableâ€™s indexes, to another tablespace.

The table does not have a primary key and is used by an OLTP application.

Which technique will move the table and indexes while maintaining the highest level of availability to the application?

Oracle Data Pump.

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

Online Table Redefinition.

Edition-Based Table Redefinition.

Full Access

Answer:

Explanation:

* Oracle Database provides a mechanism to make table structure modifications without significantly affecting the availability of the table. The mechanism is called online table redefinition. Redefining tables online provides a substantial increase in availability compared to traditional methods of redefining tables.

* To redefine a table online:

Choose the redefinition method: by key or by rowid

* By keyâ€”Select a primary key or pseudo-primary key to use for the redefinition. Pseudo-primary keys are unique keys with all component columns having NOT NULL constraints. For this method, the versions of the tables before and after redefinition should have the same primary key columns. This is the preferred and default method of redefinition.

* By rowidâ€”Use this method if no key is available. In this method, a hidden column named M_ROW$$ is added to the post-redefined version of the table. It is recommended that this column be dropped or marked as unused after the redefinition is complete. If COMPATIBLE is set to 10.2.0 or higher, the final phase of redefinition automatically sets this column unused. You can then use the ALTER TABLE ... DROP UNUSED COLUMNS statement to drop it.

You cannot use this method on index-organized tables.

Note:

* When you rebuild an index, you use an existing index as the data source. Creating an index in this manner enables you to change storage characteristics or move to a new tablespace. Rebuilding an index based on an existing data source removes intra-block fragmentation. Compared to dropping the index and using the CREATE INDEX statement, re-creating an existing index offers better performance.

Incorrect:

Not E: Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time.

Go to page: