Free 1Z0-062 Exam Dumps

Question 86

SMD is a smallfile locally managed tablespace with manual segment space management. The SH user receives the following error while inserting data into the sales table:
1Z0-062 dumps exhibit
Which three actions can be taken to enable the user to insert data? (Choose three.)

A. altering the data file associated with the SMD tablespace to grow automatically
B. adding a data file to the SMD tablespace, provided the tablespace has not reached its maximum number of file
C. changing segment space management for the SMD tablespace to automatic
D. resizing the data file associated with the SMD tablespace to make it larger, provided all data files have not yet reached their maximum size
E. increasing the space quota on the SMD tablespace for the SH user, provided the files have not yet reached their maximum size

Correct Answer:ABD

Question 87

Examine the parameters for a database instance:
1Z0-062 dumps exhibit
Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance.
What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

A. Transactions write their undo in the SYSTEM undo segment.
B. Transactions fail.
C. Transactions wait until space becomes available in UNDOTBS1.
D. Transactions write their undo in a temporary tablespace.

Correct Answer:B
References https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)

Question 88

Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup.
Which two statements are true in this scenario? (Choose two.)

A. RMAN backups contain only data files.
B. The database instance must be shut down to take a user-managed consistent backup.
C. Consistent RMAN backups can be taken while the database is open.
D. User-managed backups only contain formatted data blocks.
E. The database must be in MOUNT state to take consistent RMAN backup

Correct Answer:CD

Question 89

Examine the parameter for your database instance:
1Z0-062 dumps exhibit
You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

Identify the reason why the optimizer chose different execution plans.

A. The optimizer used a dynamic plan for the query.
B. The optimizer chose different plans because automatic dynamic sampling was enabled.
C. The optimizer used re-optimization cardinality feedback for the query.
D. The optimizer chose different plan because extended statistics were created for the columns use

Correct Answer:A

Question 90

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

A. It clears all user recycle bins in a database and releases their storage space.
B. It writes a list of invalid SYS and SYSTEM object to the registry$sys_inv_objs table.
C. It evaluates the dependencies of network utility packages.
D. It identifies any deprecated and unsupported parameters.
E. It generates fix-up scripts and automatically runs them to resolve issues that are flagged in the source databas

Correct Answer:BCD