Oracle Database 12c: Installation and Administration — Question 123

SALES is a valid TNS entry referring to:

Hostname: HOST01 -

Port: 1521 -

Service_name: SALES_SRV -
You issue this command:
$ tnsping SALES
Which two are true? (Choose two.)

Answer options

• A. It validates that there is a listener on HOST01 port 1521.
• B. It validates that SALES is a valid TNSNAMES entry reachable by the configured name resolution method.
• C. It validates that SALES_SRV service is active in any database instance on HOST01.
• D. It validates that a SALES_SRV database on HOST01 is open.
• E. It validates that SALES_SRV service is active in a specific database instance on HOST01.

Correct answer: A, D

Explanation

Answer A is correct because tnsping checks for a listener on the specified host and port. Answer D is also correct since it verifies that the SALES_SRV database is open. Answers B, C, and E are incorrect as they do not accurately describe the functionality of the tnsping command, which focuses on listener availability and database accessibility.