第4题
A、CREATE DATABASE
B、CREATE TABLE
C、SELECT
D、CREATE VIEW
第5题
以下语句实现对“教学管理”数据库中“性别表”的数据读取,空白处填写的数据读取语句应该是如下哪一句。 Dim ConnString As String = _ "Data Source=192.168.24.158; Initial Catalog=教学管理;Persist Security Info=True;User ID=sa;Password=123" Dim sqltxt As String = “select * from 性别表" '定义sql语句 Dim sqlconn As New SqlConnection(ConnString) '定义连接 Dim sqlcmd As New SqlCommand(sqltxt, sqlconn) '定义sqlCommand Dim userReader As SqlDataReader '定义sqldatareader Try sqlconn.Open() '打开连接 userReader = sqlcmd.ExecuteReader '生成sqldatareader () '读取数据 MsgBox(userReader.Item(3)) '显示读取的第四个数据 userReader.Close Catch ex As Exception MsgBox(ex.Message) Finally sqlcmd.Dispose() ' 释放sqlCommand
A、userReader.ReadData()
B、userReader.Fill()
C、userReader.ReadTable()
D、userReader.Read()
第9题
A、grant select, insert on studb.stuinfo for 'zhangsan'@'localhost'
B、grant select, insert on studb.stuinfo to 'zhangsan'@'localhost'
C、grant 'zhangsan'@'localhost' to select, insert for studb.stuinfo
D、grant 'zhangsan'@'localhost' to studb.stuinfo on select, insert
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!