← Back to exam page

1z0-067 – Upgrade Oracle9i/10g/11g OCA OR OCP to Oracle Database 12c OCP

Loading demo links...

Showing 4–6 of 15 questions

Question 4

Examine the command and its output:

SQL> DROP TABLE EMPLOYEE;

SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin;

RECYCLE_NAMEORIGINAL_NAMETYPE

--------------------------------------------------------------------------------------------------------------

binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE You then successfully execute the command:

SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP; Which two statements are true?

Select all that apply, then click Submit answer.

  • ○

    It flashes back the employee table and all the constraints associated with the table.
  • ○

    It automatically flashes back all the indexes on the employes table.
  • ○

    It automatically flashes back any triggers defined on the table.
  • ○

    It flashes back only the structure of the table and not the data.
  • ○

    It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.
Question 5

Users report this error message when inserting rows into the orders table:

ERROR atline1:

ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES

You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.

Which two must you do to fix this problem without affecting currently executing queries?

Select all that apply, then click Submit answer.

  • ○

    drop and re-create the index
  • ○

    coalesce the orders„ind index
  • ○

    coalesce the indexes tablespace
  • ○

    perform an on line table rebuild using dbns_redefir.ition.
  • ○

    rebuild the index online moving it to another tablespace that has enough free space for the index
Question 6

Which three statements are true about Consolidated Database Replay?

Select all that apply, then click Submit answer.

  • ○

    The workload capture and replay systems must have the same operating system (OS).
  • ○

    Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
  • ○

    A subset of the captured workload can be replayed.
  • ○

    The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
  • ○

    Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.