> > >

DB2 Administration MCQs

A DBA wishes to audit all access to the non-audited table OWNER.Smartemp. Assuming no audit traces are started, which of the following steps are needed to audit access to this table?

- -START TRACE AUDIT CLASS (4,5) and ALTER TABLE OWNER.Smartemp DATA

- -START TRACE AUDIT CLASS (5)

- -START TRACE AUDIT CLASS (4,5) and ALTER TABLE OWNER.Smartemp AUDIT ALL

- -START TRACE AUDIT CLASS (4,5)

Answer

Correct Answer: - -START TRACE AUDIT CLASS (4,5) and ALTER TABLE OWNER.Smartemp AUDIT ALL

Explanation:

Note: This Question is unanswered, help us to find answer for this one

DB2 Administration Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it