Database Administration and Security Flashcards

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

Answer: Database Configuration Assistant (DBCA)

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

What does the Oracle Data Dictionary store?

Answer: Metadata about database objects, users, and privileges

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

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

Answer: CREATE SESSION

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

What is the purpose of the Oracle Listener process?

Answer: It handles incoming client network connection requests

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

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

Answer: V$SESSION

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

What happens to uncommitted transactions when an Oracle database instance crashes?

Answer: They are rolled back during instance recovery using undo data

During instance recovery, Oracle uses undo data to roll back any uncommitted transactions that were in progress at the time of the crash.

Which statement best describes a database schema in Oracle?

Answer: A collection of database objects owned by a specific user

In Oracle, a schema is a logical collection of database objects (tables, views, sequences, etc.) owned by a particular database user.