Free 1z0-497 – Oracle Database 12c Essentials Practice Test Question

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.
  

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.
  

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.
  

Select all that apply, then click Submit answer.

• ○

  Multiple transactions can use the same undo segment.

• ○

  A transaction is assigned an undo segment when it is started.

• ○

  Multiple transactions cannot share the same extent in an undo tablespace.

• ○

  If all the segments in an undo tablespace are used, transactions use system undo segments to store undo data.
  

Select all that apply, then click Submit answer.

• ○

  The database advances a checkpoint.

• ○

  A client process commits a transaction.

• ○

  The redo log buffer becomes full.

• ○

  A server process cannot find non-dirty blocks after scanning a threshold number of buffers.

• ○

  A tablespace is changed to read-only status.

• ○

  The database is shut down in immediate mode.
  

Select an option, then click Submit answer.

• ○

  books

• ○

  pxx

• ○

  MAXVALUE

• ○

  cell_id

• ○

  There is no partitioning criteria.
  

Select an option, then click Submit answer.

• ○

  It enables the Oracle Data Mining option in your Oracle binary files.

• ○

  It creates the Fast Recovery Area disk group.

• ○

  It generates Client Static Library.

• ○

  It configures one of the Oracle user accounts.

• ○

  It configures Oracle Net Services.

• ○

  It configures Oracle Messaging Gateway.
  

Select an option, then click Submit answer.

• ○

  db_name

• ○

  maxdatafiles

• ○

  control_files

• ○

  instance_name
  

Select an option, then click Submit answer.

• ○

  You should not install the Oracle Database software into an existing Oracle home from a different release.

• ○

  A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.

• ○

  Oracle recommends that you back up the root. sh script after you complete the installation.

• ○

  Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.

• ○

  You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.
  

Select an option, then click Submit answer.

• ○

  Tablespace< Segment < Extent < Oracle Datablock

• ○

  B) Segment < Extent < Oracle Datablock<>

• ○

  Tablespace< Extent < Segment < Oracle Datablock

• ○

  Data File