1Z0-006 Database Administration & Security 3

Question 1

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

Accepted Answer

SYSTEM

Answer

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

Question 2

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

Accepted Answer

Incremental backup

Answer

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

Question 3

What is the role of the Oracle Listener process?

Accepted Answer

Accepts incoming client connection requests to the database

Answer

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

Question 4

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

Accepted Answer

Quotas

Answer

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

Question 5

What does the Oracle REVOKE statement do?

Accepted Answer

Removes a previously granted privilege from a user or role

Answer

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

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