在OLAP应用中,CPU利用率达到100%的SQL都是有问题的,需要进行优化把CPU利用事给障下来。单选()
查看答案
被授予DBA角色的用户拥有以下哪些权限?单选()
A. CREATE USER
B. CREATE ROLE
CREATE SESSION
D. 以上全都正确
下面关于GROUPBY的用法正确的是?多选()
A. select id, score from student group by id,score;
B. select id, sum(score) from student group by id;
C. select sum(score) from student group by id;
D. select id, score from student group by id;
GaussDB100用于实现AZ内高可用,提供秒级快速倒换的特性叫做?单选()
A. Quick Switch
B. Switch Smart
C. Flash Back
D. Switch Turbo
下面哪种别名用法是正确的?多选()
A. select staff_id id from staffs;
B. select staff _id as id from staffs;
C. select staffl_id id from staffs;
D. select staff_id id from staffs;