In the office table, the city column is structured as shown:Mysql> show columns from office like city\G---------------------------------------------------1. row ---------------------__________________Field: city -Type: enum(paris.Amsterdam.New York.Tokyo)Null: Yes -Key:Default:NULL -Extra:Consider the output of the SELECT query executed on the office table:Mysql> SELECT DISTINCT city FROM office ORDER BY city:If the query is written as:SELECT DISTINCT city FROM office ORDER BY CAST(city AS CHAR)In what order are the rows returned?
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?
Your application is running slow.Which two features provide information that help to identify problems?
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.
You have two test tables:✑ Code_innodb as InnoDB engine✑ Code_ myisam as MYISAM engineThe 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, Beta), (3, charlie,),(4, Delta);ERROR 1062 (23000): Duplicate entry 3 for key PRIMARYMysql> INSERT INTO code_myisam VALUES (1, Alpha), (2, Beta), (3, charlie),(4, Delta);ERROR 1062 (23000); Duplicate entry 3 for key PRIMARYWhat is the expected output of the SELECT statements?
The application logs contain many entries of the following:ERROR 1153 (OSSO1): Got a packet bigger than max_allowed_packet bytesWith two scenarios can (Hibernate this error message?
