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;
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_USERS
- D、GRANT select ON dept TO PUBLIC;
相关考题:
( 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
“把查询SC表和更新SC表的9rade列的权限授予用户user”的正确SQL语句是( )。A)GRANT.SELECT sc, UPDATE sc.grade TO userB)GRANT SELECT, UPDATE (grade) ON TABLE sc TO userC)GRANT SELECT, UPDATE ON TABLE sc.grade TO userD)GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc(grade) TO user
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;
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;
The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()A. Alice onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber
“把查询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
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
若将Workers表的插入权限赋予用户User1,并允许其将该权限授予他人,那么对应的SQL语句为“GRANT( )TABLE Workers TO User1(请作答此空);”。A.FOR ALLB.PUBLICC.WITH CHECK OPTIOND.WITH GRANT OPTION
下列哪个语句将赋予用户John向表tab1中插入数据的权限?()A、GRANT ADD ON TABLE tab1 TO JohnB、GRANT INSERT ON tab1 TO JohnC、GRANT ADD ON TABLE tab1 TO USER JohnD、GRANT INSERT ON TABLE tab1 TO USER John
While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as DBMGR gets the error message insufficient privileges. Which two commands would you use to resolve this error?()A、GRANT dba TO dbmgr;B、GRANT connect TO dbmgr;C、GRANT resource TO dbmgr;D、GRANT hs_admin_role TO dbmgr;E、GRANT manage scheduler TO dbmgr;
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;
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
Which of the following approval member groups can an organization administrator grant privileges to?()A、ApprovalGroupB、Order ProcessC、User GroupD、User RegistrationE、AccessGroup
How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?() A、 Issue the grant command from the SYS user (or equivalent) of the target database.B、 Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E、 Issue the grant command from RMAN when connected to the target database.
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 ONB、 GRANT SELECT any transaction TO scottC、 GRANT EXECUTE ON dbms_flashback TO scottD、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATAE、 ALTER TABLESPACE undots1 RETENTION GUARANTEEF、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()A、Alice onlyB、Alice and ReenaC、Alice, Reena, and TimberD、Sue, Alice, Reena, and Timber
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? ()(Choose four.)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;
You manage a domain controller that runs Windows Server 2008 R2 and the DNS Server server role. The DNS server hosts an Active Directory-integrated zone for your domain.You need to provide a user with the ability to manage records in the zone. The user must not be able to modify the DNS server settings. What should you do?()A、Add the user to the DNSUpdateProxy Global security group.B、Add the user to the DNSAdmins Domain Local security group.C、Grant the user permissions on the zone.D、Grant the user permissions on the DNS server.
Your company has an Exchange Server 2010 organization. A user named User1 is configured as a Delegate for a user named User2. You need to ensure that User1 can add User2 in the From field when sending email messages. Messages that contain User2 in the From field must display User2 as the message sender when recipients receive the messages. What should you do()? A、Remove User1 as a delegate, and then grant User1 Send As permissions to User2¯s mailboxB、Remove User1 as a delegate, and then grant User1 Send on Behalf permissions to User2¯s mailboxC、Create a Sharing policy, and then grant User1 Modify permissions to User2¯s mailboxD、Create a Sharing policy, and then grant User1 Full Mailbox permissions to User2¯s mailbox
You and Stephen are the desktop administrators for your company. You install a printer on your Windows XP Professional computer. You share this printer on the company network. You want to ensure that only members of the DTAdmins local group can use this printer, and that only you and Stephen can manage the printer and all print jobs. You also want to ensure that members of the DTAdmins local group can manage only their own print jobs. How should you configure security on this printer?() A、Grant Allow - Print permission to the DTAdmins group. Grant Allow - Manage Documents permission to your user account and to Stephen’s user account. B、Grant Allow - Print permission to the DTAdmins group. Grant Allow - Manage Documents and Allow - Manage Printers permissions to your user account and to Stephen’s user account. C、Grant Allow - Manage Documents permission to the DTAdmins group. Grant Allow - Manage Printers permission to your user account and to Stephen’s user account. D、Grant Allow - Print permission to the DTAdmins group. Remove Allow - Manage Documents permission from the Creator Owner group. Grant Allow - Manage Printers permission to your user account and to Stephen’s user account.
单选题The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()AAlice onlyBAlice and ReenaCAlice, Reena, and TimberDSue, Alice, Reena, and Timber
单选题How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?()A Issue the grant command from the SYS user (or equivalent) of the target database.B Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.C Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E Issue the grant command from RMAN when connected to the target database.
单选题You manage Hyper-V host servers and virtual machines (VMs) by using Microsoft System Center Virtual Machine Manager (VMM) 2008 R2. You grant a user the Delegated Administrator user role. You need to provide the user with the ability to manage VMs through the VMM Self-Service Portal. What should you do?()AIn VMM, grant the user the Self-Service user role.BIn VMM, grant the user the Administrator user role.CEnable the Integrated Windows Authentication option for the VMM Self-Service Portal.DEnable the Single sign-on for Terminal Services option for the VMM Self-Service Portal.
单选题The HR user creates a view with this command: SQL CREATE VIEW emp_v AS SELECT * FROM scott.emp; Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario?()AHR can grant the privilege to JIM but without GRANT OPTION.BHR can grant the privilege to JIM because HR is the owner of the view.CSCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.DHR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.
单选题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
单选题You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? ()ACREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3BCREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3CCREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3DCREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;ECREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;
单选题The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()AGRANT select ON dept TO ALL_ USER;BGRANT select ON dept TO ALL;CGRANT QUERY ON dept TO ALL_USERSDGRANT select ON dept TO PUBLIC;