1z0-062

1z0-062 practice questions, page 7 of 16, with answer review and explanations.

Question 31

Which two are true concerning a multitenant container database with three pluggable database? (Choose two.)

  1. All administration tasks must be done to a specific pluggable database.
  2. The pluggable databases increase patching time.
  3. The pluggable databases reduce administration effort.
  4. The pluggable databases are patched together.
  5. Pluggable databases are only used for database consolidation.

Question 32

Examine the current value for the following parameters in your database instance: SGA_MAX_SIZE = 1024M - SGA_TARGET = 700M - DB_8K_CACHE_SIZE = 124M - LOG_BUFFER = 200M - You issue the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; Which statement is true?

  1. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
  2. It succeeds only if memory is available from the autotuned components if SGA.
  3. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
  4. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Question 33

Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)

  1. The PDB must be open in read only mode.
  2. The PDB must be dosed.
  3. The unplugged PDB becomes a non-CDB.
  4. The unplugged PDB can be plugged into the same multitenant container database (CDB)
  5. The unplugged PDB can be plugged into another CDB.
  6. The PDB data files are automatically removed from disk.

Question 34

Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table? (Choose three.)

  1. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
  2. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
  3. Referential integrity constraint cannot be set on the invisible column.
  4. The invisible column cannot be made visible and can only be marked as unused.
  5. A primary key constraint can be added on the invisible column.

Question 35

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?

  1. All users except SYS
  2. All users except SCOTT
  3. All users except sys and SCOTT
  4. All users except sys, system, and SCOTT