主表中没有的记录就不能添加到相关表中,则应该在编辑表关系时设置()。
A. 实施参照完整性
B. 有效性规则
C. 输入掩码
D. 级联更新相关字段
查看答案
“借阅”表中有“学号”和“图书编号”等字段,每位学生每借阅一本书生成一条记录,要求按学生学号统计出每位学生的借阅次数,下列SQL语句中,正确的是()。
A. SELECT学号, Count(学号) FROM 借阅
B. SELECT学号, Count(学号) AS 借阅次数 FROM 借阅 GROUP BY 学号
C. SELECT学号, Sum(学号) FROM 借阅 GROUP BY 学号
D. SELECT学号, Sum(学号) FROM 借阅 ORDER BY 学号
Access2010数据库文件的默认扩展名是（______ ）
与如下语句等价的是（ A ）SELECT * FROM stock WHERE 单价Between 12.76 And 15.20
A. SELECT * FROM stock WHERE 单价>=12.76 And 单价<=15.20
B. SELECT * FROM stock WHERE 单价<15.20 And 单价>12.76
C. SELECT * FROM stock WHERE 单价>=15.20 And 单价<=12.76
D. SELECT * FROM stock WHERE 单价>15.20 And 单价<12.76
与如下语句等价的是()。 SELECT * FROM Member WHERE InStr([简历], "篮球")>0
A. SELECT * FROM Member WHERE 简历Like"篮球"
B. SELECT * FROM Member WHERE 简历Like"*篮球"
C. SELECT * FROM Member WHERE Member.简历Like"*篮球*"
D. SELECT * FROM Member WHERE Member.简历Like"篮球*"
微信支付 
支付宝支付