nerdexam
Oracle

1Z0-909 · Question #30

Which two are true about MySQL connectors?

The correct answer is A. Connectors must be installed on both the client and server hosts. B. Connector/J is based on Connector/C. There's an issue with the stated correct answers here. Based on MySQL documentation, A and B are actually false statements, not true ones. The correct answers to this question should be C and E. Here's the accurate breakdown: Why C is true: Connector/ODBC (MyODBC) is explicitly…

Application Development

Question

Which two are true about MySQL connectors?

Options

  • AConnectors must be installed on both the client and server hosts.
  • BConnector/J is based on Connector/C.
  • CConnector/ODBC is available on Unix, Windows, and MacOS X.
  • DConnector/NET runs on the Windows platform only.
  • EConnector/Python is released in precompiled binary and source code.

How the community answered

(16 responses)
  • A
    94% (15)
  • E
    6% (1)

Explanation

There's an issue with the stated correct answers here. Based on MySQL documentation, A and B are actually false statements, not true ones. The correct answers to this question should be C and E.

Here's the accurate breakdown:

Why C is true: Connector/ODBC (MyODBC) is explicitly cross-platform - it runs on Unix/Linux, Windows, and macOS X.

Why E is true: Connector/Python is distributed in both precompiled binary packages and source code, giving developers flexibility in how they install it.

Why A is false: MySQL connectors are client-side components only. You install a connector on the application/client host to communicate with the MySQL server - the server itself does not require a connector.

Why B is false: Connector/J is a pure Java (JDBC Type 4) driver, meaning it's written entirely in Java with no native dependencies. It is not based on Connector/C.

Why D is false: While Connector/NET was historically Windows-focused, it is not Windows-only - it also supports cross-platform deployment via .NET Core/Mono.

Memory tip: Think "C and E" as Cross-platform and Everywhere - ODBC runs everywhere (Unix/Windows/Mac), and Python is available everywhere (binary and source).

I'd recommend double-checking the source of this question - the marked answer (A, B) appears to be incorrect based on MySQL documentation.

Topics

#MySQL Connectors#Connector Architecture#Client-Server Installation#Connector Types

Community Discussion

No community discussion yet for this question.

Full 1Z0-909 Practice