Examine the statement which executes successfully:
SET sql_mode=' NO_ENGINE_SUBSTITTJTION' ;
You try to create a table with a storage engine that is not available. What will happen?

• A. The server will create the table but it will be unusable until the specified storage engine is available.
• B. An error occurs and the create table statement fails.
• C. The server will create the table but report an error when the first attempt to insert a row is performed.
• D. The server will create the table using the default storage engine.

Examine these statements which execute successfully:

The statements executed without exception. Which two are true?

• A. Two transactions commit.
• B. One row is inserted into band.
• C. The transaction is rolled back to the savepoint.
• D. No transaction commits.
• E. No row is inserted into band.

Examine these statements:
SET collation_connection=utf8mb4_0900_as_cs;
SELECT STRCMPCAlice', UCASE ('Alice* )) ;
What is displayed?

• A. ERROR: 1267 (HYOOO): Illegal mix of collations
• B. 0
• C. NULL
• D. 1
• E. -1

Which two differences exist between the timestamp and date time data types?

• A. timestamp has larger range of values.
• B. timestamp stores the interval between two dates.
• C. timestamp uses less storage space.
• D. timestamp stores more decimal points in seconds
• E. timestamp converts the value based on the session time zone.

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