Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 1:

  Which two statements are true about unified auditing?

  A. A unified audit trail captures audit information from unified audit policies and audit settings.
  B. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.
  C. Audit records are created for all users except sys.
  D. Audit records are created only for the DML and DDL operations performed on database objects.
  E. Unified auditing is enabled by setting the audit_trail parameter to db, extended.
  F. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.
  A. A unified audit trail captures audit information from unified audit policies and audit settings.
  B. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.

  ---

  In unified auditing, the unified audit trail captures audit information from a variety of sources. Audit records (including SYS audit records) from unified audit policies and AUDIT settings Fine-grained audit records from the DBMS_FGA PL/SQL package Oracle Database Real Application Security audit records Oracle Recovery Manager audit records Oracle Database Vault audit records Oracle Label Security audit records Oracle Data Mining records Oracle Data Pump Oracle SQL*Loader Direct Load Enable theunified auditing executable. UNIX: Run the following command: make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME The unified audit trail, which resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace References: https://docs.oracle.com/database/121/DBSEG/auditing.htm#DBSEG343 https://docs.oracle.com/database/121/TDPSG/GUID-BF747771-01D1-4BFB-8489-08988E1181F6.htm#TDPSG55281 https://docs.oracle.com/database/121/DBSEG/auditing.htm#DBSEG1024

• Question 2:

  Which three statements are true about transportable databases? (Choose three.)

  A. The transported database must have the same database identifier (DBID) as the source database
  B. Recovery Manager (RMAN) is used to convert the necessary data files of a database if the endian format of the target platform is different
  C. The COMPATIBLE parameter must be set to 10.0.0 or higher and the database must be opened in read-only mode before being transported
  D. Redo logs and control files are also transported
  E. Both the source and target databases must use the same character set
  B. Recovery Manager (RMAN) is used to convert the necessary data files of a database if the endian format of the target platform is different
  C. The COMPATIBLE parameter must be set to 10.0.0 or higher and the database must be opened in read-only mode before being transported
  D. Redo logs and control files are also transported

• Question 3:

  You issue the command:

  SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

  Which statement is true about the command?

  A. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.
  B. It creates a file that contains the SQL statement, which is required to re-create the control file.
  C. It updates the alert log file with the location and contents of the control file.
  D. It creates a binary backup of the control file.
  B. It creates a file that contains the SQL statement, which is required to re-create the control file.

  ---

  Explanation: "TO TRACE" creates a file with the SQL, not a copy of the control file.

• Question 4:

  Which two statements are true when row-archival management is enabled?

  A. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
  B. 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.
  C. The row archival visibility session parameter defaults to all rows.
  D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
  E. 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.
  B. 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.
  D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

• Question 5:

  For which three pieces of information can you use the RMAN list command?

  A. stored scripts in the recovery catalog
  B. available archived redo log files
  C. backup sets and image copies that are obsolete
  D. backups of tablespaces
  E. backups that are marked obsolete according to the current retention policy
  A. stored scripts in the recovery catalog
  B. available archived redo log files
  D. backups of tablespaces

  ---

  Explanation: About the LIST Command: The primary purpose of the LIST command is to list backup and copies. For example, you can list: -Backups and proxy copies of a database, tablespace, datafile, archived redo log, or control file Backups that have expired -Backups restricted by time, path name, device type, tag, or recoverability -Archived redo log files and disk copies Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585

• Question 6:

  Examine these Data Pump commands to export and import objects from and to the same database.

  The dba has not yet created users hr1 and oe1.

  $expdp system/manager schemas = hr.oe directory = EXP_DIR dumpfile = export.dat include = table

  $ impdpsysten/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat remap_schena=hr:hrl, oe:oe1

  What will happen when running these commands?

  A. expdp will fail because no path has been defined for the dumpfile.
  B. expdp will succeed but impdp will fail because the users do not exist.
  C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.
  D. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.
  B. expdp will succeed but impdp will fail because the users do not exist.

  ---

  ORA-39165: Schema not found error will be resulted

• Question 7:

  You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation? (Choose two.)

  A. The backup as copy can only be taken to disk
  B. The backup as copy can only be taken to tape
  C. Backup can be performed only when the instance is shutdown
  D. Backup will constitute all used and unused blocks in the database
  A. The backup as copy can only be taken to disk
  D. Backup will constitute all used and unused blocks in the database

• Question 8:

  Which two statements are true about a common user?

  A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
  B. A common user with the create user privilege can create other common users, as well as local users.
  C. A common user can be granted only a common role.
  D. A common user can have a local schema in a PDB.
  E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.
  B. A common user with the create user privilege can create other common users, as well as local users.
  D. A common user can have a local schema in a PDB.

  ---

  Reference: http://www.oracle.com/technetwork/issue-archive/2014/14-nov/o64ocp12c-2349447.html

• Question 9:

  You are administering a multitenant container database (CDB) cdb1 that is running in archivelog mode and contains pluggable databases (PDBs), pdb_1 and pdb_2.

  While opening pdb_1, you get an error:

  SQL> alter pluggable database pdb_1 open;

  ORA-01157: cannot identify/lock data file 11-see DBWR trace file

  ORA-01110:data file 11:'/u01/app/oracle/oradata/cdb1/pdb_1/example01.dbf'

  To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:

  RMAN>REPAIR FAILURE;

  Which statement describes the consequence of the command?

  A. The command performs the recovery and closes the failure.
  B. The command produces an error because RMAN is not connected to the target database pdb_1.
  C. The command produces an error because the advise failure command was not executed before the REPAIR FAILURE command.
  D. The command executes successfully, performs recovery, and opens PDB_1.
  C. The command produces an error because the advise failure command was not executed before the REPAIR FAILURE command.

  ---

  Usage Notes Repairs are consolidated whenever possible so that a single repair can fix multiple failures. Be advised that REPAIR FAILURE requires you to explicitly run ADVISE FAILURE in the current session to successfully repair each of the identified failures. You typically iterate through a REPAIR session with the following commands: -REPAIR FAILURE; -LIST FAILURE; -ADVISE FAILURE; -REPAIR FAILURE; Reference: http://docs.oracle.com/database/121/RCMRF/rcmsynta2004.htm#RCMRF199

• Question 10:

  Examine the initialization parameter that is set in the PFILE:

  DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'

  You execute the following command to create theCDB1. container database (CDB):

  SQL>CREATE DATABASE CDB1 DEFAULT TABLESPACE users DEFAULT TEMPORARY TABLESPACE temp UNDO TABLESPACE undotbsl ENABLE PLUGGABLE DATABASE SEED SYSTEM DATAFILES SIZE125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYS AUX DATAFILES SIZE 100M;

  Which three statements are true?

  A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
  B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
  C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
  D. It sets the users tablespace as the default for both the root and seed databases.
  E. undotbs1 is used as the undo tablespace for both the root and seed databases.
  F. It creates a multitenant container database with the root database opened and the seed database mounted.
  A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
  B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
  E. undotbs1 is used as the undo tablespace for both the root and seed databases.

  ---

  The seed actually doesn't use anything since it's read-only, but any PDB created from the seed will use the undotbs1 undo tablespace. Each PDB can have its own default tablespace, but cannot change the undo tablespace.