Free Upgrade to Oracle Database 12c 1Z0-060 Exam Practice Test

You notice a performance change in your production Oracle 12c database and you want to know what change caused this performance difference. You generate the compare period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.Which three findings would you get from the report? (Choose three.)

• It shows the resource usage for CPU, memory, and I/O in both time periods.
  
• It identifies any workload change that caused the performance difference in both time periods.
  
• It detects any configuration change that caused the performance difference in both time periods.
  
• It gives information about statistics collection in both time periods.
  
• It detects the top wait events causing performance degradation.
  

You create a new pluggable database, HR_PDB, from the seed database.Which three tablespaces are created by default in HR_PDB? (Choose three.)

• SYSTEM
  
• SYSAUX
  
• EXAMPLE
  
• UNDO
  
• TEMP
  
• USERS
  

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions.The table has a local prefixed, range partitioned index.Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.Which three methods could transparently help to achieve this result? (Choose three.)

• Using a partial local index on the warehouse fact table month column with indexing disabled for the table partitions that return most of their rows to the queries.
  
• Using a partial local index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
  
• Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
  
• Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.
  
• Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
  
• Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
  

Which two statements are true when row-archival management is enabled? (Choose two.)

• The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
  
• Visibility of the ORA_ARCHIVE_STATE column is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
  
• The ROW ARCHIVAL VISIBILITY session parameter defaults to all rows.
  
• The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
  
• The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.
  

You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.Which three storage options support the use of HCC? (Choose three.)

• ASM disk groups with ASM disks consisting of Exadata Grid Disks.
  
• ASM disk groups with ASM disks consisting of LUNs on any Storage Area Network array
  
• ASM disk groups with ASM disks consisting of any zero-padded NFS-mounted files
  
• Database files stored in ZFS and accessed using conventional NFS mounts.
  
• Database files stored in ZFS and accessed using the Oracle Direct NFS feature
  
• Database files stored in any file system and accessed using the Oracle Direct NFS feature
  
• ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
  

Which three statements are true about the use of the query result cache? (Choose three.)

• Results obtained from a query rewrite to a materialized view may be stored in the query result cache.
  
• Stale results may still be obtained from the query result cache, if the query session's query_rewrite_integrity parameter is set to stale_tolerated.
  
• Results obtained from a join between a table and a view may be stored in the query result cache.
  
• Results from distributed queries are never stored in the query result cache.
  
• Results may not be obtained from the query result cache, when the query_rewrite_enabled parameter is set to false.
  
• Results from remote queries may sometimes be stored in the query result cache.
  

Which three functions are performed by the SQL Tuning Advisor? (Choose three.)

• Building and implementing SQL profiles
  
• Recommending the optimization of materialized views
  
• Checking query objects for missing and stale statistics
  
• Recommending bitmap, function-based, and B-tree indexes
  
• Recommending the restructuring of SQL queries that are using bad plans
  

Identify three valid methods of opening, pluggable databases (PDBs). (Choose three.)

• ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root
  
• ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB
  
• ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed
  
• ALTER DATABASE PDB OPEN issued from the root
  
• ALTER DATABASE OPEN issued from that PDB
  
• ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB
  
• ALTER PLUGGABLE DATABASE OPEN issued from that PDB
  

You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.Which statement is true?

• The ORACLE_BASE base parameter is not set.
  
• The installation is being performed by the root user.
  
• The operating system group that is specified should have the root user as its member.
  
• The operating system group that is specified must have permission to write to the inventory directory.
  

You want to upgrade your pre-12c database to an Oracle 12c database. You set up the test environment and replay the captured workload from the production database on the test machine twice with a time difference of four hours.For which three reasons would you use the Compare Period ADDM report after the replay? (Choose three.)

• to check the database time consumed for the two time periods
  
• to review the change in the initialization parameters between the two runs
  
• to find the resource consumption by SQL statements that are common to both periods
  
• to check the performance improvement and degradation caused during the change
  
• to review the hardware resources used during the two runs
  
• to compare the performance change of top SQL statements for the two runs