A、 GRANT SELECT, INSERT ON dbⱣⱤtest. tbⱣⱤcustomer TO ‘wang' @’localhost’ WITH GRANT OPTION;
B、 GRANT SELECT, INSERT ON dbⱣⱤtest. tbⱣⱤcustomer TO ‘wang' @’localhost’;
C、 GRANT SELECT ON dbⱣⱤtest. tbⱣⱤcustomer TO ‘wang' @’localhost’ WITH GRANT OPTION;
D、 GRANT SELECT, INSERT ON dbⱣⱤtest. tbⱣⱤcustomer TO ‘wang' @’localhost’ WITH CHECK OPTION;
答案:A
A、 GRANT SELECT, INSERT ON dbⱣⱤtest. tbⱣⱤcustomer TO ‘wang' @’localhost’ WITH GRANT OPTION;
B、 GRANT SELECT, INSERT ON dbⱣⱤtest. tbⱣⱤcustomer TO ‘wang' @’localhost’;
C、 GRANT SELECT ON dbⱣⱤtest. tbⱣⱤcustomer TO ‘wang' @’localhost’ WITH GRANT OPTION;
D、 GRANT SELECT, INSERT ON dbⱣⱤtest. tbⱣⱤcustomer TO ‘wang' @’localhost’ WITH CHECK OPTION;
答案:A
A. CREATE DATABASE
B. CREATE TABLE
C. CREATE DATABASES
D. CREATE DB
A. DECLARE @num; CALL CountProc1(in ‘女’,out @num);
B. SET @num; CALL CountProc1(‘女’,@num);
C. DECLARE @num; DECLARE CountProc1(‘女’,out @num);
D. DECLARE @num; CALL CountProc1(‘女’,@num);
A. CHECK是能够单独执行的SQL语句
B. 该表达式定义了对字段score的約束
C. score的取值范围为0-100 (包含0和100)
D. 更新表中数据时,检查score的值是否满足CHECK約束
A. CHANGE后面需要写两次列名,而MODIFY后面只写一次
B. 两种方式都可用于修改某个列的数据类型
C. 都可以使用FIRST或AFTER来修改列的排列顺序
D. MODIFY可用于修改某个列的名称
A. 11
B. 10
C. 0
D. 12
A. CHAR
B. VARCHAR
C. BINARY
D. BOLB
A. 0
B. 1
C. 2
D. 3