Exam Deatils

  • Exam Code
    :1Z0-060
  • Exam Name
    :Upgrade to Oracle Database 12c
  • Certification
    :Oracle Database
  • Vendor
    :Oracle
  • Total Questions
    :217 Q&As
  • Last Updated
    :Jan 20, 2022

Oracle Oracle Database 1Z0-060 Questions & Answers

  • Question 1:

    Which two statement are true about the installation modes in Oracle Database 12c? (Choose two.)

    A. In silent mode installation, you can validate the parameter values on installation screens for which you have provided information in the response file.

    B. In interactive mode, parameter values are read from a response file and can be changed during installation.

    C. Response file mode is useful when you require multiple Oracle Homes with variation in some of the installation parameters for each home.

    D. In response file mode, you can include responses for some or all prompts.

  • Question 2:

    Examine the portion of this Active Session History (ASH) report that is marked with a red rectangle: Which two inferences can be drawn from the report?

    A. Sessions attempting to modify blocks images in the buffer cache are waiting while other sessions are reading the same block images.

    B. Sessions are waiting to find free buffers in the buffer cache.

    C. Sessions are waiting for writes of modified block images in the buffer cache to complete

    D. Sessions are attempting to read blocks images in the buffer cache are waiting while other sessions are reading the same block images.

    E. Sessions attempting to read blocks images in the buffer cache are waiting while other sessions are modifying the same block images.

  • Question 3:

    You plan to use the Flashback Drop feature to recover the SALES_EMP table that was dropped in error.

    No other table with the same name exists in the SH schema, which owns the table.

    You query the RECYCLEBIN and find multiple entries for the SALES_EMP table:

    You then issue this statement to recover the table:

    What would be the best?

    A. It retrieves the least recently dropped version of the table from the recycle bin for which undo is still available.

    B. It retrieves the most recently dropped version of the table.

    C. It retrieves the most recently dropped version of the table from the recycle bin for which indo is still available.

    D. It returns an error because the table name in the OBJECT_NAME column is not specified.

    E. It retrieves the least recently dropped version of the table.

  • Question 4:

    Examine these parameters for a database instance:

    Which two statement are true? (Choose two.)

    A. SGA can grow automatically beyond 4480 MB.

    B. The autotuned components of SGA are dynamically allocated.

    C. Only Automatic Shared Memory management (ASMM) is enabled.

    D. Automatic Memory Management (AMM) and ASMM are enabled.

    E. PGA can grow automatically beyond 1000 MB.

  • Question 5:

    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?

    A. Execute the RMAN RECOVER BLOCK command by specifying the table name and SCN 663571 because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.

    B. Execute another FLASHBACK TABLE statement to restore the CUSTOMERS table to SCN 663571.

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

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

  • Question 6:

    In which two scenarios is an RMAN recovery catalog automatically resynchronized? (Choose two.)

    A. when a registered database is opened with the RESETLOGS option

    B. when a redo log is archived

    C. when backup metadata records are aged out of the control file based on the CONTROL_FILE_RECORD_KEEP_TIME parameter value

    D. when the backup retention policy configuration is changed for a registered database

    E. when a manual redo log switch is performed

  • Question 7:

    Your database is running in ARCHIVELOG mode. You back up the control file by executing ALTER DATABASE BACKUP CONTROL TO TRACE NORESETLOGS, whenever you make structural changes to the database. A media failure has damaged all the control files, but the online redo log files are intact. You issue a SHUTDOWN ABORT.

    How should you recover the control file to its default location?

    A. Restore the backup control file to all the locations specified in the CONTROL_FILES parameter file, start a new instance and mount the database, recover the database, and then open the database with the RESETLOGS option.

    B. Issue the STARTUP NOMOUNT command, restore the backup control file only to the default location, issue RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL, and open the database with the RESETLOGS option.

    C. Issue the STARTUP MOUNT command, restore the backup control file to all the locations specified in the CONTROL_FILES parameter file, and then issue RECOVER DATABASE USING BACKUP CONTROLFILE.

    D. Issue the STARTUP NOMOUNT command, re-create the control file manually by using the CREATE CONTROLFILE command, issue the RECOVER DATABASE command, and then issue the ALTER DATABASE OPEN command.

  • Question 8:

    Which two partitioning methods are suitable for a parent table when using reference partitioning in Oracle Database 12c? (Choose two.)

    A. interval partitioning

    B. list partitioning

    C. system partitioning

    D. hash partitioning

    E. range partitioning

  • Question 9:

    Your multitenant container database (CDB) is running in ARCHIVELOG mode.

    Examine this command and its output:

    You issue this command in RMAN:

    RMAN>BACKUP PLUGGABLE DATABASE "CDB$ROOT", pdb2_1;

    What is the outcome?

    A. The backup succeeds, but only the SYSTEM and SYSAUX tablespaces in the root container are backed up along with all the data files in PDB2_1.

    B. The backup fails because the root container cannot be backed up with PDB2_1.

    C. The backup succeeds and all the data files belonging to both the root container and PDB2_1 are backed up.

    D. The backup fails because PDB2_1 should be placed in the mount stage.

  • Question 10:

    Which statement is true concerning compression during an Online Datafile Move?

    A. Only tables may be compressed during the Online Datafile Move.

    B. The DBA may choose which objects in the datafile to be moved get compressed.

    C. All objects in a data file to be moved will always to be compressed.

    D. Uncompressed data files may be moved online to compress the entire file with Hybrid Columnar Compression.

    E. If an object is already compressed in the source location, then the compression type for that object remains unchanged after the move.

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-060 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.