You Issue this statement as user SYS: audit, context namespace kilimanjaro attributes a, b; Which is true?

The correct answer is C. The statement will only audit sys. When the AUDIT CONTEXT NAMESPACE ... ATTRIBUTES ... statement is issued without a BY clause, Oracle defaults to auditing only the user who issued the statement - in this case, SYS. This is a key Oracle auditing behavior: the absence of a BY user or BY ALL clause does not mean…

Managing Database Auditing

Question

You Issue this statement as user SYS:

audit, context namespace kilimanjaro attributes a, b; Which is true?

Options

AThe statement will audit all users.
BThe statement will not audit any users.
CThe statement will only audit sys.
DThe statement must be updated to specify which users to audit.

How the community answered

(23 responses)

A
4% (1)
B
9% (2)
C
87% (20)

Explanation

When the AUDIT CONTEXT NAMESPACE ... ATTRIBUTES ... statement is issued without a BY clause, Oracle defaults to auditing only the user who issued the statement - in this case, SYS. This is a key Oracle auditing behavior: the absence of a BY user or BY ALL clause does not mean "audit everyone," it means "audit only me."

Why the distractors are wrong:

A is wrong because auditing all users requires explicitly adding BY ALL to the statement.
B is wrong because the statement is valid and does produce auditing - just scoped to SYS alone.
D is wrong because the statement requires no correction; it executes successfully as written, it simply has a narrower scope than some might expect.

Memory tip: Think of it as the issuer's default rule - if you don't say who to audit, Oracle assumes you only mean yourself. On the exam, any audit statement missing a BY clause issued by SYS = SYS-only auditing.

Topics

#AUDIT statement syntax#default audit scope#SYS user privileges#audit context attributes

Community Discussion

No community discussion yet for this question.

Full 1Z0-116 Practice