You must reclaim memory used by a prepared statement named prep. Which two achieve this?

• A. SET @a = ''; EXECUTE prep USING @a;
• B. DROP PREPARE prep;
• C. PREPARE prep FROM '';
• D. DEALLOCATE PREPARE prep?
• E. DROP PROCEDURE prep;
• F. SET @prep = NULL;

Which two are true about MySQL connectors?

• A. Connector/ODBC is available on Unix, Windows, and MacOS X.
• B. Connector/Python is released in precompiled binary and source code.
• C. Connector/J is based on Connector/C.
• D. Connector/NET runs on the Windows platform only.
• E. Connectors must be installed on both the client and server hosts.

Examine this bar graph based on columns from the players table:

Which two statements would generate this bar graph?

• A. SELECT Name, Gender, Sport, LENGTH (GPA*10, '# ') AS GPA_Graph FROM players ORDER BY GPA DESC;
• B. SELECT Name, Gender, Sport, CHAR_LENGTH ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
• C. SELECT Name, Gender, Sport, CONCAT ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
• D. SELECT Name, Gender, Sport, REPEAT('# 'Y GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
• E. SELECT Name, Gender, Sport, RPAD ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

A server hosts MySQL Server and Apache Webserver supporting a PHP/PDO based application.
The application must be migrated from PHP to their Java application server on another host. The MySQL instance remains on the original host.
Examine the PDO connection string used in the existing application:
Mysql:host-localhost;dbname=sales;unix_socket=/var/run/mysql.sock
Which two prevent Java from using the Unix socket?

• A. The X Dev API protocol must be enabled to use sockets in Connector/J driver.
• B. The socket is not implemented in Connector/J driver.
• C. The socket can only be accessed from the local host.
• D. socket is a reserved word in Java.
• E. Java treats the socket file as insecure.