Oracle Oracle Certifications 1Z0-067 Questions & Answers

• Question 151:

  Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:

  SQL> CREATE USER c##a_admin IDENTIFIED BY password DEFAULT TABLESPACE users QUOTA I00M ON users TEMPORARY TABLESPACE temp;

  Which statement is true about the execution of the command?

  A. The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.

  B. The command succeeds only if all the PDBs have the users and temp tablespaces.

  C. The command gives an error because the container=all clause is missing.

  D. The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tabiespace does not exist in that PDB.

  Correct Answer: B

  When creating a common user, any tablespace, tablespace group or profile specified in the CREATE command must exist in every PDB. If none of these are specified, the default TABLESPACE, TEMPORARY TABLESPACE, and PROFILE for the PDB will be used.

• Question 152:

  Which two statements are true about the Automatic Diagnostic Repository (ADR)?

  A. The ADR base is shared across multiple instances.

  B. The ADR base keeps all diagnostic information in binary format.

  C. The ADR can be used to store statspack snapshots to diagnose database performance issues.

  D. The ADR can be used for problem diagnosis even when the database instance is down.

  E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

  Correct Answer: AD

  Reference: https://oracle-base.com/articles/11g/automatic-diagnostics-repository-11gr1

• Question 153:

  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. 2, 1, 6, and 4

  B. 2, 3, and 6

  C. 3, 1, 5, and 6

  D. 2, 3, 1, and 6

  E. 1, 5, and 4

  Correct Answer: D

  Reference: http://docs.oracle.com/cd/B19306_01/install.102/b15660/app_nonint.htm

• Question 154:

  Which three statements are true about the keystore storage framework for transparent data encryption?

  A. It facilitates and helps to enforce keystore backup requirements.

  B. It handles encrypted data without modifying applications.

  C. It enables a keystore to be stored only in a file on a file system.

  D. It enables separation of duties between the database administrator and the security administrator.

  E. It transparently decrypts data for the database users and applications that access this data.

  F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

  Correct Answer: ADF

  References: http://oradb-srv.wlv.ac.uk/E16655_01/network.121/e17729/asotrans.htm#CHDEABCA (benefits of the keystore storage framework)

• Question 155:

  You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent

  objects. During this operation, you want to ensure the following:

  i.Long-running queries are not affected.

  ii.No extra space is used.

  iii.Data manipulation language (DML) operations on the table succeed at all times throughout the process.

  iv.Unused space is reclaimed both above and below the high water mark.

  Which alter TABLE option would you recommend?

  A. DEALLOCATE UNUSED

  B. SHRINK SPACE CASCADE

  C. SHRINK SPACE COMPACT

  D. ROW STORE COMPRESS BASIC

  Correct Answer: C

  The COMPACT clause lets you divide the shrink segment operation into two phases. When you specify COMPACT, Oracle Database defragments the segment space and compacts the table rows but postpones the resetting of the high water mark and the deallocation of the space until a future time. This option is useful if you have long-running queries that might span the operation and attempt to read from blocks that have been reclaimed. The defragmentation and compaction results are saved to disk, so the data movement does not have to be redone during the second phase. You can reissue the SHRINK SPACE clause without the COMPACT clause during off-peak hours to complete the second phase. References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm

• Question 156:

  You are administering a database that supports data warehousing workload and Is running in noarchivelog

  mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the

  other days of the week.

  One of the data files is corrupted and the current online redo log file is lost because of a media failure.

  You want to recover the data file.

  Examine the steps involved in the recovery process:

  1.Shut down the database instance.

  2.Start up the database instance in nomount state.

  3.Mount the database.

  4.Take the data file offline.

  5.Put the data file online.

  6.Restore the control file.

  7.Restore the database.

  8.Restore the data file.

  9.Open the database with the resetlog option.

  10.Recover the database with the noredo option.

  11.Recover the data file with the noredo option.

  Identify the required steps in the correct order.

  A. 4, 8, 11, 5

  B. 1, 3, 8, 11, 9

  C. 1, 2, 6, 3, 7, 10, 9

  D. 1, 3, 7, 10, 9

  E. 1, 2, 6, 3, 8, 11, 9

  Correct Answer: C

• Question 157:

  Examine the commands:

  SQL> ALTER SESSION SET RECYCLBIN = ON;

  Session altered.

  SQL> DROP TABLE emp; --(First EMP table)

  Total dropped.

  SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2

  (15), salary NUMBER(7,2) );

  Table created.

  You then execute multiple INSERT statements to insert rows into EMP table and drop the table again:

  SQL> DROP TABLE emp; -- (Second EMP table)

  Table dropped.

  SQL> FLASHBACK TABLE emp TO BEFORE DROP;

  Which statement is true about the FLASHBACK command?

  A. It recovers the structure, data, and indexes of the first emp table.

  B. It recovers only the structure of the second emp table.

  C. It returns an error because two tables with the same name exist in the recycle bin.

  D. It recovers the structure, data, and indexes of the second emp table.

  Correct Answer: D

• Question 158:

  You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.

  The statistics_level parameter is PDB modifiable.

  As the user sys, execute the following command on pdb2:

  SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;

  Which statement is true about the result of this command?

  A. The statistics_level parameter is set to all when any of the PDBs is reopened.

  B. The statistics_level parameter is set to all only for PDB2 when it is reopened.

  C. The statistics_level parameter is set to all when the root database is restarted.

  D. The statement is ignored because there is no SPFILE for a PDB.

  Correct Answer: B

  This ALTER SYSTEM statement sets the STATISTICS_LEVEL initialization parameter to ALL for the current PDB: ALTER SYSTEM SET STATISTICS_LEVEL = ALL SCOPE = MEMORY;

  Reference: http://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN14018

• Question 159:

  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

  Correct Answer: ADE

  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 160:

  LDAP_DIRECTORY_SYSAUTH is set to YES.

  Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID).

  SSL has been configure for the database and OLD and the password file has been configured for the database.

  User scott with sysdba privilege tries to connect remotely using this command:

  $sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.

  Which authentication method will be attempted first?

  A. authentication by password file

  B. authentication by using certificates over SSL

  C. authentication by using the Oracle Internet Directory D. authentication by using the local OS of the database server

  Correct Answer: A

  If the database is configured to use a password file for remote authentication, Oracle Database checks the

  password file first.

  Reference:

  http://docs.oracle.com/cd/E25054_01/network.1111/e16543/authentication.htm