1Z0-062 Oracle Exam Questions and Free Practice Test

Question 49

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

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
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 50

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and generates lots of redo.
Which two actions would you take to solve this problem? (Choose two.)

A. Increase the size of the temporary tablespace.

B. Enable Automatic Memory Management (AMM).

C. Enable undo retention guarantee.

D. Enable temporary undo for the database.

E. Increase the size of the redo log buffe

Correct Answer:AD

Question 51

Which three statements are true PFILEs, SPFILEs or both? (Choose three.)

A. SPFILEs and PFILEs may both be edited with an O/S editing utility

B. Some SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause

C. A SPFILE can be created by an idle instance

D. A PFILE can be created by an idle instance

E. All SPFILE parameters can be modified successfully with the SCOPE=BOTH clause

F. All SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause

Correct Answer:BDE

Question 52

Which two statements are true about initialization parameter files? (Choose two.)

A. A lost or damaged SPFILE can be re-created by using the parameter values listed in the alert log.

B. A PFILE must exist for an SPFILE to be created.

C. The ALTER SYSTEM command cannot be used to change the value of any parameter if a database instance has started using a PFILE.

D. Both the SPFILE and PFILE must always reside on a file system accessible from the database host server.

E. On startup, by default a database instance always first searches for an SPFILE, and if it does not find any, searches for a PFILE.

Correct Answer:BE

Question 53

The HR user updates the salary of one of the employees in the non-partitioned EMPLOYEES table, but does not commit the transaction.
Which two types of lock exist in this situation? (Choose two.)

A. exclusive lock on the EMPLOYEES table

B. null lock on the row being updated

C. null lock on the EMPLOYEES table

D. row level lock on the row being updated

E. shared lock on the EMPLOYEES table

Correct Answer:DE

Question 54

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
1Z0-062 dumps exhibit
Which three are prerequisites for successful execution of the command? (Choose three.)

A. The import operation must be performed by a user on the target database by a user with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user with the DATAPUMP_EXP_FULL_DATABASE role on the source database.

B. All the user-defined tablespaces must be in read-only mode on the source database.

C. The export dump file must be created before starting the import on the target database.

D. The source and target database must be running on the same operating system (OS) with the same endianness.

E. The impdp operation must be performed by the same user that performed the expdp operation.

Correct Answer:ABD
In this case we have run the impdp without performing any conversion if endian format is different then we have to first perform conversion.

START 1Z0-062 EXAM