【单选题】【消耗次数:1】
设ADOrs为Recordset对象,从“学生基本情况表”中获取所有记录的语句是()。
ADOrs.New “Select * From学生基本情况表”
ADOrs.Open “Select * From学生基本情况表”
ADOrs.Execute “Select * From学生基本情况表”
ADOrs.Select “Select * From学生基本情况表”
参考答案:
复制
纠错
相关题目
【单选题】 设ADOrs为Recordset对象,从“学生基本情况表”中获取所有记录的语句是()。
①  ADOrs.New “Select * From 学生基本情况表”
②  ADOrs.Open “Select * From 学生基本情况表”
③  ADOrs.Execute “Select * From 学生基本情况表”
④  ADOrs.Select “Select * From 学生基本情况表”
【判断题】 执行命令“select * from sb order by 价格 DESC”,将查询表中所有设备的基本情况,查询结果按价格升序排
①  正确
②  错误
【判断题】 执行命令“select * from sb order by 启用日期”,将查询表中所有设备的基本情况,查询结果按启用日期升序排
①  正确
②  错误
【判断题】 执行命令“select * from sb where 名称=车床 distinct”,将查询表中所有车床的基本情况,查询结果允许出现重复值
①  正确
②  错误
【判断题】 执行命令“select * from sb where 名称=车床”,将显示名称不是车床的设备的基本情况
①  正确
②  错误
【判断题】 执行命令“select * from sb order by 价格 DESC,启用日期 asc”,将查询表中所有设备的基本情况,查询结果按价格降序排,价格相同再按启用日期升序排
①  正确
②  错误
【判断题】 用户对“学生”表的SELECT权限为禁止,但该用户所属角色具有“学生”表的SELECT权限,则该用户仍可以查询“学生”表数据。
①  正确
②  错误
【判断题】 SELECT COUNT(DISTINCT Sno) FROM SC 语句用于统计学生的总人数。
①  正确
②  错误
【判断题】 在诉讼文书的起诉状中,不仅要写入原告的基本情况,而且应写入被告的基本情况。
①  正确
②  错误
【判断题】 SELECT * FROM Student WHERE Sname LIKE张_语句中的张_ 用于查找姓张的学生。
①  正确
②  错误
随机题目
【单选题】 On his next birthday he () married for ten years.
①  has been
②  will be
③  will have been
④  would have been
【单选题】 Hi, welcome back! Had a nice trip?____________
①  Oh, fantastic! Fresh air, and sunshine every day.
②  Come on, I’ve got lots of fun.
③  By the way, I don’t like Saturdays.
④  Well, I’ll look forward to your phone call.
【单选题】 In Britain people drive _____the left.
①  at
②  on
③  to
④  in
【单选题】 What()next will be discussed at the next meeting.
①  to do
②  is doing
③  will do
④  shall we do
【单选题】 _______ his sister, Jack is quiet and does not easily make friends with others.
①  Dislike
②  Liking
③  Alike
④  Unlike
【单选题】 How do you do? Glad to meet you._________
①  Fine. How are you?
②  How do you do? Glad to meet you, too.
③  How are you? Thank you!
④  Nice. How are you?
【单选题】 Don’t take any action until you are fully _____ with the situation there.
①  consented
②  content
③  obvious
④  acquainted
【单选题】 When a fire____ at the National Exhibition in London, at least ten priceless paintings were completely destroyed.
①  broke off
②  broke out
③  broke down
④  broke up
【单选题】 What a bad memory I’ve got! I even forgot ______ the book with me.
①  took
②  taking
③  take
④  taken
【单选题】 As the bus came round the comer, it ran _______ a big tree by the roadside.
①  over
②  on
③  into
④  up