A DBA is documenting a hybrid environment for the network team. It includes a MySQL server and an Oracle Database server, both installed with default network settings. Which default TCP ports should the documentation list for the MySQL server and the Oracle listener?
Select an answer to reveal the explanation.
Short Explanation
Here's a memory hook for you: MySQL lives at 3306 and the Oracle listener answers at 1521. The distractors play musical chairs with 1433 and 5432, which belong to SQL Server and PostgreSQL. Get the four classic defaults straight and these items become free points.
Full Explanation
MySQL listens on TCP 3306 by default, and the Oracle Database listener, the process that accepts incoming client connection requests and hands them to the database, listens on TCP 1521 by default. Documentation for a default installation should therefore record 3306 and 1521, with a note that both are configurable and should be confirmed against the actual listener settings. Listing 1433 for the Oracle listener substitutes the default for a Microsoft SQL Server default instance; an Oracle listener does not answer on that port unless an administrator configures it to, so firewall rules built from that documentation would block Oracle clients. Listing 5432 for MySQL substitutes the PostgreSQL default; a default MySQL server is not listening there, so connections and rules based on it would fail. Swapping the values so that MySQL is 1521 and Oracle is 3306 reverses the correct pair and breaks both entries. Exam caveat: these are vendor defaults, not protocol requirements, and hardened environments often change them; questions that ask for defaults assume no customization, while questions about security will not accept a nonstandard port as a control on its own. Operational check: verify each listener's port in its configuration or with a socket listing on the host, record it in the network documentation, and confirm the firewall permits only the required source addresses.