In addition to identifying database inconsistencies, what are other advantages of running the Integrity Checker? (Choose Two)

Question

Options

• AIt helps in identifying unused indexes.
• BIt aids in verifying the application server configuration.
• CIt can pinpoint missing relationships in the database.
• DIt assists in detecting incorrect application setups.

• A
  18% (7)
• B
  10% (4)
• C
  72% (28)

Explanation

Running the Integrity Checker does more than surface database inconsistencies - C is correct because it actively scans for missing relationships between database tables (e.g., orphaned records or broken foreign-key references that could cause data integrity failures). D is correct because it also flags incorrect application configurations, such as misconfigured settings or broken references within the application layer, helping administrators proactively resolve setup issues before they cause runtime errors.

A is wrong because identifying unused indexes is a database performance/optimization task, typically handled by query analyzers or DBA tools - not an integrity checker. B is wrong because verifying application server configuration (CPU, memory, network, middleware) falls under infrastructure/server administration tools, outside the scope of an integrity checker's purpose.

Memory tip: Think of the Integrity Checker as a "relationship and rules auditor" - it cares about connections (missing relationships → C) and correctness (bad setups → D). Anything about performance tuning (indexes → A) or server infrastructure (server config → B) is out of its lane.

No community discussion yet for this question.