← Back to exam page

1z0-497 – Oracle Database 12c Essentials

Loading demo links...

Showing 1–3 of 10 questions

Question 1

Which three statements are true about a database instance that has mounted a database but has not opened it?

Select all that apply, then click Submit answer.

  • ○

    System administrators and users with the CREATE SESSION system privilege may connect to the instance.
  • ○

    Data files are open in read-only mode.
  • ○

    A control file is open.
  • ○

    System Global Area (SGA) is allocated and background processes are started.
  • ○

    An alert log and trace files are open.
  • ○

    Instance recovery is performed for the database.
Question 2

Which two statements about Global Data Services (GDS) are correct?

Select all that apply, then click Submit answer.

  • ○

    GDS allows scaling replication-aware application workloads beyond the cluster (that is, across replicated clusters).
  • ○

    GDS helps in performing data replication.
  • ○

    GDS works seamlessly with any combination of Oracle RAC databases, single-instance databases, Oracle Data Guard, Oracle Active Data Guard, and Oracle Golden Gate.
  • ○

    GDS helps to perform database failovers, and does not require Data Guard Broker.
  • ○

    The GDSMGRL utility is a command-line interface for configuring and managing the Global Data Services framework.
Question 3

Which two statements are true when you execute an invoker's rights procedure?

Select all that apply, then click Submit answer.

  • ○

    The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege.
  • ○

    Invoking users can control who can access their privileges when they run an invoker's rights procedure.
  • ○

    The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure.
  • ○

    The calling user must grant the INHERIT PRIVILEGES object privilege on the user owner of the procedure.