Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 51:

  What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

  A. It will create a multitenant container database (CDB) with only the root opened.
  B. It will create a CDB with root opened and seed read only.
  C. It will create a CDB with root and seed opened and one PDB mounted.
  D. It will create a CDB that must be plugged into an existing CDB.
  E. It will create a CDB with root opened and seed mounted.
  B. It will create a CDB with root opened and seed read only.

  ---

  *

  The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.

  Along with the root (CDB$ROOT), Oracle Database automatically creates a seed PDB (PDB$SEED). The following graphic shows a newly created CDB:

  *

  Creating a PDB

  Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing

  no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather,

  it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation.

  

• Question 52:

  A senior DBA asked you to execute the following command to improve performance:

  SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);

  You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.

  What could be a reason for this recommendation?

  A. The keep pool is not configured.
  B. Automatic Workarea Management is not configured.
  C. Automatic Shared Memory Management is not enabled.
  D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
  E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.
  D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

  ---

  The most of the rows in SUBSCRIBE_LOG table are accessed once a week.

• Question 53:

  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.
  A. Decreased use of storage to store audit trail rows in the database.
  B. It improves overall auditing performance.
  E. It automatically audits Recovery Manager (RMAN) events.

  ---

  A: Starting with 12c, Oracle has unified all of the auditing types into one single unit called Unified auditing. You don't have to turn on or off all of the different auidting types individually and as a matter of fact auditing is enabled by default right out of the box. The AUD$ and FGA$ tables have been replaced with one single audit trail table. All of the audit data is now stored in Secure Files table thus improving the overall management aspects of audit data itself.

  B: Further the audit data can also be buffered solving most of the common performance related problems seen on busy environments.

  E: Unified Auditing is able to collect audit data for Fine Grained Audit, RMAN, Data Pump, Label Security, Database Vault and Real Application Security operations.

  Note:

  * Benefits of the Unified Audit Trail

  The benefits of a unified audit trail are many:

  / (B) Overall auditing performance is greatly improved. The default mode that unified audit works is Queued Write mode. In this mode, the audit records are batched in SGA queue and is persisted in a periodic way. Because the audit records

  are written to SGA queue, there is a significant performance improvement.

  / The unified auditing functionality is always enabled and does not depend on the initialization parameters that were used in previous releases

  / (A) The audit records, including records from the SYS audit trail, for all the audited components of your Oracle Database installation are placed in one location and in one format, rather than your having to look in different places to find audit

  trails in varying formats. This consolidated view enables auditors to co-relate audit information from different components. For example, if an error occurred during an INSERT statement, standard auditing can indicate the error number and

  the SQL that was executed. Oracle Database Vault-specific information can indicate whether this error happened because of a command rule violation or realm violation. Note that there will be two audit records with a distinct AUDIT_TYPE.

  With this unification in place, SYS audit records appear with AUDIT_TYPE set to Standard Audit.

  / The management and security of the audit trail is also improved by having it in single audit trail.

  / You can create named audit policies that enable you to audit the supported components listed at the beginning of this section, as well as SYS administrative users. Furthermore, you can build conditions and exclusions into your policies.

  *

  Oracle Database 12c Unified Auditing enables selective and effective auditing inside the Oracle database using policies and conditions. The new policy based syntax simplifies management of auditing within the database and provides the ability to accelerate auditing based on conditions.

  *

  The new architecture unifies the existing audit trails into a single audit trail, enabling simplified management and increasing the security of audit data generated by the database.

• Question 54:

  Which three statements are true about automated maintenance tasks? (Choose three.)

  A. They run at predefined time intervals that are intended to occur during a period of low system load.
  B. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.
  C. A maintenance window is automatically extended until all the maintenance tasks defined are completed.
  D. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.
  E. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.
  A. They run at predefined time intervals that are intended to occur during a period of low system load.
  B. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.
  E. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.

  ---

  References: https://docs.oracle.com/cd/E11882_01/server.112/e25494/tasks.htm#ADMIN12331

• Question 55:

  Which two can be recommendations given by SQL Access Advisor? (Choose two.)

  A. creation of SQL plan baselines
  B. creation of SQL profiles
  C. creation of materialized views
  D. creation of indexes E. rewriting of SQL statements
  C. creation of materialized views
  D. creation of indexes E. rewriting of SQL statements

  ---

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14211/advisor.htm#i1008370

• Question 56:

  Which three statements are true about Oracle Data Pump? (Choose three.)

  A. Oracle Data Pump export and import operations can be performed to move data across different database releases.
  B. DBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients.
  C. A directory object must exist and a user performing an EXPDP or IMPDP operation must have read and write permission on that directory object.
  D. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
  E. Oracle Data Pump export operations invoked from the clients that are connected remotely by using a connection string, create Data Pump files on the client file system.
  A. Oracle Data Pump export and import operations can be performed to move data across different database releases.
  B. DBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients.
  C. A directory object must exist and a user performing an EXPDP or IMPDP operation must have read and write permission on that directory object.

• Question 57:

  You have a production Oracle 12c database running on a host.

  You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.

  The steps in random order:

  1.

  Create directory structures similar to the production database on all new machines.

  2.

  Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.

  3.

  Create a database clone template for the database.

  4.

  Run the Database Configuration Assistant (DBCA) to create the database.

  5.

  Run OUI in graphical mode on each machine.

  6.

  Run OUI in silent mode using the OUI response file.

  Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

  A. 1, 5, and 4
  B. 3, 1, 5, and 6
  C. 2, 3, 6, and 4
  D. 2, 1, 6, and 4
  E. 2, 3, 1, and 6
  E. 2, 3, 1, and 6

• Question 58:

  Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)

  A. Configure Label Security
  B. Database Vault in ORACLE_HOME
  C. Oracle Suggested Backup Strategy
  D. Database Resident Connection Pooling
  E. Nondefault blocksize tablespaces
  A. Configure Label Security
  B. Database Vault in ORACLE_HOME

• Question 59:

  In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?

  Both local and global partitioned B-tree Indexes are defined on the table.

  A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.

  Minimal disrupt ion to availability is required.

  Which three statements are true about this requirement? (Choose three.)

  A. The partitions can be moved online to new tablespaces.
  B. Global indexes must be rebuilt manually after moving the partitions.
  C. The partitions can be compressed in the same tablespaces.
  D. The partitions can be compressed in the new tablespaces.
  E. Local indexes must be rebuilt manually after moving the partitions.
  A. The partitions can be moved online to new tablespaces.
  C. The partitions can be compressed in the same tablespaces.
  D. The partitions can be compressed in the new tablespaces.

  ---

  A: You can create and rebuild indexes online. Therefore, you can update base tables at the same time you are building or rebuilding indexes on that table. You can perform DML operations while the index build is taking place, but DDL

  operations are not allowed. Parallel execution is not supported when creating or rebuilding an index online.

  D: Moving (Rebuilding) Index-Organized Tables

  Because index-organized tables are primarily stored in a B-tree index, you can encounter fragmentation as a consequence of incremental updates. However, you can use the ALTER TABLE...MOVE statement to rebuild the index and reduce

  this fragmentation.

  C: If a table can be compressed in the new tablespace, also it can be compressed in the same tablespace.

  Incorrect:

  Not B, not E: Local and Global indexes can be automatically rebuild with UPDATE INDEXES when you move the table.

• Question 60:

  You execute this command:

  

  Which two statements are true about segment space management for segments in this tablespace? (Choose two.)

  A. Space utilization inside segments is mapped by bitmaps.
  B. Segments are automatically shrunk and compressed when rows are deleted.
  C. The PCTFREE storage parameter has no effect on segments created in this tablespace.
  D. The PCTUSED storage parameter has no effect on segments created in this tablespace.
  A. Space utilization inside segments is mapped by bitmaps.
  D. The PCTUSED storage parameter has no effect on segments created in this tablespace.