1Z0-006 Security Management 5

Question 1

Which statement correctly describes the difference between system privileges and object privileges in Oracle?

Accepted Answer

System privileges allow actions on any object of a type; object privileges apply to a specific object

Answer

System privileges (e.g., CREATE TABLE) allow performing an action on any applicable object, while object privileges (e.g., SELECT on HR.EMPLOYEES) apply only to a named object.

Question 2

Which Oracle view shows object privileges granted on objects owned by the current user?

Accepted Answer

USER_TAB_PRIVS_MADE

Answer

USER_TAB_PRIVS_MADE lists all grants the current user has made on their own objects, showing the grantee and the privilege granted.

Question 3

What is a 'secure application role' in Oracle Database?

Accepted Answer

A role that can only be enabled through a PL/SQL procedure that verifies context conditions

Answer

A secure application role can only be activated by calling a specific PL/SQL procedure, which can verify application context, IP address, or other conditions before enabling the role.

Question 4

Which password profile parameter prevents a user from reusing a password within a specified number of days?

Accepted Answer

PASSWORD_REUSE_TIME

Answer

PASSWORD_REUSE_TIME specifies the number of days a user must wait before they can reuse a previously used password.

Question 5

Fine-Grained Auditing (FGA) in Oracle differs from standard auditing primarily because it:

Accepted Answer

Can trigger auditing based on specific column values accessed in a query

Answer

FGA allows policies that fire only when specific columns are referenced in a query or when the data returned matches defined conditions, providing much more precise auditing than standard auditing.

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

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

1Z0-006 Security Management 5