网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
在SQL查询语句中,"UPDATE Student SET补助=补助+1.2"的意思是()
- A、将Student表中的所有记录的补助均增加1.2
- B、将Student表中的当前记录的补助增加1.2
- C、将Student表中的所有记录的补助均设置为1.2
- D、将Student表中的当前记录的补助设置为1.2
参考答案
更多 “在SQL查询语句中,"UPDATE Student SET补助=补助+1.2"的意思是()A、将Student表中的所有记录的补助均增加1.2B、将Student表中的当前记录的补助增加1.2C、将Student表中的所有记录的补助均设置为1.2D、将Student表中的当前记录的补助设置为1.2” 相关考题
考题
( 37 ) 在 “ 查询选修课程号为 C04 , 且成绩在 80 分以上的所有学生的学号和姓名 ” 的 SQL 语句中 , 将使用的表有A )仅 STUDENTB )仅 STUDENT 和 COURSEC )仅 SSTUDENT 和 SCD ) STUDENT 、 COURSE 和 SC
考题
设有关系模式:student(sno, sname, age, dept),现利用命令: CREATE VIEW stu AS SELECT *FROM student WHERE dept="cs"WITH CHECK OPTION 创建了一个视图。则以下SQl命令中能正确执行的是A.UPDATE stu SET dept="maths"B.UPDATE stu SET dept="maths"WHERE age>=20C.INSERT INTO stu VALUES ("2004001", "John", 30, "cs")D.INSERT INTO stu VALUES ("2004001", "John", 50, "maths")
考题
对于学生信息表:student(sno,sname,sex,age,dept),如果把学生“小明”的姓名改为“小强”,则正确的语句是( )。A)UPDATE SET sname=‘小明’WHERE sname=‘小强’B)UPDATE student SET sname=‘小明’WHERE sname=‘小强’C)UPDATE student SET sname=‘小强’D)UPDATE student SET sname=‘小强’WHERE sname=‘小明’
考题
要使 “ 产品 ” 表中所有产品的单价上浮 8 %,正确的 SQL 命令是A)UPDATE 产品 SET 单价 = 单价 + 单价 *8% FOR ALLB)UPDATE 产品 SET 单价 = 单价 *1.08 FOR ALLC)UPDATE 产品 SET 单价 = 单价 + 单价 *8%D)UPDATE 产品 SET 单价 = 单价 *1.08
考题
下列SQI语句中,能够实现“收回用户WANG对学生表(STUDENT)中学号(XH)的修改权”这一功能的是A.GRANT UPDATE(XH)ON STUDENT TO WANGB.GRANT UPDATE(XH)ON TABLE TO WANGC.REVOKE UPDATE(XH) ON STUDENT FROM WANGD.REVOKE UPDATE(XH) ON TABLE FROM WANG
考题
对于学生信息表:student(sno,sname,sex,age,dept),如果把学生“张明”的姓名改为“张岩”,则正确的语句是A.UPDATE SET sname='张明'WHERE sname='张岩'B.UPDATE student SET shame='张明'WHERE shame='张岩'C.UPDATE student SET sname='张岩'D.UPDATE student SET sname='张岩'WHERE sname='张明'
考题
20 ) 下列 SQL 语句中 , 能够实现 “ 收回用户 WANG 对学生表 ( STUDENT ) 中学号 ( XH ) 的修改权 ” 这一功能的是A ) GRANT UPDATE ( XH ) ON STUDENT TO WANGB ) GRANT UPDATE ( XH ) ON TABLE TO WANGC ) REVOKE UPDATE ( XH ) ON STUDENT FROM WANGD ) REVOKE UPDATE ( XH ) ON TABLE TO WANG
考题
根据SQL标准,要修改表student中所有学生的年龄age,使之在原值基础上减一,下面哪个语句适用?()A update student set age = 1B update student set age = age - 1C update age = age -1 from studentD update from student where age = age -1
考题
在“查询选修课程号为C04,且成绩在80分以上的所有学生的学号和姓名”的SQL语句中,将使用的表有A.仅STUDENTB.仅STUDENT和COURSEC.仅STUDENT和SCD.STUDENT、COURSE和SC
考题
用SQL语句将STUDENT表中字段“年龄”的值加1,可以使用的命令是( )。A.REPLACE STUDENT年龄一年龄+1B.REPLACE STUDENT年龄WITH年龄+1C.UPDATE STUDENT SET年龄一年龄+1D.UPDATE STUDENT年龄WITH年龄+1
考题
下列SQL语句中,能够实现“收回用户WANG对学生表(STUDENT)中学号(XH)的修改权”这一功能的是( )。A.GRANT UPDATE(XH) ON STUDENT TO WANGB.GRANT UPDATE(XH) ON TABLE TO WANGC.REVOKE UPDATE(XH) ON STUDENT FROM WANGD.REVOKE UPDATE(XH) ON TABLE FROM WANG
考题
用SQL语句将STUDENT表中字段“年龄”的值加1,可以使用的命令是A)UPDATE STUDENT SET年龄=年龄+1B) UDDATE STUDENT年龄WITH年龄+1C)REPLACE STUDENT年龄=年龄+1D)REPLACE STUDENT年龄WITH年龄+1
考题
在Visual FoxPro中,使用SQL命令将学生表STUDENT中的学生年龄AGE字段的值增加1岁,应该的使用命令是( )。A. REPLACE AGE WITH AGE+1B. MODIFY STUDENT SET AGE=AGE+1C. ALTER STUDENT SET AGE WITH AGE+1D. UPDATE STUDENT SET AGE=AGE+1
考题
在Visual FoxPro中,使用SQL命令将学生表STUDENT中的学生年龄AGE字段的值增加 1岁,应该使用的命令是A.REPLACE AGE WITH AGE+1B.UPDATE STUDENT AGE WITH AGE+1C.UPDATE SET AGE WITH AGE+1D.UPDATE STUDENT SET AGE=AGE+1
考题
Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do? ()A、The set of statements contains an error and does not work.B、It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.C、It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.D、It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.E、It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.F、It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
考题
在VisualFoxPro中,使用SQL命令将学生STUDENT中的学生年龄AGE字段的值增加1岁,应该使用的命令是()。A、REPLACE AGE WITH AGE+1B、UPDATE STUDENT AGE WITH AGE+1C、UPDATE SET AGE WITH AGE+1D、UPDATE STUDENT SET AGE=AGE+1
考题
在Visual FoxPro中,使用SQL命令将学生表STUDENT中的AGE字段的值增加5岁,应使用的命令是()。A、A .REPLACE AGE WITH AGE+5B、B .UPDATE STUDENT AGE WITH AGE+5C、C .UPDATE SET AGE WITH AGE+5D、D .UPDATE STUDENT SET AGE=AGE+5
考题
使用SQL命令将学生表STUDENT中的学生年龄AGE字段的值增加1岁,应该使用的命令是()。A、REPLACE AGE WITH AGE+1B、UPDATE STUDENT AGE WITH AGE+1C、UPDATE SET AGE WITH AGE+1D、UPDATE STUDENT SET AGE=AGE+1
考题
下列Transact-SQL语句中出现语法错误的是()。A、declare @ab cintB、select*from 学生C、delete*from 学生D、update 学生 set 考核=‘优’
考题
单选题在Visual FoxPro中,使用SQL命令将学生表STUDENT中的AGE字段的值增加5岁,应使用的命令是()。A
A .REPLACE AGE WITH AGE+5B
B .UPDATE STUDENT AGE WITH AGE+5C
C .UPDATE SET AGE WITH AGE+5D
D .UPDATE STUDENT SET AGE=AGE+5
考题
单选题Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do? ()A
The set of statements contains an error and does not work.B
It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.C
It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.D
It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.E
It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.F
It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
考题
单选题在SQL查询语句中,"UPDATE Student SET补助=补助+1.2"的意思是()A
将Student表中的所有记录的补助均增加1.2B
将Student表中的当前记录的补助增加1.2C
将Student表中的所有记录的补助均设置为1.2D
将Student表中的当前记录的补助设置为1.2
热门标签
最新试卷