超星 - 查询1 - 查题吧

单选题

下面哪一个like命令会返回名字像HOTKA的行?( )

A. where ename like ‘_HOT%'
B. where ename like ‘H_T%'
C. where ename like ‘%TKA_'
D. where ename like ‘%TOK%'

单选题

ALTER TABLE
B. DEFINE TABLE
C. MODIFY TABLE
D. REBUILD TABLE

单选题

A. select job from emp;
B. select job,count(*) from emp;
C. select distinct job,count(*) from emp;
D. select job,count(*) from emp group by job;