Oracle Database: Managing Multitenant Architecture Ed 1 Quiz Questions and Answers

You can add a row using SQL in a database with which of the following?

Answer :
  • INSERT

Explanation :

<p>The INSERT statement is used to add one or more rows to a table</p>

Which two statements are true about a multitenant architecture?

Answer :
  • Log switches occur only at the container database level.
  • A PDB can have a private temporary tablespace.

Explanation :

Database and Backup

You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user: SQL > CREATE USER c##scott IDENTIFIED BY scottorcll; SQL > GRANT CREATE SESSION TO c##scott user? Which statement is true about the c##scott user?

Answer :
  • It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.

Explanation :

False

Which two statements are true about unified auditing?

Answer :
  • A unified audit trail captures audit information from unified audit policies and audit settings
  • Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.

Explanation :

False

Which parameter must be set to which value to implement automatic PGA memory management?

Answer :
  • Set pga_aggregate_target to a nonzero value

Explanation :

False

In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN. and then execute the command: Which statement is true?

Answer :
  • The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.

Explanation :

False

Which three statements are true about Consolidated Database Replay?

Answer :
  • 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
  • Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules

Explanation :

False

You create two Resource Manager plans, one for night time workloads, the other for day time. How would you make the plans switch automatically?

Answer :
  • Use scheduler windows

Explanation :

False