SELECT Name, Population FROM country WHERE Name LIKE 'United%' LIMIT 5;

Which two statements provide equivalent results using the X DevAPI protocol?

shell> mysqlsh --host=localhost --user=root -p

Now, examine this command:

localhost:33060 JS> session
What is the result?

CREATE TABLE t(id INT PRIMARY KEY);

INSERT INTO t(id) VALUES(1);
Now, examine these statements executed successfully by two concurrent sessions:

Session 1> SET autocommit=0;

Session 1> UPDATE t SET id=id+1;

Session 2> SET transaction_isolation="READ-UNCOMMITTED";

Session 2> BEGIN;

Session 2> UPDATE t SET id=id+1;

Session 1> ROLLBACK;

Session 2> COMMIT;

Which two will do this?

CREATE TABLE `appointments` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `attendant_id` int(11) NOT NULL,

  `attendant_session_id` int(11) NOT NULL,

  `start` datetime NOT NULL,

  `end` datetime NOT NULL,

  `date` date NOT NULL,

  `created_by` varchar(20) NOT NULL,

  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,

  `payment` int(11) NOT NULL DEFAULT '0',

  `credit` int(11) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Now, examine this statement which executes successfully:

SELECT attendant_id,

       payment,

       credit

FROM appointments

WHERE attendant_session_id = 510

  AND created_by = 'jsmith';

Which statement will improve query performance?

The server is only accessible from your private network and all name resolution is provided by a private DNS service.

Which two statements are true?

A legacy application yet to be migrated, does not support the default authentication plugin.

Examine this statement which executed successfully:

CREATE USER `app`@localhost IDENTIFIED BY 'password';

Which would allow the legacy application to connect while enabling other applications to adhere to the requirements?

It has more than 1 million rows.

It has a date_of_birth column defined with the DATETIME data type.

The date_of_birth column is indexed.

Which is the most efficient WHERE clause that returns all customers born in the year 2000?

Which connector will do this?

mysql> SET GLOBAL sql_mode = ANSI_QUOTES;
Which sessions utilize the ANSI_QUOTES SQL mode?