多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

You have been asked to create three users, PUB1, PUB2 and PUB3, for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users, which method can you use for granting the required privileges?()

  • A、grant CONNECT role to all of the three users
  • B、grant RESOURCE role to all of the three users
  • C、grant both CONNECT and RESOURCE role to all of the three users
  • D、execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
  • E、create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题