1Z0-006 Database Administration and Security 2

Question 1

Which Oracle tool is used to create and manage a database interactively with a graphical interface?

Accepted Answer

Database Configuration Assistant (DBCA)

Answer

DBCA (Database Configuration Assistant) provides a GUI for creating, configuring, and deleting Oracle databases.

Question 2

What does the Oracle Data Dictionary store?

Accepted Answer

Metadata about database objects, users, and privileges

Answer

The Oracle Data Dictionary stores metadata such as definitions of tables, views, indexes, users, and privileges.

Question 3

Which privilege allows a user to connect to an Oracle database?

Accepted Answer

CREATE SESSION

Answer

The CREATE SESSION system privilege is required for a user to establish a connection to the Oracle database.

Question 4

What is the purpose of the Oracle Listener process?

Accepted Answer

It handles incoming client network connection requests

Answer

The Oracle Listener is a network process that listens for incoming client connection requests and hands them off to the database server.

Question 5

Which view would a DBA query to see all current active sessions in an Oracle database?

Accepted Answer

V$SESSION

Answer

V$SESSION is a dynamic performance view that shows information about all current sessions connected to the Oracle database.

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