Oracle Oracle Database 1Z0-060 Questions & Answers

• Question 1:

  Examine this set of commands to perform data pump export and import operations: On the source database:

  $> expdp sh/sh DIRECTORY=dpdir DUMPFILE=sale1.dmp VIEWS_AS_TABLE=sales_q1

  On the target database:

  $> impdp sh/sh DIRECTORY=dpdir DUMPFILE=sale1.dmp VIEWS_AS_TABLE=sales_q1

  Which three statements are true? (Choose three.)

  A. This impdp operation creates the view as a table and populates it with data from the export dump file.

  B. The exdp operation exports data that satisfies the conditions of the defining query used when the view was created.

  C. Metadata for dependent objects required to create the SALES_Q1 view is exported.

  D. All rows from the dependent objects that are required are exported along with the metadata to create the SALES_Q1 view.

  E. The impdp operation creates the view and the dependent object.

  Correct Answer: ABE

• Question 2:

  Identify the category of recommendation that can be implemented automatically by the Automatic SQL Tuning Advisor.

  A. creating SQL profiles

  B. restructuring SQL statements

  C. creating invisible indexes

  D. reducing wait events

  E. partitioning a table

  Correct Answer: A

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#i36217

• Question 3:

  Your database supports an online transaction processing (OLTP) workload on an SMP machine.

  The database is stored in ASM.

  Examine these initialization parameters.

  

  Applications are update intensive using indexed access and modified blocks are written in batches by the DBWR process.

  You notice a large number of free buffer waits and increase the size of the buffer cache, but eventually the same waits occur.

  Which two actions would you recommend? (Choose two.)

  A. decrease the size of the buffer cache

  B. configure asynchronous I/O

  C. modifying the ASM disk for the database to use high redundancy

  D. configure multiple DBWn processes

  E. configure I/O slaves for the DBWR process

  Correct Answer: AE

  Reference: https://docs.oracle.com/cd/B16240_01/doc/doc.102/e16282/oracle_database_help/ oracle_database_wait_bottlenecks_free_buffer_waits_pct.html

• Question 4:

  Which action takes place when an incremental checkpoint occurs?

  A. The checkpoint position is advanced by the checkpoint process.

  B. Redo entries are written by the checkpoint process to the online redo log files.

  C. All dirty buffers are written to data files by the checkpoint process.

  D. The checkpoint position is written to all the data file headers and the control file by the checkpoint process.

  E. The checkpoint position is written to the control file by the checkpoint process.

  Correct Answer: C

  Reference: http://www.dba-oracle.com/t_incremental_checkpoint.htm

• Question 5:

  Your database runs in NOARCHIVELOG mode.

  Whole database backups are taken daily.

  A media failure damages data files belonging to the USERS tablespace and the online redo log files.

  The hardware that is causing this damage is not repairable.

  You issue the SHUTDOWN ABORT command.

  Examine these steps:

  1.

  Restore only the damaged files from the whole database backup to a new location.

  2.

  Restore the whole database backup to a new location.

  3.

  Edit the restored initialization parameter file to indicate the new location of the control files.

  4.

  Issue the STARTUP MOUNT command.

  5.

  Issue the STARTUP NOMOUNT command.

  6.

  Issue the RECOVER DATABASE command.

  7.

  Update the control file to reflect the new data file locations by using the ALTER DATABASE RENAME FILE command.

  8.

  Specify a new location for each affected online log by issuing the command: RECOVER DATABASE UNTIL CANCEL

  9.

  Open the database in RESETLOGS mode.

  Identify the minimum steps required in the correct sequence to recover your database.

  A. 1, 3, 5, 8, 9

  B. 1, 4, 7, 8, 9

  C. 1, 3, 4, 6

  D. 2, 5, 6, 7, 9

  Correct Answer: B

• Question 6:

  The workload on your database remains the same between 9 AM and 6 PM on all days of the week.

  However, you notice performance degradation between 3 PM and 5 PM on some days.

  You want to identify regressed statements by comparing the workload between these two periods.

  Examine these steps:

  1.

  Create a SQL Tuning Set (STS) for the statements cached in the library cache for both periods.

  2.

  Generate a Compare Period AWR report for both periods.

  3.

  Run the SQL Performance Analyzer (SPA) on the STS captured for both periods.

  4.

  Run the SQL Tuning Analyzer on the STS captured for both periods.

  5.

  Run the SQL Access Advisor on the STS captured for both periods.

  6.

  Run the Compare Period ADDM report for both periods. Identify the required steps to accomplish the task.

  A. 1 and 3

  B. 1 and 5

  C. 1 and 2

  D. only 6

  E. 1 and 4

  F. only 2

  Correct Answer: A

  Reference https://www.oracle.com/technetwork/oem/db-mgmt/spa-migration-to-cloud-3415493.pdf

• Question 7:

  You configured the Fast Recovery Area (FRA) for your database, which is in ARCHIVELOG mode.

  The default location for the archived log files is the Fast Recovery Area.

  There are no guaranteed restore points defined in the database.

  Which two file types are removed automatically based on RMAN retention policy settings, if there is

  pressure for space in the FRA? (Choose two.)

  A. obsolete RMAN backups

  B. flashback log files

  C. user-managed backups of control files

  D. expired RMAN backups

  E. archived redo log duplexed to another destination but not yet backed up

  F. user-managed backups of data files

  Correct Answer: BD

• Question 8:

  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.

  Correct Answer: AC

• Question 9:

  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.

  Correct Answer: A

• Question 10:

  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.

  Correct Answer: BC