Which three connector/J connection strings can be used to connect to the MYSQL server?

A. Jdbc:mysq1://localhost/test?user =xxxandpassword=xxx

B. Jdbc :mysqli://localhost/test?user=xxxandpassword=xxx

C. Jdbc :mysql:replication://master,slave1.slave2. /test?user=xxxandpassword=xxx

D. Jdbc:mysql:proxy://localhost/test?user=xxxandpassword=xxx

E. Jdbc :mysql:loadbalance://master.slave1,slave2/test?user=xxxandpassword=xxx

In MYSQL 5.6 you have the table t1:

CREATE TABLE t1 (

id int unsigned NOT NULL PRIMARY key) ENGINE = InnoDB;

There are two connections to the server. They execute in this order:

Connection 1> SET TRANSACTION ISOLATION LEVEL REPEATABLE READ; Connection 1> START

TRANSACTION;

Connection 1> SELECT * FROM t1 WHERE id =1;

Connection 2> TRUNCATE TABLE t1;

What happens to the TRUNCATE TABLE command in connection 2?

A. It immediately proceeds and causes an implicit commit of the transaction in connection1.

B. It runs concurrently with the transaction in connection 1 as each connection has its own view of the data in the t1 table.

C. It blocks waiting for a metadata lock until the transaction in connection 1 ends.

D. It blocks waiting for a table lock until the transaction in connection 1 ends.

Your application is running slow.

Which two features provide information that help to identify problems?

A. The MYSQL error log

B. The slow query log

C. The performance schema

D. The GET DIAGNOSTICS statement

Your MYSQL server was successfully running for a days, and then suddenly stopped .You are sure that no

mysqld process is running.

Which two may provide diagnostic information to help determine why the MYSQL server stopped?

A. The general query log file

B. The syslog on Linux/UNIX or the Event view on windows

C. The slow query log file

D. The MYSQL server error log file

E. The binary log file

Given the table City: SELECT Name FROM City WHERE CountryCode = `USA" OR WHERE CountryCode= `JPN'

What does this statement procedure?

A. A single result set with one column that contains the names of cities from country codes USA and JPN.

B. Two result sets each containing a single column with the names of cities from country codes USA and JPN.

C. A single result set with two columns containing the names from country codes USA and JPN.

D. No result set is returned and an error message is given.

What is true about the contents of the INFORMATION_SCHEMATA table?

A. It contains information about the table structure for all databases.

B. It contains information about all the tables, triggers, and views for all databases.

C. It contains information such as name, character set, and collation for all the databases on the server.

D. It contains information including tables, trigger, stored routines, and views for all databases

Consider the statement:

CREATE TABLE t1 (a INT) PARTITION BY KEY

/*150611 ALGORITHM = 1*/

What does this statement do?

A. Create the t1 table partitioned by KEY with the default algorithm in all versions.

B. Create the t1 table partitioned by KEY using algorithm 1 only in MYSQL version 5.6.11 and the default algorithm in other versions.

C. Create the t1 table partitioned by KEY using algorithm 1 only in MYSQL versions 5.6.11 or newer and the default algorithm in older versions.

D. Create the t1 table partitioned by KEY using algorithm 1 only if the preceding statement returned error condition 50611.

You execute this EXPLAIN statement for a SELECT statement on the table named comics.which contains 1183 rows:

Mysql> explain select comic_ title, publisher from comics where comic_title like `and Actionand';

1 row in set (0.00 sec)

You create the following index:

CREATE INDEX cimic_title_idx ON comics (comic_title, publisher); You run the same EXPLAIN statement

again;

Mysql > explain select comic_title ,publisher from comics where comic_title like `and Actionand';

1 row in the second SELECT statement need to read all 1183 rows in the index comic_title_idx?

A. Because comic_title is not the primary key

B. Because a LIKE statement always requires a full tables scan

C. Because comic _title is part of acovering index

D. Because a wildcard character is at the beginning of the search word

You want to use the SHA -256 Authentication plugin with Connector/J. Which two parameter settings achieve this?

A. Authenticationplugins=com.mysql.jdbl.jdbc.authentication.sha256passwordplugin,com.mysql.jd bc

B. Authenticationplugins=com,mysql,authentication,mysqlNativepasswordplugin

C. defaultAuthenticationplugin=com.mysql.jdbc.authentication.sha256passwordplugin

D. defaultAuthenticationplugin=com.mysql.jdbc.authentication.MysqlNativepasswordplugin

You want to compare all columns of table A to columns with matching names in table B. You want to select the rows where those have the same values on both tables. Which query accomplishes this?

A. SELECT * FROM tableA. tableB

B. SELECT * FROM tableA JOIN tableB

C. SELECT * FROM table A INNER JOIN tableB

D. SELECT * FROM tableA NATURAL JOIN tableB

E. SELECT and FROM tableA STRAIGHT JOIN tableB