Database Administration and Security Flashcards

Which Oracle feature allows you to limit the amount of CPU and I/O resources a user or group can consume?

Answer: Database Resource Manager

Oracle Database Resource Manager allows DBAs to define resource plans that control CPU, I/O, and session limits for different user groups.

What is the function of Oracle's AUDIT statement?

Answer: It tracks and records user actions and database events for security monitoring

The AUDIT statement in Oracle enables tracking of specified user actions, SQL statements, or system events and writes records to the audit trail.

In Oracle, what does the REVOKE statement do?

Answer: Removes previously granted privileges from a user or role

REVOKE removes specific privileges or roles that were previously granted to a user or another role.

Which tablespace type is used to store temporary data such as sort operations?

Answer: TEMP tablespace

The TEMP (temporary) tablespace stores temporary data used during sort, hash join, and other operations that require disk space beyond available memory.

What is the minimum number of redo log file groups required for an Oracle database to function?

Answer: 2

Oracle requires at least 2 redo log groups so that while one group is being archived or checkpointed, the other can be written to.

Which Oracle background process writes dirty buffers from the buffer cache to data files?

Answer: DBWR (Database Writer)

DBWR (Database Writer) is responsible for writing modified (dirty) data blocks from the buffer cache to the corresponding data files on disk.

What does the Oracle FLASHBACK TABLE feature enable?

Answer: Restoring a table to a previous point in time without restoring the entire database

FLASHBACK TABLE allows you to restore a table to a prior point in time by leveraging undo data, without requiring a full database restore.