1Z0-006 Oracle Database Architecture 5

Question 1

What is the purpose of the SYSTEM tablespace in an Oracle database?

Accepted Answer

Holding the data dictionary and core internal Oracle objects

Answer

The SYSTEM tablespace is mandatory and stores the data dictionary, PL/SQL source code, and internal Oracle objects that the database needs to function.

Question 2

In Oracle's memory architecture, which area is shared by all sessions connected to the same instance?

Accepted Answer

SGA (System Global Area)

Answer

The SGA is a shared memory region allocated when the instance starts and is accessible by all background and server processes of that instance.

Question 3

Which Oracle shutdown mode waits for all current transactions to complete before shutting down?

Accepted Answer

SHUTDOWN TRANSACTIONAL

Answer

SHUTDOWN TRANSACTIONAL waits for all active transactions to either commit or roll back before disconnecting sessions and shutting down the database.

Question 4

What is a schema in Oracle database terminology?

Accepted Answer

A collection of database objects owned by a specific user

Answer

A schema is a logical collection of database objects—tables, views, indexes, procedures, etc.—owned by and associated with a particular database user.

Question 5

Which Oracle feature allows a single physical database to be presented as multiple logical databases to different applications?

Accepted Answer

Pluggable Databases (PDB) in Multitenant architecture

Answer

Oracle Multitenant architecture uses a Container Database (CDB) to host multiple Pluggable Databases (PDBs), each appearing as an independent database.

(1Z0-006) Oracle Database Foundations Associate Practice Test

(1Z0-006) Oracle Database Foundations Associate Practice Test

1Z0-006 Oracle Database Architecture 5