Oracle 1Z0-060 Online Practice Questions and Exam Preparation

Oracle 1Z0-060 Online Questions & Answers

• Question 1:

  Identify three benefits of Unified Auditing.

  A. Decreased use of storage to store audit trail rows in the database.
  B. It improves overall auditing performance.
  C. It guarantees zero-loss auditing.
  D. The audit trail cannot be easily modified because it is read-only.
  E. It automatically audits Recovery Manager (RMAN) events.
  B. It improves overall auditing performance.
  D. The audit trail cannot be easily modified because it is read-only.
  E. It automatically audits Recovery Manager (RMAN) events.

  ---

  https://blogs.oracle.com/imc/entry/oracle_database_12c_new_unified

• Question 2:

  You execute the following PL/SQL:

  

  Which two statements are true?

  A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.
  B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.
  C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
  D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
  A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.
  D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

  ---

  DBMS_FGA.ADD_POLICY(object_schema => `hr',object_name => `emp',policy_name => `chk_hr_emp',audit_condition => `dept = "SALES" `,audit_column => `salary'statement_types => `insert,update,delete,select'); Default value for

  statement_types is SELECT

  Setting audit_trail to DBMS_FGA.DB sends the audit trail to the SYS.FGA_LOG$ table in the database and omits SQL Text and SQL Bind.

  Setting audit_trail to DBMS_FGA.DB+EXTENDED sends the audit trail to the SYS.FGA_LOG$ table in the database and includes SQL Text and SQL Bind.

  Setting audit_trail to DBMS_FGA.XML writes the audit trail in XML files sent to the operating system and omits SQL Text and SQL Bind.

  Setting audit_trail to DBMS_FGA.XML+EXTENDED writes the audit trail in XML files sent to the operating system and includes SQL Text and SQL Bind.

  Default value fo audit_trail parameter in DBMS_FGA.ADD_POLICY is DB+EXTENDED

• Question 3:

  What is the result of executing a TRUNCATE TABLE command on a table, in a non-CDB database, that has Flashback Archiving enabled?

  A. It fails with the ORA-665610 Invalid DDL statement on history-tracked message
  B. The rows in the table and the archive are truncated, and flashback archiving is disabled.
  C. The rows in the table are truncated without being archived.
  D. The rows in the table are archived, and then truncated.
  E. The rows in both the table and the archive are truncated.
  D. The rows in the table are archived, and then truncated.

  ---

  http://surachartopun.com/2010/06/ddl-on-tables-enabled-for-flashback.html

• Question 4:

  Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output:

  

  What does this imply?

  A. When you start an instance on a host with SQL *Plus, dependent listeners and ASM disk groups are automatically started.
  B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
  C. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
  D. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
  B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.

  ---

  About Startup Dependencies Oracle Restart ensures that Oracle components are started in the proper order, in accordance with component dependencies. For example, if database files are stored in Oracle ASM disk groups, then before starting the database instance, Oracle Restart ensures that the Oracle ASM instance is started and the required disk groups are mounted. Likewise, if a component must be shut down, Oracle Restart ensures that dependent components are cleanly shut down first. Oracle Restart also manages the weak dependency between database instances and the Oracle Net listener (the listener): When a database instance is started, Oracle Restart attempts to start the listener. If the listener startup fails, then the database is still started. If the listener later fails, Oracle Restart does not shut down and restart any database instances.

  References: http://docs.oracle.com/cd/E16655_01/server.121/e17636/restart.htm#ADMIN12710

• Question 5:

  Which three are true about the large pool for an Oracle database instance that supports shared server connections?

  A. Allocates memory for RMAN backup and restore operations
  B. Allocates memory for shared and private SQL areas
  C. Contains a cursor area for storing runtime information about cursors
  D. Contains stack space
  E. Contains a hash area performing hash joins of tables
  A. Allocates memory for RMAN backup and restore operations
  B. Allocates memory for shared and private SQL areas
  C. Contains a cursor area for storing runtime information about cursors

  ---

  The large pool can provide large memory allocations for the following: / (B)UGA (User Global Area) for the shared server and the Oracle XA interface (used where transactions interact with multiple databases) /Message buffers used in the parallel execution of statements / (A) Buffers for Recovery Manager (RMAN) I/O slaves

  Note:

  *

  large pool

  Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O server processes, and session memory for the shared server and Oracle XA.

  *

  Oracle XA

  An external interface that allows global transactions to be coordinated by a transaction manager other than Oracle Database.

  *

  UGA

  User global area. Session memory that stores session variables, such as logon information, and can also contain the OLAP pool.

  *

  Configuring the Large Pool

  Unlike the shared pool, the large pool does not have an LRU list (not D). Oracle Database does not attempt to age objects out of the large pool. Consider configuring a large pool if the database instance uses any of the following Oracle

  Database features:

  *

  Shared server

  In a shared server architecture, the session memory for each client process is included in the shared pool.

  *

  Parallel query

  Parallel query uses shared pool memory to cache parallel execution message buffers.

  *

  Recovery Manager

  Recovery Manager (RMAN) uses the shared pool to cache I/O buffers during backup and restore operations. For I/O server processes, backup, and restore operations, Oracle Database allocates buffers that are a few hundred kilobytes in

  size.

• Question 6:

  Examine the following command:

  ALTER SYSTEM SET enable_ddl_logging=FALSE;

  Which statement is true?

  A. None of the data definition language (DDL) statements are logged in the trace file.
  B. Only DDL commands that resulted in errors are logged in the alert log file.
  C. A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
  D. Only DDL commands that resulted in the creation of new database files are logged.
  A. None of the data definition language (DDL) statements are logged in the trace file.

  ---

  ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL alert log.

  The DDL log is a file that has the same format and basic behavior as the alert log, but it only contains the DDL statements issued by the database. The DDL log is created only for the RDBMS component and only if the ENABLE_DDL_LOGGING initialization parameter is set to true. When this parameter is set to false, DDL statements are not included in any log.

• Question 7:

  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?

  A. Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
  B. 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.
  C. 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.
  D. 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.
  E. 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.
  F. 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.
  A. Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
  C. 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.
  E. 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.

• Question 8:

  DBS_IND_PARTITIONS.ORPHANED_ENTRIES contains YES for several index partitions. This is due to the use of deferred index maintenance.

  Which three methods will remove the orphaned keys? (Choose three.)

  A. using ALTER INDEX REBUILD PARTITION once for each affected local index partition
  B. using DBMS_PART.CLEANUP_GIDX once to clean up orphaned keys in all local indexes.
  C. using ALTER INDEX COALESCE PARTITION CLEANUP once for each affected global index partition
  D. using DBMS_PART.CLEANUP_CIDX once to clean up any orphaned keys in all global indexes on partitioned tables.
  E. using ALTER INDEX COALESCE PARTITION CLEANUP once for each affected local index partition
  F. using ALTER INDEX REBUILD PARTITION once for each affected global index partition
  A. using ALTER INDEX REBUILD PARTITION once for each affected local index partition
  B. using DBMS_PART.CLEANUP_GIDX once to clean up orphaned keys in all local indexes.
  C. using ALTER INDEX COALESCE PARTITION CLEANUP once for each affected global index partition

• Question 9:

  Which statement is true about Oracle Net Listener?

  A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
  B. A single listener can service only one database instance and multiple remote client connections.
  C. Service registration with the listener is performed by the listener registration process (LREG) process of each database instance.
  D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
  E. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directory.
  C. Service registration with the listener is performed by the listener registration process (LREG) process of each database instance.

• Question 10:

  Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.

  You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:

  SQL > SHUTDOWN IMMEDIATE

  SQL > STARTUP MOUNT

  SQL > FLASHBACK DATABASE to TIME "TO_DATE ('08/20/12','MM/DD/YY')";

  Examine following commands:

  1.

  ALTER PLUGGABLE DATABASE ALL OPEN;

  2.

  ALTER DATABASE OPEN;

  3.

  ALTER DATABASE OPEN RESETLOGS;

  Which command or commands should you execute next to allow updates to the flashed back schema?

  A. Only 1
  B. Only 2
  C. Only 3
  D. 3 and 1
  E. 1 and 2
  D. 3 and 1

  ---

  http://www.oracle-base.com/articles/12c/multitentant-flashback-of-container-database-12cr1.php