Oracle Database: Managing Multitenant Architecture Ed 1 Quiz Questions and Answers
Explanation :
<p>The INSERT statement is used to add one or more rows to a table</p>
Answer :
- Log switches occur only at the container database level.
- A PDB can have a private temporary tablespace.
Explanation :
Database and Backup
Answer :
- It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.
Explanation :
False
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
Answer :
- Set pga_aggregate_target to a nonzero value
Explanation :
False
Answer :
- It is set to TRUE for the root database and the pluggable database PDB2, because values can be set for this parameter at the PDB level in a PDB.
Explanation :
False
Answer :
- Local roles can be granted to local and common users
Explanation :
False
Answer :
- The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.
Explanation :
False
