Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?() A.REVOKE ALL PRIVILEGES FROM USER tomB.REVOKE ALL ON EMPLOYEE FROM USER tomC.REVOKE EXECUTE ON EMPLOYEE FROM USER tomD.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()

A.REVOKE ALL PRIVILEGES FROM USER tom

B.REVOKE ALL ON EMPLOYEE FROM USER tom

C.REVOKE EXECUTE ON EMPLOYEE FROM USER tom

D.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom


相关考题:

Which view should a user query to display the columns associated with the constraints on a table owned by the user? () A. USER_CONSTRAINTSB. USER_OBJECTSC. ALL_CONSTRAINTSD. USER_CONS_COLUMNSE. USER_COLUMNS

Thesearepointsthatdescribethecontentsofdifferentmemorycomponents:1:DescriptiveinformationormetadataaboutschemaobjectsthatarequeriedbyusingSQLstatements2:Therun-timeareafordatamanipulationlanguage(DML)ordatadefinitionlanguage(DDL)statements3:ResultsofSQLqueriesandPL/SQLfunctions4:ExecutableformsofSQLcursors,PL/SQLprograms,andJavaclasses5:TheinformationnecessarytoreconstructchangesmadetothedatabasebyatransactionWhichofthesewillbestoredintheSharedPoolifthenecessaryconfigurationsaredone()

在Mysql的授权表中,不受GRANT和REVOKE语句的影响的权限表是()。A.db权限表B.host权限表C.table_priv权限表D.user权限表

在SQL Server 2000中,某数据库中有角色Role和用户User,User是Role角色的成员,且只属于该角色。先对Table表给Role只授予SELECT和DELETE权限,并授予User对T表具有SELECT、UPDATE和DENY DELETE权限,则用户User对Table表可以执行的操作是______。

pageContext.setAttribute("user","tom");request.setAttribute("user","bob");显示"bob",则可以使用 A.{request.getAttribute("user")}B.{param.user}C.{user}D.{requestScope.user}

Youwillwanttwotreesabouttenfeetapart,from_____tosuspendyourtent.(A)there(C)which(B)them(D)where

You will want two trees about ten feet apart, 选择 Youwillwanttwotreesabouttenfeetapart,from_____tosuspendyourtent.(A)there(C)which(B)them(D)where

( 33 )查询选修课程号为 “ 101 ” 课程得分最高的同学,正确的 SQL 语句是A) SELECT 学生 . 学号 , 姓名 FROM 学生 , 选课 WHERE 学生 . 学号 = 选课 . 学号AND 课程号 = "101" AND 成绩 =ALL(SELECT 成绩 FROM 选课 )B) SELECT 学生 . 学号 , 姓名 FROM 学生 , 选课 WHERE 学生 . 学号 = 选课 . 学号AND 成绩 =ALL(SELECT 成绩 FROM 选课 WHERE 课程号 = "101" )C) SELECT 学生 . 学号 , 姓名 FROM 学生 , 选课 WHERE 学生 . 学号 = 选课 . 学号AND 成绩 =ANY(SELECT 成绩 FROM 选课 WHERE 课程号 = "101" )D) SELECT 学生 . 学号 , 姓名 FROM 学生 , 选课 WHERE 学生 . 学号 = 选课 . 学号AND 课程号 = "101"AND 成绩 =ALL(SELECT 成绩 FROM 选课 WHERE 课程号 = "101" )

以下那一个选项是查询数据方法:A.User.objects.filter(username='wangwu').get(pk=1)B.User.objects.filter(id=user_id).update(password='9999')C.User.objects.all().delete()D.User.objects.get(pk=user_id).delete()

20、数据操纵DML包括()A.update 修改数据B.revoke 回收权限C.update 修改数据D.grant 授权