纳税人在计算资源税时，对适用税额的确定方法的表述正确的有（）。

根据SQL标准，下面哪句语句能够找出年龄最小的同学？其中age为学生表student中的年龄字段，sno为学生的学号。()

A select max(age) from student

B select sno from student where age = max(age)

C select sno from student having age = max(age)

D select sno from student a where a.age<= (select min(b.age) from student b)

根据SQL标准，要修改表student中所有学生的年龄age，使之在原值基础上减一，下面哪个语句适用？()

A update student set age = 1

B update student set age = age - 1

C update age = age -1 from student

D update from student where age = age -1

根据SQL标准，要查询表student中所有年龄age小于所有学生的平均年龄的记录，下面哪条语句适用？()

A select * from student where age< avg(age)

B select * from student having age< avg(age)

C select * from student a where a.age< (select avg(b.age) from student b)

D select * from student a where (select avg(b.age) from student b ) >= a.age

使用SQL命令将学生表student中的学生年龄age字段的值增加1岁，应该使用的命令是()。

A、update set age with age+1

B、update student age with age+1

C、update studnet set age=age+1

D、replace age with age+1

在Visual FoxPro中，使用SQL命令将学生表STUDENT中的学生年龄AGE字段的值增加1岁，应该的使用命令是( )。

A．REPLACE AGE WITH AGE+1 B．UPDATE STUDENT AGE WITH AGE+1

C．UPDATE SET AGE WITH AGE+1 D．UPDATE STUDENT SET AGE=AGE+1

在Visual FoxPro中，使用SQL命令将学生表STUDENT中的学生年龄AGE字段的值增加1岁，应该的使用命令是( )。

A．REPLACE AGE WITH AGE+1 B．UPDATE STUDENT AGE WITH AGE+1

C．UPDATE SET AGE WITH AGE+1 D．UPDATE STUDENT SET AGE=AGE+1

用SQL语句将STUDENT表中字段“年龄”的值加1，可以使用的命令是

A)UPDATE STUDENT SET年龄=年龄+1

B) UDDATE STUDENT年龄WITH年龄+1

C)REPLACE STUDENT年龄=年龄+1

D)REPLACE STUDENT年龄WITH年龄+1

使用SQL语句将学生表S中年龄(AGE)大于30岁的记录删除，正确的命令是

A．DELETE FOR AGE＞30

B．DELETE FROM S WHERE AGE＞30

C．DELETE S FOR AGE＞30

D．DELETE S WHERE AGE＞30

使用SQL语句将学生表S中年龄(AGE)大于30岁的记录删除，正确的命令是______。

A．DELETE FOR AGE＞30

B．DELETE FROM S WHERE AGE＞30

C．DELETE S FOR AGE＞30

D．DELETE S WHERE AGE＞30

A．REPLACE AGE WITH AGE+1

B．UPDATE STUDENT AGE WITH AGE+1

C．UPDATE SET AGE WITH AGE+1

D．UPDATE STUDENT SET AGE=AGE+1