← Back to exam page

1z0-060 – Upgrade to Oracle Database 12c

Loading demo links...

Showing 1–3 of 15 questions

Question 1

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).

Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

Select all that apply, then click Submit answer.

  • ○

    Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
  • ○

    Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
  • ○

    Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
  • ○

    Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
  • ○

    Re-create the password file in the Oracle Database 12c format.
Question 2

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

Select all that apply, then click Submit answer.

  • ○

    ALTER TABLE SPLIT PARTITION
  • ○

    ALTER TABLE MERGE PARTITION
  • ○

    ALTER TABLE TRUNCATE PARTITION
  • ○

    ALTER TABLE ADD PARTITION
  • ○

    ALTER TABLE DROP PARTITION
  • ○

    ALTER TABLE MOVE PARTITION
Question 3

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute this command in the root container:

Which two statements are true? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Schema objects owned by the C##A_ADMIN common user can be shared across all PDBs.
  • ○

    The C##A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
  • ○

    The command will create a common user whose description is contained in the root and each PDB.
  • ○

    The schema for the common user C##A_ADMIN can be different in each container.
  • ○

    The command will create a user in the root container only because the CONTAINER clause is not used.