网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
假设需要删除某个角色test_role，可以使用如下（）语句。
- A、DELETE ROLE test_role
- B、REVOKE ROLE test_role
- C、DROP ROLE test_role
- D、DELETE test_role
参考答案
更多 “假设需要删除某个角色test_role，可以使用如下（）语句。A、DELETE ROLE test_roleB、REVOKE ROLE test_roleC、DROP ROLE test_roleD、DELETE test_role” 相关考题
考题
根据SQL标准，要删除表student中所有数据，但不将表student的定义一起删除，下面哪个语句可以适用?()A delete from studentB delete all from studentC delete * from studentD drop table student
考题
在SQL Server 2000中，某数据库中有角色Role和用户User，User是Role角色的成员，且只属于该角色。先对Table表给Role只授予SELECT和DELETE权限，并授予User对T表具有SELECT、UPDATE和DENY DELETE权限，则用户User对Table表可以执行的操作是______。
考题
假设需要删除某个角色test_role,可以使用如下()语句。
A.DELETE ROLE test_roleB.REVOKE ROLE test_roleC.DROP ROLE test_roleD.DELETE test_role
考题
假设需要在数据库中创建角色test_role,可以使用如下()语句。
A.ALTER DATABASE ROLE test_roleB.CREATE ROLE test_roleC.UPDATE ROLE test_roleD.ALTER ROLE test_role
考题
当需要删除某个序列seq_customer_id,可以使用如下()方式。
A.DROP SEQ_CUSTOMER_IDB.DELETE SEQUENCE SEQ_CUSTOMER_IDC.DROP SEQUENCE SEQ_CUSTOMER_IDD.DELETE SEQ_CUSTOMER_ID
考题
假设需要删除数据库中的CUSTOMER表,可以使用如下()方式。
A.DROP TABLE CUSTOMERB.DROP CUSTOMERC.DELETE TABLE CUSTOMERD.DELETE CUSTOMER
考题
某管理人员要使用系统维护模块的添加SYBASE用户窗口添加登录用户，则此管理人员必须具有数据库管理系统的什么角色（）A、oper_role角色B、sa_role角色C、sso_role角色D、mon_role角色
考题
删除emp表中所有数据，且无法rollback，以下语句哪个命令可以实现（）A、truncate table empB、drop table empC、delete * from empD、delete from emp
考题
You are designing a Windows Azure application. The application includes a web role and a worker role that communicate by using a Windows Azure Queue. The worker role processes each message within 10 seconds of retrieving it from the queue. The worker role must process each message exactly one time. If a process does not complete， the worker role must reprocess the message. You need to recommend an approach for the worker role to manage messages in the queue. What should you recommend？（）A、 Process the message and then delete it from the queue.B、 Delete the message from the queue when retrieving the message.C、 Set the visibility timeout of the message to 1 when retrieving the message.D、 Process the message and then set the visibility timeout of themessage to the maximum value.
考题
若要删除book表中所有数据，以下语句错误的是（）A、truncate table bookB、delete * from bookC、drop table bookD、delete from book
考题
假设需要删除数据库中的CUSTOMER表，可以使用如下（）方式。A、DROP TABLE CUSTOMERB、DROP CUSTOMERC、DELETE TABLE CUSTOMERD、DELETE CUSTOMER
考题
假设需要在数据库中创建角色test_role，可以使用如下（）语句。A、ALTER DATABASE ROLE test_roleB、CREATE ROLE test_roleC、UPDATE ROLE test_roleD、ALTER ROLE test_role
考题
当需要删除某个序列seq_customer_id，可以使用如下（）方式。A、DROP SEQ_CUSTOMER_IDB、DELETE SEQUENCE SEQ_CUSTOMER_IDC、DROP SEQUENCE SEQ_CUSTOMER_IDD、DELETE SEQ_CUSTOMER_ID
考题
单选题View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been grantedthe CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the userSKD by executing the command： SQL GRANT MGR_ROLE TO SKD WITH ADMIN OPTION； Which statement is true about the user SKD afterhe/she is granted this role（）A
The user SKD can grant only the MGR_ROLE role to other users， but not the privileges in it.B
The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.C
The user SKD can grant the privileges in the MGR_ROLE role to other users， but not with ADMIN OPTION.D
The user SKD can grant the privileges in the MGR_ROLE role to other users， but cannot revoke privilegesfrom them
考题
单选题假设需要删除某个角色test_role，可以使用如下（）语句。A
DELETE ROLE test_roleB
REVOKE ROLE test_roleC
DROP ROLE test_roleD
DELETE test_role
考题
单选题如果要启用所有角色，则应该使用哪一个命令？（）A
SET ROLE ALLB
SET ROLE ENABLE ALLC
ALTER SESSION ALLD
ALTER USER ROLE ALL
考题
单选题假设需要在数据库中创建角色test_role，可以使用如下（）语句。A
ALTER DATABASE ROLE test_roleB
CREATE ROLE test_roleC
UPDATE ROLE test_roleD
ALTER ROLE test_role
热门标签
最新试卷
