MySQL>Create table t1(id int primary key,name varchar(10)) 

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

MySQL>insert into t1 values(1,’中国’);

 请问select length(name) from t1 where id=1 语句返回结果是（）【单选】？

mysql> show variables like '%coll%';

+-------------------------------+--------------------+

| Variable_name                 | Value              |

+-------------------------------+--------------------+

| collation_connection          | utf8mb4_0900_ai_ci |

| collation_database            | utf8mb4_bin        |

| collation_server              | utf8mb4_bin        |

| default_collation_for_utf8mb4 | utf8mb4_0900_ai_ci |

+-------------------------------+--------------------+

   SQL 语句SELECT ‘A’=’a’ 执行结果是（）【单选】？

mysql> show variables like '%coll%';

+-------------------------------+--------------------+

| Variable_name                 | Value              |

+-------------------------------+--------------------+

| collation_connection          | utf8mb4_0900_ai_ci |

| collation_database            | utf8mb4_bin        |

| collation_server              | utf8mb4_bin        |

| default_collation_for_utf8mb4 | utf8mb4_0900_ai_ci |

+-------------------------------+--------------------+

Mysql>set collation_connection=utf8mb4_bin;

   SQL 语句SELECT ‘A’=’a’ 执行结果是（）【单选】？

MySQL>create table unit(id int unsigned primary key);

mysql> show variables like 'sql_mode';

+---------------+---------------------+

| Variable_name | Value               |

+---------------+---------------------+

| sql_mode      | STRICT_TRANS_TABLES |

+---------------+---------------------+

执行该insert into unit values(-1)语句的结果是（）【单选】？

Insert into t1(1,’abcd’),(2,’ac’),(3,’a’);

mysql> show create table t1\G;

*************************** 1. row ***************************

       Table: t1

Create Table: CREATE TABLE `t1` (

  `id` int NOT NULL,

  `testkey` int DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin；

Mysql>select * from t1;

+----+---------+

| id | testkey |

+----+---------+

|  1 |       1 |

|  2 |       2 |

|  3 |       3 |

|  4 |       4 |

该SQL 语句select testkey from t1 where id=1 for update 加锁的情况是（）【单选】？

mysql> show create table t1\G;

*************************** 1. row ***************************

       Table: t1

Create Table: CREATE TABLE `t1` (

  `id` int NOT NULL,

  `testkey` int DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin；

Mysql>select * from t1;

+----+---------+

| id | testkey |

+----+---------+

|  1 |       1 |

|  2 |       2 |

|  5 |       5 |

|  8 |       8 |

该SQL 语句select testkey from t1 where id=6 for update 加锁的情况是（）【单选】？

MySQL>use cmb;

Mysql>delimiter //

CREATE DEFINER=`admin`@`%` PROCEDURE `myproc`()

begin

select * from cmb.t1;

end

//

请问如何为user01@’%’ 这个新创建的用户授权才可以使得该用户可以调用该存储过程（）【单选】？

mysql> show create table t1\G;

*************************** 1. row ***************************

       Table: t1

Create Table: CREATE TABLE `t1` (

  `id` int NOT NULL,

  `testkey` int DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin；

Mysql>select * from t1;

+----+---------+

| id | testkey |

+----+---------+

|  1 |       1 |

|  2 |       2 |

|  3 |       4 |

|  5 |       5 |

|  8 |       8 |

该SQL 语句select * from t1 where testkey =4 for update 加锁的情况是（）【单选】？

mysqlbackup --user=mysqlbackup --password=password --host=localhost --port=3306 \

--defaults-file=/opt/dbaas/my.cnf \

--backup-dir=/tmp/backuptmp \

backup

在使用该备份数据集进行数据恢复前需要做什么操作（）【单选】？

mysql> show create table t1\G;

*************************** 1. row ***************************

       Table: t1

Create Table: CREATE TABLE `t1` (

  `id` int NOT NULL,

  `testkey` int DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin；

Mysql>select * from t1;

+----+---------+

| id | testkey |

+----+---------+

|  1 |       1 |

|  2 |       2 |

|  3 |       4 |

|  5 |       5 |

|  8 |       8 |

该SQL 语句select * from t1 where testkey =6 for update 加锁的情况是（）【单选】？