[Free] 2019(Nov) EnsurePass Oracle 1z0-062 Dumps with VCE and PDF 121-130

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-062.html

Question No.121

The DEFERRED_SEGMENT_CREATION parameter is set to TRUE in your database instance.

You execute the following command to create a table:

image

Which two statements are true? (Choose two.)

  1. The table is created without a segment because the storage clause is missing.

  2. A segment is allocated when the first row is inserted in the table.

  3. A segment is allocated when an index is created for any column in the table.

  4. The table is created and extents are immediately allocated as per the default storage defined for its tablespace.

  5. A segment is allocated for the table if the ALTER TABLE… ALLOCATE EXTENT command is issued.

Correct Answer: BE

Question No.122

You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.

The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade.

What must you do first in this situation to attempt to fix this problem?

  1. Run catuppst.sql to perform revalidation actions

  2. Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.

  3. Run preupgrd.sql and then execute the generated quot;fix-upquot; scripts to resolve status issues.

  4. Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.

Correct Answer: D

Question No.123

Identify two situations in which the alert log file is updated.

  1. Running a query on a table returns ORA-600: Internal Error.

  2. Inserting a value into a table returns ORA-01722: invalid number.

  3. Creating a table returns ORA-00955: name us already in used by an existing objects.

  4. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.

  5. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.

Correct Answer: AE

Explanation:

The alert log is a chronological log of messages and errors, and includes the following items:

All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur

Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements

Messages and errors relating to the functions of shared server and dispatcher processes Errors occurring during the automatic refresh of a materialized view

The values of all initialization parameters that had nondefault values at the time the database and instance start

Note:

The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions.

Question No.124

On your Oracle Database, you issue the following commands to create indexes:

SQL gt; CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;

SQLgt; CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true? (Choose two.)

  1. Only the ORD_CUSTOMER_IX1 index created.

  2. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.

  3. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.

  4. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.

  5. Both the indexes are created and used by the optimizer for queries on the ORDERS table.

  6. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

Correct Answer: BF

Explanation:

Not A: Both indexes are created fine.

B: The invisible index ORD_CUSTOMERS_IX1 and the bitmap index are both updated by DML operations on the Orders table.

F: Since ORD_CUSTOMERS_IX1 is invisible only ORD_CUSTOMERS_IX2 is used by the query optimizer.

Not C, Not D, Not E:

ord_customer_ix1 is an invisible index and is therefore not used by the optimizer.

VISIBLE | INVISIBLE Use this clause to specify whether the index is visible or invisible to the optimizer. An invisible index is maintained by DML operations, but it is not be used by the optimizer during queries unless you explicitly set the parameter OPTIMIZER_USE_INVISIBLE_INDEXES to TRUE at the session or system level. Note: Specify BITMAP to indicate that index is to be created with a bitmap for each distinct key, rather than indexing each row separately. Bitmap indexes store the rowids associated with a key value as a bitmap. Each bit in the bitmap corresponds to a possible rowid. If the bit is set, then it means that the row with the corresponding rowid contains the key value. The internal representation of bitmaps is best suited for applications with low levels of concurrent transactions, such as data warehousing.

Question No.125

Which three statements are true about the purpose of checkpoints? (Choose three.)

  1. They ensure that uncommitted transactions are rolled back in case of an instance failure.

  2. They ensure that all the dirty buffers are written to disk during a normal shutdown.

  3. They ensure that instance recovery starts in the event of an instance failure.

  4. They ensure that dirty buffers in the buffer cache are written to disk regularly.

  5. They reduce the time required for recovery in case of an instance failure.

Correct Answer: BDE

Question No.126

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

  1. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

  2. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

  3. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

  4. BACKUP TABLESPACE quot;TEMPquot; SECTION SIZE 10M;

  5. BACKUP TABLESPACE quot;UNDOquot; INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

  6. BACKUP SPFILE SECTION SIZE 1M;

  7. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Correct Answer: ABEG

Question No.127

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

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

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

Which two statements are correct? (Choose two.)

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

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

  3. Only the ORD_CUSTOMER_IX1 index is created.

  4. Only the ORD_CUSTOMER_IX2 index is created.

  5. 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 No.128

You enabled an audit policy by issuing the following statements: SQLgt; AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;

SQLgt; AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;

For which database users and for which executions is the audit policy now active? Select two.

  1. SYS, SYSTEM

  2. SCOTT

  3. Only for successful executions

  4. Only for failed executions

  5. Both successful and failed executions

Correct Answer: AE

Explanation:

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

Question No.129

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

  1. By default, EM express is available for a database after database creation.

  2. You can use EM express to manage multiple databases running on the same server.

  3. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

  4. You cannot start up or shut down a database Instance by using EM express.

  5. You can create and configure pluggable databases by using EM express.

Correct Answer: D

Explanation:

http://www.oracle.com/technetwork/database/manageability/emx-intro-1965965.html

Question No.130

Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)

  1. It generates a script to recompile invalid objects post-upgrade.

  2. The preupgrade_fixups.sql script is created to list and describe issues in the source database.

  3. A log file, preupgrade.log, is created that contains the output of the Pre-Upgrade Information tool.

  4. It checks for required tablespaces and if they are not available, creates them automatically.

  5. The preupgrade_fixups.sql script is executed automatically to fix issues in the source database.

  6. The postupgrade_fixups.sql script is created to address issues that can be fixed after a database has been upgraded.

Correct Answer: ACE

Explanation:

https://docs.oracle.com/database/122/UPGRD/using-preupgrade-information-tool-for-oracle- database.htm#UPGRD-GUID-C0219AF1-AD43-4097-B358-E53E48958647

Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF