单选题Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）A GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpB GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C GRANT INSERT ON TA

题目内容(请给出正确答案)

单选题

Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）

GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp

GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1

GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp

GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

（ 35 ） “ 把查询 sc 表和更新 sc 表的 grade 列的权限授予用户 user1 ” 的正确 SQL 语句是A ） GRANT SELECT ， UPDATE （ grade ） ON TABLE sc TO user1B ） GRANT SELECT sc ， UPDATE sc . grade TO user1C ） GRANT SELECT ， UPDATE ON TABLE sc . grade TO user1D ） GRANT SELECT ON TABLE sc ， UPDATE ON TABLE sc(grade) TO user1

点击查看答案
第2题

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()A. ALTER DATABASE FLASHBACK ON;B. GRANT SELECT any transaction TO scott;C. GRANT EXECUTE ON dbms_flashback TO scott;D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

点击查看答案
第3题

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()A. GRANT select ON dept TO ALL_ USER;B. GRANT select ON dept TO ALL;C. GRANT QUERY ON dept TO ALL_USERSD. GRANT select ON dept TO PUBLIC;

点击查看答案
第4题

Examine the statement:GRANT select, insert, updateON student_gradesTO managerWITH GRANT OPTION;Which two are true?()A. MANAGER must be a role.B. It allows the MANAGER to pass the specified privileges on to other users.C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.F. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.

点击查看答案
第5题

“把查询sc表和更新sc表的grade列的权限授予用户user1”的正确SQL语句是（）。A．GRANT SELECT，UPDATE（grade）ON TABLE sc TO user1B．GRANT SELECT sc，UPDATE sc．grade TO user1C．GRANT SELECT，UPDATE ON TABLE sc．grade TO usedD．GRANT SELECT ON TABLE sc，UPDATE ON TABLE sc(grade) TO user1

点击查看答案
第6题

Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?()A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpB.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpD.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom

点击查看答案
第7题

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 grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）A GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpB GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C GRANT INSERT ON TA

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容