Cormcctor/Net supports a decoupled database connection mode, where a database Connection is established only when needed. ‘ Choose the three parts that are involved when working with decoupled data. A. OpenConnect.MySql, DataTTiread.MySql, CommandExecutor.MySql B. MySqlQueryBuIld, MySqlQuerytxer. MySq I Query Results…

You have two test tables: The tables have the same structure: The tables have one row of data: You execute an INSERT statement on both code_myisam tables and receive duplicate key errors: mysql> INSERT INTO code_innodb VALUES (1, ‘Alpha’), (2,…

You have a transaction that queries a table at the beginning of the transaction and performs the same query later. Which two transaction isolation levels guarantee that you get the same results both times? A. Repeatable read B. Read committed…

Which three database objects have non-case-sensitive names on all operating system? A. Table B. Column C. Index D. Stored procedure E. Trigger

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

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…

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.jdbc B. Authenticationplugins=com,mysql,authentication,mysqlNativepasswordplugin C. defaultAuthenticationplugin=com.mysql.jdbc.authentication.sha256passwordplugin D. defaultAuthenticationplugin=com.mysql.jdbc.authentication.MysqlNativepasswordplugin

Examine this table that contains over two million rows of data: CREATE TABLE ‘news_feed’ ( .id’bigint (20) NOT NULL AUTO _INCREMENT, .news _sources_id’varchar (11) NOT NULL, .dataline’ datetime NOT NULL, .headline’ varchar (256) NOT NULL, .story’ text NOT NULL,.tag varchar…

You have created your connector/Net object to connect to MySQL. What are three valid database operations you can call? A. ExecuteReader, ExecuteNonQuery, ExecuteScalar B. PreformReadonly, performNonQuery,perforIndexRead C. Query, Execute.MySql, Read. Execute. MySQl, Execute,Mysql D. Insert Mysql, UpdateMysql,DeleteMysql E. Query .Apply…

You are connected to a MySQL server and using a prepared statement. You accidentally exit your session. What will happen if you log back in to use your prepared statement? A. The statementexists, butwill need to be deallocated and re-created.…