nerdexam
Oracle

1Z0-116 · Question #36

Which two statements are true about running the Oracle Database Security Assessment Tool (DBSAT) Collector?

The correct answer is C. It must be run by an OS user with read permissions on files and directories under D. It runs only on Windows systems. Note: There appears to be an error in the provided answer key. Based on Oracle documentation, the correct answers should be C and E, not C and D. Here's the explanation: Why C and E are correct: (C) The DBSAT Collector runs as an OS-level process and must be executed by an OS…

Introduction to Database Security

Question

Which two statements are true about running the Oracle Database Security Assessment Tool (DBSAT) Collector?

Options

  • AIt runs only on UNIX/Linux systems.
  • BIt must connect to the database using a SYSDBA connection.
  • CIt must be run by an OS user with read permissions on files and directories under
  • DIt runs only on Windows systems.
  • EIt must be run on the server that contains the database.

How the community answered

(50 responses)
  • A
    6% (3)
  • B
    2% (1)
  • C
    90% (45)
  • E
    2% (1)

Explanation

Note: There appears to be an error in the provided answer key. Based on Oracle documentation, the correct answers should be C and E, not C and D. Here's the explanation:

Why C and E are correct:

  • (C) The DBSAT Collector runs as an OS-level process and must be executed by an OS user with read permissions on Oracle files and directories (e.g., $ORACLE_HOME, $ORACLE_BASE) to collect configuration data from the file system.
  • (E) The Collector component must run directly on the database server - it collects OS-level files, listener configs, and local settings that are not accessible remotely.

Why the distractors are wrong:

  • (A) DBSAT runs on both UNIX/Linux and Windows - not exclusively UNIX/Linux.
  • (B) DBSAT Collector does not require SYSDBA; it uses a dedicated user granted specific, limited privileges (e.g., SELECT_CATALOG_ROLE).
  • (D) DBSAT is not Windows-only; it is cross-platform. This is likely the source of the answer key error.

Memory tip: Think "Local Read Access" - the Collector needs to be physically on the server (local) and needs OS read access (read) to gather its data. Everything else (remote connections, SYSDBA, single-OS) is a distractor designed to confuse with other Oracle tool requirements.

Recommend verifying this question against your official study materials, as the answer key listing D appears to be a typo for E.

Topics

#DBSAT#Security Assessment Tool#Tool Requirements#Database Audit

Community Discussion

No community discussion yet for this question.

Full 1Z0-116 Practice