违法和不良信息举报 联系客服
免费注册 登录

单选题The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?（）A no privilegesB only the SELECT privilegeC only the CONNECT privilegeD all the privileges of a default user

题目
单选题
The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?（）
A

no privileges

B

only the SELECT privilege

C

only the CONNECT privilege

D

all the privileges of a default user

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

第1题：

The DBA issues this SQL command:CREATE USER scottIDENTIFIES by tiger;What privileges does the user Scott have at this point? ()

A. No privileges.

B. Only the SELECT privilege.

C. Only the CONNECT privilege.

D. All the privileges of a default user.


参考答案：A

第2题：

A redaction policy was added to the SAL column of the SCOTT.EMP table:All users have their default set of system privileges.For which three situations will data not be redacted?()

A. SYS sessions, regardless of the roles that are set in the session

B. SYSTEM sessions, regardless of the roles that are set in the session

C. SCOTT sessions, only if the MGR role is set in the session

D. SCOTT sessions, only if the MGR role is granted to SCOTT

E. SCOTT sessions, because he is the owner of the table

F. SYSTEM session, only if the MGR role is set in the session


参考答案：A, D, F

第3题：

The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?()

A. no privileges

B. only the SELECT privilege

C. only the CONNECT privilege

D. all the privileges of a default user


参考答案：A

第4题：

You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）

  • A、SYSDBA
  • B、SYSOPER
  • C、No system privileges are required for the RMAN user.
  • D、Only SYS user can connect and execute RMAN commands on a target database.

正确答案:A

第5题：

在Oracle中，将当前系统所有角色都授予scott，除Payroll外，下列哪个是正确的?()

A、ALTER DEFAULT ROLLE USER scott ALL EXCEPT Payroll

B、ALTER USER DEFAULT ROLLE ALL EXCEPT Payroll

C、ALTER DEFAULT ROLLE ALL EXCEPT USER scott

D、ALTER USER scott DEFAULT ROLLE ALL EXCEPT Payroll


参考答案：D

第6题：

The DBA issues this SQL command:What privileges does the user Scott have at this point?()

A. No privileges.

B. Only the SELECT privilege.

C. Only the CONNECT privilege.

D. All the privileges of a default user.


参考答案：A

第7题：

在Oracle中，用ALTER将scott的口令改为hello，下列哪个是正确的？（ ）

A.ALTER USER scott IDENTIFIED BY hello

B.ALTER scott USER IDENTIFIED BY hello

C.ALTER USER scott IDENTIFIED AS hello

D.ALTER USER hello IDENTIFIED BY scott


正确答案：A

第8题：

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


参考答案：C

第9题：

The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following  GRANT command：  GRANT ALL   ON orders， order_items   TO PUBLIC；   What correction needs to be done to the above statement？ （）

  • A、 PUBLIC should be replaced with specific usernames.
  • B、 ALL should be replaced with a list of specific privileges.
  • C、 WITH GRANT OPTION should be added to the statement.
  • D、 Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.

正确答案:D

第10题：

The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point?（）

  • A、No privileges.
  • B、Only the SELECT privilege.
  • C、Only the CONNECT privilege.
  • D、All the privileges of a default user.

正确答案:A

更多相关问题
相关内容