多选题
1.
GBase 8s rename database失败的原因有 ()
A database closed
B database不存在
C当前正在操作的database
D被更名的database处于打开状态
正确答案: B C D
解析:
Cannot drop or rename the current database
or anyopen database.
单选题
2.
删除数据库正确的SQL语句是 (
A delete database courseware;
B delete databases courseware,
C drop database if exists courseware.
D drop database if exist courseware.
我的答案: B
解析:
删除数据库的语法drop database [if exists] <db
name>.
单选题
3.
重命名表中存在列正确的SQL语句是 (
A rename student.age to age1.
B rename column student.age to age1;
C rename column 'student.age' to 'age1
D rename column "student.age" to
"age1"
正确答案: B
解析:
重命名表中存在列语法rename column
<tableName>coldColumnName> to <newColumnName>.
多选题
4.
正确的Delete SQL语句是 ()
A select * from t user where f userid = 1;
B delete * from t user where f userid = 1;
C delete from t user where f userid = 1;
D delete t user where f userid = 1
正确答案: C D
解析:
Deletei语法delete
from <table name | view namesynonym name>[where condition];from可以省略
多
5.
以下正确的Insert (进阶语法) SQL语句是 ()
A insert into t user2 (userid, username)
select * fromt user1.
B insert into t user2 select * from t
user1;
C insert into t user2 (userid, username)
selectuserid,username from t user1:
D select userid, username into t user2 from
t user1;
正确答案: A B C
解析:
Inser进阶语法insert
into <table name ] view namelsynonym name>column name1. column
name2..select col name1, col name2, ... ;.
