Database Administration & Security Flashcards

What is the default tablespace for a new Oracle user if none is specified at creation?

Answer: SYSTEM

If no default tablespace is specified when creating a user, Oracle assigns the SYSTEM tablespace as the default, which is generally undesirable.

Which type of Oracle backup captures only the data blocks changed since the last backup?

Answer: Incremental backup

An incremental backup copies only the data blocks that have changed since the previous backup, reducing backup time and storage.

What is the role of the Oracle Listener process?

Answer: Accepts incoming client connection requests to the database

The Oracle Listener is a network process that listens on a port and routes incoming client connection requests to the appropriate database instance.

Which Oracle feature allows you to limit the amount of disk space a user can consume in a tablespace?

Answer: Quotas

Tablespace quotas restrict how much space a user's objects can consume within a specific tablespace.

What does the Oracle REVOKE statement do?

Answer: Removes a previously granted privilege from a user or role

REVOKE removes system or object privileges that were previously granted to a user, role, or PUBLIC.

Which initialization parameter controls the maximum number of user sessions that can connect to an Oracle instance simultaneously?

Answer: SESSIONS

The SESSIONS initialization parameter sets the maximum number of concurrent sessions allowed in an Oracle instance.

In Oracle, what is a 'profile' used for?

Answer: Enforcing password and resource usage policies on user accounts

A profile is a named set of password and resource limit parameters that can be assigned to user accounts to enforce security and usage policies.