Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 51:

  You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?

  A. DATE
  B. TIMESTAMP
  C. INTERVAL YEAR TO MONTH
  D. INTERVAL DAY TO SECOND
  E. TIMESTAMP WITH LOCAL TIME ZONE
  B. TIMESTAMP
  E. TIMESTAMP WITH LOCAL TIME ZONE

  ---

  Reference: http://docs.oracle.com/database/121/NLSPG/ch3globenv.htm#i1007084

• Question 52:

  You create a new database by using the CREATE DATABASE command in SQL*Plus, with the ENABLE PLUGGABLE DATABASE clause specified.

  Which statement is true about the database that is created? (Choose the best answer.)

  A. It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.
  B. It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).
  C. It is created as a PDB that must be plugged into an existing CDB.
  D. It is created as a CDB with the CDB$ROOT and PDB$SEED databases.
  D. It is created as a CDB with the CDB$ROOT and PDB$SEED databases.

• Question 53:

  Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:

  1.

  Create a policy to capture the privileges used by a user for privilege analysis.

  2.

  Generate a report with the data captured for a specified privilege capture.

  3.

  Start analyzing the data captured by the policy.

  4.

  Revoke the unused privileges.

  5.

  Compare the used and unused privileges' lists.

  6.

  Stop analyzing the data.

  Identify the correct sequence of steps.

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

  ---

  1. Create a policy to capture the privilege used by a user for privilege analysis.

  3. Start analyzing the data captured by the policy.

  6. Stop analyzing the data.

  2. Generate a report with the data captured for a specified privilege capture.

  5. Compare the used and unused privileges' lists.

  4. Revoke the unused privileges.

• Question 54:

  You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.

  Which method or feature should you use?

  A. Compare Period ADDM report
  B. AWR Compare Period report
  C. Active Session History (ASH) report D. taking a new snapshot and comparing it with a preserved snapshot
  B. AWR Compare Period report

  ---

  Comparing Current System Performance to a Baseline Period You may have noticed a performance change on a production system and would like to know why, or you may have implemented a change to a production system and want to know the effect of the change, such as increased concurrency waits. The Compare Period ADDM compares the performance of the database server in two time periods, and returns a report describing the performance changes and the root origin of the changes. The Advisor can analyze any Oracle RDBMS version 10.2.0.4 or later monitored by Cloud Control. The following procedure explains how to initiate a report from the Compare Period ADDM.

• Question 55:

  Examine the RMAN command:

  RMAN> BACKUP VALIDATE DATABASE;

  Which statement is true about the execution of the command?

  A. Block change tracking must be enabled before executing this command.
  B. The database must be running in archivelog mode for the successful execution of this command.
  C. A complete database backup must exist before executing this command.
  D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.
  E. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.
  D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.

• Question 56:

  A redaction policy was added to the SAL column of the SCOTT.EMP table:

  BEGIN

  DBMS_REDACT.ADD_POLICY(

  OBJECT_SCHEMA => `SCOTT',

  OBJECT_NAME => `EMP',

  POLICY_NAME => `SCOTT_EMP',

  COLUMN_NAME => `SAL',

  EXPRESSION => `SYS_CONTEXT (``SYS_SESSION_ROLES'', ``MGR'') = ``FALSE''');

  END;

  /

  All users have their default set of system privileges.

  For which three situations will data not be redacted? (Choose three.)

  A. SCOTT sessions, because he is the owner of the table
  B. SCOTT sessions, only if the MGR role is granted to SCOTT
  C. SCOTT sessions, only if the MGR role is set in the session
  D. SYS sessions, regardless of the roles that are set in the session
  E. SYSTEM sessions, regardless of the roles that are set in the session
  B. SCOTT sessions, only if the MGR role is granted to SCOTT
  C. SCOTT sessions, only if the MGR role is set in the session
  D. SYS sessions, regardless of the roles that are set in the session

• Question 57:

  Which two statements are true regarding Oracle Data Pump?

  A. EXPDP and IMPDP are the client components of Oracle Data Pump.
  B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
  C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
  D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
  E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
  A. EXPDP and IMPDP are the client components of Oracle Data Pump.
  B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

  ---

  References: http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm

• Question 58:

  Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)

  A. The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.
  B. The MTTR advisor is enabled only if the value is greater than the default value.
  C. Automatic checkpoint tuning is enabled.
  D. The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.
  A. The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.
  B. The MTTR advisor is enabled only if the value is greater than the default value.

  ---

  Reference: https://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm

• Question 59:

  Examine the command to back up the ASM metadata:

  ASMCMD>md_backup /backup/ASM_backup

  In which three situations can you use the backup?

  A. when one or more disks in an ASM disk group are lost
  B. when the data file on an ASM disk group gets corrupted
  C. when one of the disks in a disk group is accidentally unplugged
  D. when one or more file directory paths are accidentally deleted from an ASM disk group
  E. when all the ASM disk groups for the ASM instance are lost
  A. when one or more disks in an ASM disk group are lost
  D. when one or more file directory paths are accidentally deleted from an ASM disk group
  E. when all the ASM disk groups for the ASM instance are lost

  ---

  The md_backup command creates a backup file containing metadata for one or more disk groups. i By default all the mounted disk groups are included in the backup file which is saved in the current working directory.

  The md_backup command creates a backup file containing metadata for one or more disk groups.

  Reference:http://www.hhutzler.de/blog/asm-backup-and-restore-dg-metadata/

  http://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_util004.htm#OSTMG94578

• Question 60:

  You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.

  Which two backup solutions can be used?

  A. RMAN recovery catalog
  B. RMAN Media Management Library
  C. Enterprise Manager Cloud Control
  D. Enterprise Manager Database Express
  E. Oracle Secure Backup
  A. RMAN recovery catalog
  C. Enterprise Manager Cloud Control

  ---

  Enterprise Manager allows a centralized control of database backups. It is possible to set up and schedule RMAN backups for all the databases in a large company, use a consistent backup strategy, and refer to all past RMAN output logs at any time, since they are stored in the Enterprise Manager Cloud Control repository. There is no need to use a central RMAN catalog, because information about the backups is centrally available from Enterprise Manager. And with the group backup feature new to Enterprise Manager Cloud Control 12c, it can be even faster to set up RMAN backups for all the databases-even if there are thousands-that are part of an Enterprise Manager group. References: http://www.oracle.com/technetwork/articles/oem/havewala-rman-em12c-2104270.html