Online Access Free 1Z0-182 Practice Test

You start your database instance in NOMOUNT state. Which two actions are performed?

• A.All required background processes are started.
• B.The control files are opened.
• C.The consistency of the database is checked.
• D.Memory is allocated for the SGA.
• E.SYS can access the database.

Which statement regarding PDBs (Pluggable Databases) is correct?

• A.You cannot drop a source PDB of a refreshable PDB.
• B.When the relocation of a PDB is finished, the source PDB must be dropped.
• C.You can drop an application root along with the associated PDBs.
• D.You can drop a PDB as long as it is not the PDB seed.

Which two statements are true about database instances and Real Application Clusters (RAC)?

• A.A RAC database can have one instance.
• B.Two RAC databases can share their instances.
• C.A RAC database can have instances on separate servers.
• D.A RAC database must have two or more instances.
• E.A RAC database must have three or more instances.

How do you validate that the database was migrated to Unified Auditing?

• A.By querying the DBA_UNIFIED_AUDIT_OPTION view.
• B.By executing DBMS_AUDIT_MGMT PL/SQL package in Verify mode.
• C.By querying V$OPTION for parameter Unified Auditing.
• D.By using the LSINVENTORY Command to query the Oracle Database Software Library.

Which three statements are true about resumable space allocation in Oracle databases?

• A.Resumable space allocation may be enabled for some sessions and not others.
• B.The AFTER SUSPEND event trigger can itself be suspended due to space conditions.
• C.A user's session may be suspended and resumed multiple times.
• D.Resumable space allocation is only possible with locally managed tablespaces.
• E.All sessions must have the same timeout value when waiting for resumable space allocations.
• F.A user's session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege.