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;

查看正确答案

更多“The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?（）”相关的问题

第1题

[单选题] 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 only B、Alice and Reena C、Alice, Reena, and Timber D、Sue, Alice, Reena, and Timber

点击查看答案

第2题

A、Alice only B、Alice and Reena C、Alice, Reena, and Timber D、Sue, Alice, Reena, and Timber

点击查看答案

第3题

[] Your company network consists of a single Windows 2003 Active Directory domain. You are a member of the Domain Admins group. The network includes 10 member servers running Windows Server 2003 and 4 domain controllers running Windows Server 2003. The 200 client computers all run Windows XP Professional. The user accounts for employees in the Finance department are located in an Organisational Unit (OU) named Finance. The Finance OU also contains a Global Security group named FinanceUsers. All Finance employees are members of FinanceUsers. An employee named Alice works in the Finance department. Alice reports that she cannot log in the domain. She receives the error message shown in the exhibit: You need to enable Alice to log in to the domain. What should you do?（） Your company network consists of a single Windows 2003 Active Directory domain. You are a member of the

A、A. Use the dsmod user command line tool to enable Alice's user account. B、B. Use Active Directory Users and Computers to add Alice's user account to the Domain Users group. C、C. Use Active Directory Users and Computers to add Alice's user account to the Guests group. D、D. Use the net accounts command line tool to enable Alice's user account. E、E. Perform an authoritative restore of Alice's user account.

点击查看答案

第4题

[单选题] 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;

点击查看答案

第5题

[单选题] Users of your web application have requested that they should be able to set the duration of their sessions.So for example， one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes； another user might want to stay connected for a whole day. Furthermore， youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will&e

A、User user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））； B、User user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））； C、User user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））； D、User user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））； E、User user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；