网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
从表user中查找用户名：name="aa"和密码：password="123"的sql语句输写如下： select * from user where name=aa and password=123。
参考答案和解析
USE AA;
更多 “从表user中查找用户名：name="aa"和密码：password="123"的sql语句输写如下： select * from user where name=aa and password=123。” 相关考题
考题
【问题4】（5分）系统实现时，对用户的登录判断所用的动态SQL语句如下：“SELECT* FROM Users WHERE User_Name=‘”+strUserName+“‘AND Password=‘”+ strPassword+“’；”该SQL语句是否能防止SQL注入？请设计一个测试用例，以测试SQL注入，并说明防止SQL注入的方法。
考题
这个sql语句怎么写?
有三个表如下users(id,name);type(id,name);note(id,title,contents,user_id,author_id,type_id);其中，user_id是作者、author_id是原创作者都是与users中的id进行关联的，type_id是分类编号，与type的id关联。现在需要创建一个视图显示note中的id、title、contents、user_id、author_id、type_id、以及user_id、author_id、type_id对应的name。怎样写sql语句呢？
考题
某留言系统采用ASP+Access开发，其后台管理登录页面如图4-1所示。图4-1【问题1】（9分）以下是该后台管理登录页面login.asp的部分代码，请仔细阅读该段代码，根据图4-1 将（1）~（9）的空缺代码补齐。!--include file=“conn.asp”--!--include file=“md5.asp”--!--include file=“bbb.asp”--%If request.Form（“submit”）=“管理登录”Thenuser_name = request.Form（“ （1） ”）password = request.Form（“ （2） ”）verifycode = request.Form（“ （3） ”）If user name =“” ThenCallinfoback（“用户名不能为空！”）End If．．．．．．Set （4） = server. CreateObject（“adodb.recordset”）sql = “select * from administrator （5） user_name = “user_name”andpassword = “md5（password）””rs.Open （6） ，conn，1，1If （7） rs.EOF Thensession（“user_name”）= user_nameresponse.redirect“information.asp”ElseCall infoback（“用户名或密码错误！”）End IfEnd If%html ．．．．．．bodyform. method=“post”action=“login.asp”id=“login”hl管理员登录/hllabel for=“user_name”用户名：input name=“user_name” type=“text” class=“user_name” id=“uname” size=“25”//labellabel for=“password“密码：input name=“password”type=“password”id=“pword” size=“25”//labellabel for=“verifycode”验证码：input name=“verifycode” type=“text” class=“verifycode” id=“vcode” size=“10”maxlength=“4”/img src=“code.asp” nclick=“javascript.:this.src=‘code.asp?tm=’+Math.random（）”style=“cursos：pointer” alt=“点击更换” title=“点击更换”//labelp class=“center”input name=“reset”type=“ （8） ” class=“submit” value=“清除数据”/input type=“ （9） ” name=“submit” class=“submit”value=“管理登录”//p/form/body/html（1）~（9）备选答案如下：A．pword B．where C．uname D．vcode E．resetF．submit G．rs H．sql I． Not
考题
BookStore数据库中有客户表Customer（CustomerCode，Name，Sex，Hometown，Email，Telephone，LoginDate，Password）删除Customer表中姓“刘”和姓“杨”的记录。SQL语句：DELETE FROMCustomer WHERE（）A、LEFT（Name，1）=‘刘’ORLEFT（Name，1）=‘杨’B、NameLIKE‘刘%‘ORNameLIKE杨%‘C、NameLIKE‘[刘，杨]%‘D、NameLIKE‘[^刘，^杨]%
考题
BookStore数据库中有客户表Customer（CustomerCode，Name，Sex，Hometown，Email，Telephone，LoginDate，Password）查询Customer表中所有客户的信息，SQL语句：SELECT（）FROMCustomerA、*B、CustomerCode，Name，Hometown，Sex，Email，Telephone，LoginTime，PassWordC、CustomerCode，Hometown，Telephone，Name，Sex，Email，LoginTime，PassWordD、CustomerCode~PassWord
考题
数据库中有一张表名称为Student，有列Name，Age，IDCard，Sex。要求写SQL语句查询出表中所有的数据，下列哪个SQL语句是正确的（）A、Select* From StudentB、Select Name From StudentC、Select Name，Age，IDCard From StudentD、Select Name，Age，IDCard，Sex From Student
考题
以下（）语句从表TABLE_NAME中提取前10条记录。A、select * from TABLE_NAME where rowcount=10B、select TOP 10 * from TABLE_NAMEC、select TOP of 10 * from TABLE_NAMED、select * from TABLE_NAME where rowcount=10
考题
以下哪一个语句是正确的SQL语句（）A、select*fromuser_nameB、show*user_nameC、ls*fromuser_nameD、display*user_name
考题
You need to display the last names of those employees who have the letter "A" as the second character in their names.Which SQL statement displays the required results?（）A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';B、SELECT last_name FROM EMP WHERE last name ='*A%'C、SELECT last_name FROM EMP WHERE last name ='_A%';D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'
考题
数据库中有一张表名称为Student，有列Name，Age，IDCard，Sex。要求写SQL语句查询出表中年龄介于20和30岁之间的数据，下列哪个SQL语句是正确的？（）A、Select* From Student Where Age=20 ANDAge=30B、Select* From Student Where Age=20 ANDAge=30C、Select* From Student Where Age BET WENN 20AND30D、Select* From Student Where Age=20Age=30"
考题
以下（）语句从表TABLE_NAME中提取前10条记录。A、select*from TABLE_NAME where rowcount=10B、selectTOP 10*from TABLE_NAMEC、selectTOPof 10*from TABLE_NAMED、select*from TABLE_NAME wherer owcount=10
考题
在Transact-SQL语法中，以下SELECT语句正确的是（）。A、SELECT * FROM studentB、SELECT * FROM student WHERE GETDATE（）C、SELECT * FROM student ORDER st_idD、SELECT * FROM student BY St_name
考题
In form-based authentication， what must be included in the HTML returned from the URL specified by the element？（）A、 a base-64 encoded user name and passwordB、 a form that POSTs to the j_security_check URLC、 an applet that requests the user name and password from the userD、 a hidden field that supplies the login-constraint used by the application
考题
mysql数据库中一张user表中，其中包含字段A，B，C，字段类型如下：A：int，B：int，C://int根据字段A，B，C按照ABC顺序建立复合索引idx_A_B_C，以下查询语句中使用到索引idx_A_B_C的语句有哪些（）。A、 select *from user where A=1 and B=1B、 select *from user where 1=1 and A=1 and B=1C、 select *from user where B=1 and C=1D、 select *from user where A=1 and C=1
考题
当需要返回当前用户的名字，可以执行如下（）SQL语句。A、SELECT user FROM V$DBAB、SELECT user FROM dualC、SELECT name FROM dualD、SELECT name FROM V$DBA
考题
Which SQL statement accepts user input for the columns to be displayed, the table name, and the WHERE condition?（）A、SELECT 1, "2" FROM 3 WHERE last_name = '4';B、SELECT 1, '2' FROM 3 WHERE 'last_name = '4'';C、SELECT 1, 2 FROM 3 WHERE last_name = '4';D、SELECT 1, '2' FROM EMP WHERE last_name = '4';
考题
下列哪些SQL语句可以查询出User表中name为张三的记录（）。A、SELECT * FROM User WHERE name = ’张三’B、SELECT * FROM User WHERE name = ’张三’ LIMIT 0，1C、SELECT * FROM User WHERE name LIKE ’张三’D、SELECT * FROM User WHERE name LIKE ’%张三%’
考题
单选题有如下用户表和主题帖表：用户（用户名C，密码C，性别L，电子邮箱C）主题帖（编号C，用户名C，标题C，内容M，发帖时间T）查询没有发表过任何主题帖的用户信息，正确的SQL语句是（ ）。A
SELECT*FROM用户WHERE NOT EXISTS（SELECT*FROM主题帖WHERE用户名=用户.用户名）B
SELECT*FROM用户WHERE EXISTS（SELECT*FROM主题帖WHERE用户名！=用户.用户名）C
SELECT*FROM用户WHERE用户名NOT IN（SELECT*FROM主题帖）D
SELECT*FROM用户WHERE用户名！=（SELECT用户名FROM主题帖）
考题
单选题BookStore数据库中有客户表Customer（CustomerCode，Name，Sex，Hometown，Email，Telephone，LoginDate，Password）查询Customer表中所有客户的信息，要求显示CustomerCode、Name、Hometown和Telephone字段信息。SQL语句：SELECT（）FROM CustomerA
*B
ALLC
CustomerCode、Name、Hometown、TelephoneD
CustomerCode，Name，Hometown，Telephone
考题
单选题Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?（）A
SELECT 1, 2 FROM 3 WHERE last_name = '8';B
SELECT 1, '2' FROM 3 WHERE ' last_name = '8';C
SELECT 1, 2 FROM 3 WHERE last_name = '8';D
SELECT 1, '2' FROM EMP WHERE last_name = '8';
考题
单选题当需要返回当前用户的名字，可以执行如下（）SQL语句。A
SELECT user FROM V$DBAB
SELECT user FROM dualC
SELECT name FROM dualD
SELECT name FROM V$DBA
考题
单选题In form-based authentication， what must be included in the HTML returned from the URL specified by the element？（）A
a base-64 encoded user name and passwordB
a form that POSTs to the j_security_check URLC
an applet that requests the user name and password from the userD
a hidden field that supplies the login-constraint used by the application
考题
多选题下列哪些SQL语句可以查询出User表中name为张三的记录（）。ASELECT * FROM User WHERE name = ’张三’BSELECT * FROM User WHERE name = ’张三’ LIMIT 0，1CSELECT * FROM User WHERE name LIKE ’张三’DSELECT * FROM User WHERE name LIKE ’%张三%’
考题
单选题You are the administrator of a Microsoft Windows Server 2003 computer named SQL1. SQL1 runs SQL Server 2005 and is a member of a Microsoft Active Directory domain named Contoso.com. The domain is configured with all of the default settings. Several members of the information security team have requested access to SQL1. The information security team uses the Microsoft Windows XP Professional， Linux， and Macintosh operating systems to perform vulnerability assessments. The information security team members ask you to create two new logon accounts for their use. They would like the logon accounts to have the following user names and passwords： User name/password for first account： pentest/P@ssw0rdUser name/password for second account： hacktest/password You need to provide the information security team with the requested access to SQL1. Which Transact-SQL script should you use？（）A
CREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password'B
CREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password',CHECK_POLICY = OFFC
CREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password'[HASHED]D
CREATE LOGIN [CONTOSO/pentest]FROM WINDOWS CREATE LOGIN [CONTOSO/hacktest]FROM WINDOWS
考题
单选题有如下用户表：用户（用户名C，密码C，性别L，电子邮箱C）要修改用户名为“liuxiaobo”的用户的密码和电子邮箱，正确的SQL语句是（ ）。A
UPDATE用户SET密码=“abcdef'”电子邮箱=“ lxb@123.com”；WHERE用户名=“liuxiaobo”B
UPDATE用户SET密码=“abcdef”AND电子邮箱=“lxb@123.com”；WHERE用户名=“liuxiaobo”C
UPDATE TO用户SET密码=“abcdef'”电子邮箱=“lxb@123.com”；WHERE用户名=“liuxiaobo”D
UPDATE TO用户SET密码=“abcdef”AND电子邮箱=“lxb@123.tom”；WHERE用户名=“liuxiaobo”
考题
单选题A user named Arren is executing this query： select table_name，operation，undo_sql from flashback_transaction_query t， （select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123） e where t.xid = e.xid； When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem. Which of the following SQL statements will correct this problem？（）A
GRANT SELECT ANY TRANSACTION TO ARRENB
GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARRENC
GRANT SELECT_ANY_TRANSACTION TO ARREND
GRANT FLASHBACK TO ARRENE
GRANT SELECT ANY VIEW TO ARREN
热门标签
最新试卷