Which privilege allows a user to create tables in their own schema?
Correct!
Wrong!
CREATE TABLE privilege enables schema owners to define new tables.
A backup strategy that captures only data blocks changed since the last backup is called:
Correct!
Wrong!
Incremental backups reduce time and storage by copying only changed blocks.
The process of applying archived redo logs to a standby database to keep it synchronized is known as:
Correct!
Wrong!
Managed recovery applies redo to maintain physical standby consistency.
Which authentication method relies on the operating system to verify database users?
Correct!
Wrong!
OS authentication lets users connect without database passwords when OS credentials match.
The principle of least privilege suggests that users should:
Correct!
Wrong!
Users should receive only the minimum rights necessary to accomplish tasks, reducing risk.
Transparent Data Encryption (TDE) primarily protects data:
Correct!
Wrong!
TDE encrypts data at rest, rendering data files unreadable without the master key.
Loading Questions...
A database alert log records:
Correct!
Wrong!
Critical events, errors, and changes in database operations are written to the alert log.
To revoke a role from a user, which statement is used?
Correct!
Wrong!
REVOKE removes previously granted privileges or roles.
Which automatic feature in Oracle attempts to protect against SQL injection by verifying input types?
Correct!
Wrong!
Oracle Data Redaction and DBMS_ASSERT can validate and sanitize user input.