Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 81:

  You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema. After a few days, you want to alter the EMPLOYEES table by executing the command:

  SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);

  Which statement is true about the execution of the command?

  A. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.
  B. It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.
  C. It executes successfully and continues to store metadata related to the EMPLOYEES table.
  D. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.
  C. It executes successfully and continues to store metadata related to the EMPLOYEES table.

  ---

  Flashback data archives retain historical data across data definition language (DDL) changes to the database as long as the DDL change does not affect the structure of the table. The one exception to this rule is that flashback data archives

  do retain historical data when a column is added to the table.

  References:

  https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_5009.htm

• Question 82:

  In the SPFILE, UNDO TABLESPACE is Set to UNDO TBS.

  You rename the undotbs undo tablespace:

  ALTER TABLESPACE undotbs RENAME TO undotbs_old;

  Which statement is true?

  A. The tablespace will be renamed but the data file headers will not be updated.
  B. The statement will fail because you cannot rename an undo tablespace.
  C. The tablespace will be renamed and all the changes will be logged in the alert log.
  D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.
  E. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.
  C. The tablespace will be renamed and all the changes will be logged in the alert log.

  ---

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces008.htm

• Question 83:

  During the day, your database must support an OLTP workload that requires a large database buffer cache. At night, it must support batch jobs that require a higher value to be set for large pool.

  What must you do to allow the memory pools to change size automatically as required? (Choose the best answer.)

  A. Enable AMM and set the SGA_TARGET initialization parameter to a nonzero value.
  B. Enable AMM and set the PRE_PAGE_SGA initialization to TRUE.
  C. Enable Automatic Memory Management (AMM) and set the PGA_TARGET initialization parameter to a nonzero value.
  D. Enable AMM and set the PGA_TARGET initialization parameter to a nonzero value.
  B. Enable AMM and set the PRE_PAGE_SGA initialization to TRUE.

• Question 84:

  You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.

  What is the outcome?

  A. The PDB is closed.
  B. The PDB is placed in mount state.
  C. The command executes only if the common user is granted the set container privilege for the PDB.
  D. The command results in an error because the PDB can be shut down only by a local user.
  B. The PDB is placed in mount state.

  ---

  The PDB is placed in mount state. SQL> shutdown immediate; Pluggable Database closed. SQL> select status from v$instance; STATUS -------- MOUNTED SQL> There is no closed Status in a PDB. PDB can have Mount/Read Write/ Read Only.

• Question 85:

  You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.

  How can you detect the cause of the degraded performance?

  A. Enable Memory Access Mode, which reads performance data from SGA.
  B. Use emergency monitoring to fetch data directly from SGA for analysis.
  C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
  D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
  E. Run ADDM in diagnostic mode.
  B. Use emergency monitoring to fetch data directly from SGA for analysis.

  ---

  Reference: https://oracle-base.com/articles/12c/emergency-monitoring-em12c

• Question 86:

  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.
  B. The statistics_level parameter is set to all only for PDB2 when it is reopened.

  ---

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

  Which two statements are true about RMAN duplexed backups? (Choose two.)

  A. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.
  B. It is only supported for backups to tape via media management interface.
  C. It is not supported for image copies.
  D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.
  E. Duplex backups can contain only data files and control files.
  C. It is not supported for image copies.
  D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

  ---

  Reference: https://docs.oracle.com/cd/E15586_01/backup.1111/e10642/rcmbckad.htm

• Question 88:

  A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call. Which table organization allows for generating the bills with minimum degree of row sorting?

  A. a hash cluster
  B. an index cluster
  C. a partitioned table
  D. a sorted hash cluster
  E. a heap table with a rowid column
  D. a sorted hash cluster

  ---

  The table is not static, but instead is continually growing. If a table grows without limit, the space required over the life of the table (its cluster) cannot be predetermined.

• Question 89:

  You administer a database that was created using Oracle Database 10g.

  The default tablespace type property was not changed. You execute this statement to create a tablespace, mytbs: CREATE TABLESPACE mytbs DATAFILE `/u1/data/mytbs.dbf' SIZE 100M;

  Which two statements are correct regarding the mytbs tablespace? (Choose two.)

  A. It is a bigfile tablespace
  B. It is a locally managed tablespace with uniform size of 8m
  C. It is a locally managed tablespace with autoallocate
  D. It is a dictionary-managed tablespace
  E. It is a smallfile tablespace
  C. It is a locally managed tablespace with autoallocate
  E. It is a smallfile tablespace

• Question 90:

  You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements:

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;

  For which database users is the audit policy now active?

  A. all users except sys
  B. all users except scott
  C. all users except sys and scott
  D. all users except sys, system, and scott
  B. all users except scott