nerdexam
IBM

C2090-320 · Question #93

Which of the following statement describes the effect of setting the SEPARATE_SECURITY installation parameter to YES?

The correct answer is D. Prevents SYSADM and SYSCTRL from granting or revoking privileges. See the full explanation below for the reasoning.

Question

Which of the following statement describes the effect of setting the SEPARATE_SECURITY installation parameter to YES?

Options

  • APrevents DBADM from starting traces.
  • BAllows statement to be explained without table access privileges.
  • CPrevents SYSADM from accessing data in unauthorized tables.
  • DPrevents SYSADM and SYSCTRL from granting or revoking privileges.

How the community answered

(67 responses)
  • A
    3% (2)
  • B
    13% (9)
  • C
    7% (5)
  • D
    76% (51)

Community Discussion

No community discussion yet for this question.

Full C2090-320 Practice