Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 101:

  Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace.

  A user issues a query on the orders table and receives the following error:

  ERROR at line 1:

  ORA-01565: error in identifying file

  '/u01/app/oracle/oradata/TEST/temp01.tmp'

  ORA-27037: unable to obtain file status

  What would be the most efficient way to rectify this error?

  A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.
  B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
  C. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.
  D. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.
  A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.

• Question 102:

  You are administering a multitenant container database (CDB) cdb1.

  Examine the command and its output:

  SQL>show parameterfile

  NAMETYPEVALUE

  db_create_file_deststring

  db_file_name_convertstring

  db_filesinteger200

  You verify that sufficient disk space is available and that no file currently exists in the `/u0l/app/oracle/oradata/cdb1/salesdb' location.

  You plan to create a new pluggable database (PDB) by using the command:

  SQL>CREATEPLUGGABLEDATABASESALESPDB

  ADMINUSERsalesadmIDENTIFIED 3Y password

  ROLES=(dba)

  DEFAULTTABLESPACEsales

  DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbf'SIZE 250M AUTOEXTEND ON

  FILE_NAME_CONVERT=(`/u01/app/oracle/oradata/cdb1/pdbseed/',

  '/u01/app/oracle/oradata/cdb1/salesdb/')

  STORAGE(MAXSIZE2G)

  PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';

  Which statement is true?

  A. SALESPDB is created and is in mount state.
  B. PDB creation fails because the D3_file_name_convert parameter is not set in the CDB.
  C. SALESPDB is created and is in read/write mode.
  D. PDB creation fails because a default temporary tablespace is not defined for SALESPDB.
  A. SALESPDB is created and is in mount state.

  ---

  We need seed tablespace to create new plugable db. Reference: /u01/app/oracle/oradata/orcl/pdbseed/sysaux01.dbf /u01/app/oracle/oradata/orcl/pdbseed/system01.dbf By default. Seed has two tbs.

• Question 103:

  You are connected to a recovery catalog and target database. You execute the command:

  RMAN> CATALOG START WITH `/disk1/backups';

  Which statement is true?

  A. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.
  B. It lists all the data file copies, backup pieces, and archived logs cataloged in the recovery catalog in the /disk1/backups directory and its subdirectories.
  C. Only valid data file copies, existing in the /disk1/backups directory, are cataloged.
  D. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.
  A. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.

• Question 104:

  Which statement is true about unified auditing?

  A. The unified audit trail contains audit records only from unified audit policies and AUDIT settings
  B. Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS
  C. Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE
  D. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace
  D. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace

• Question 105:

  You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted. Identify two methods to recover the temp file with the least disruption to database availability. (Choose two.)

  A. Restart the database instance to create the temp file automatically
  B. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp files that is corrupted
  C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file
  D. Drop the TEMP tablespace, and then re-create it with new temp files
  A. Restart the database instance to create the temp file automatically
  B. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp files that is corrupted

• Question 106:

  You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running. Which two statements are true?

  A. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
  B. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
  C. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.
  D. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.
  E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.
  C. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.
  E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

  ---

  https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

• Question 107:

  Identify three benefits of unified auditing.

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

• Question 108:

  You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.

  Which three storage options support the use of HCC?

  A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
  B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
  C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
  D. Database files stored in ZFS and accessed using conventional NFS mounts.
  E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
  F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
  G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
  A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
  E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
  G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

  ---

  HCC requires the use of Oracle Storage ?Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance (ZFSSA). Note:

  *

  Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above

  *

  Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.

• Question 109:

  Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):

  SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;

  SQL> CREATE ROLE c##role1 CONTAINER=ALL;

  SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;

  SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL;

  SQL> REVOKE c##role1 FROM c##a_admin;

  What is the result of the revoke command?

  A. It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.
  B. It fails and reports an error because the container=all clause is not used.
  C. It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database and all the PDBs.
  D. It fails and reports an error because the comtainer=current clause is not used.
  B. It fails and reports an error because the container=all clause is not used.

  ---

  SQL> REVOKE c##role1 FROM c##a_admin; REVOKE c##role1 FROM c##a_admin * ERROR at line 1: ORA - 01951: ROLE `C##ROLE1' not granted to `C##A_ADMIN' SQL> REVOKE c##role1 FROM c##a_admin CONTAINER=ALL; Revoke succeeded. SQL> This CREATE USER c##a_admin IDENTIFIED BY orcl123; will create common user event container is not specified.

• Question 110:

  Examine this command:

  SQL>ALTER SYSTEM SET db_securefile = `IGNORE';

  Which statement is true?

  A. It forces SecureFiles to be created even if the BASICFILE option is specified
  B. It forces SecureFiles to be created using default values and ignores any SECUREFILE parameters
  C. It forces BasicFiles to be created even if the SECUREFILE option is specified
  D. It ignores the SECUREFILE option only if storing the LOB segment in a Free List managed tablespace
  C. It forces BasicFiles to be created even if the SECUREFILE option is specified