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

1z0-060 Exam Dumps - Upgrade to Oracle Database 12c

Go to page:

Question # 9

Examine these two statements:

Which three are true about the MRKT tablespace? (Choose three.)

The MRKT tablespace is created as a smallfile tablespace, because the file size is less than the minimum required for bigfile files.

The MRKT tablespace may be dropped if it has no contents.

Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

No more data files can be added to the tablespace.

The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

Full Access

Question # 10

To complete the online redefinition procedure, you execute the following command:

EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE(â€˜SHâ€™, â€˜SALESâ€™, â€˜INT_SALESâ€™, 600);

What is the significance of the dml_lock_timeout period of 600 seconds in the preceding command?

All pending DML statements on the SALES table must be committed 600 seconds before the procedure ends gracefully.

All pending DML statements on the SALES table will wait for 600 seconds before the procedure ends gracefully.

All pending DML statements on the SALES_INT table must be committed 600 seconds before the procedure ends gracefully.

It specifies the number of seconds the procedure waits for its required locks before it ends gracefully.

Full Access

Question # 11

You use a recovery catalog for maintaining your database backups.

You execute the following command:

Which two statements are true? (Choose two.)

Corrupted blocks, if any, are repaired.

Checks are performed for physical corruptions.

Checks are performed for logical corruptions.

Checks are performed to confirm whether all database files exist in correct locations

Backup sets containing both data files and archive logs are created.

Full Access

Question # 12

Examine this command:

SQL> exec DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');

Which three statements are true about the effect of this command? (Choose three.)

Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

Full Access

Question # 13

You notice that the elapsed time for an important database scheduler job is unacceptably long.

The job belongs to a scheduler job class and runs in a scheduler window.

Which two actions could reduce the job's elapsed time? (Choose two.)

increasing the job's relative priority within the job class to which it belongs

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

increasing resource allocation for the consumer group mapped to the job class in the resource manager plan associated with the scheduler window

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

increasing the value of the JOB_QUEUE_PROCESSES parameter

Full Access

Question # 14

Which three statements are true about Oracle Data Pump export and import operations? (Choose three.)

You can detach from a data pump export job and reattach later.

Data pump uses parallel execution server processes to implement parallel import.

Data pump import requires the import file to be in a directory owned by the oracle owner.

The master table is the last object to be exported by the data pump.

You can detach from a data pump import job and reattach later.

Full Access

Question # 15

Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)

Bind Variable Peeking

SQL Plan Baselines

Adaptive Cursor Sharing

Bind variable used in a SQL statement

Literals in a SQL statement

Full Access

Question # 16

The current system change number (SCN) for a live database is 663571.

You decide to use the flashback table statement to flash back the customers table to SCN 662116.

After flashing back the customers table, you query It and decide to undo the effects of the flashback table command.

Which is the fastest way to do this?

Execute another flashback table statement to restore the customers table to SCN 663571.

Perform tablespace point-in-time recovery because flashback table cannot be performed on a table that has already been flashed back.

Execute the RMAN recover block command by specifying the table name and SCN 663571 because fiashback table cannot be performed on a table that has already been flashed back.

Perform table polnt-in-time recovery because flashback table cannot be performed on a table that has already been flashed back.

Full Access

Go to page: