加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

2018版OCP 11g 052最新考试题库整理(带答案)(44)

发布时间:2020-12-12 13:46:17 所属栏目:百科 来源:网络整理
导读:44、In one of your databases: The database default tablespace is EXAMPLE. Deferred_segment_creation is false. Examine these commands: SQL create user user1 identified by oracle_4u password expire; User created. SQL alter user user1 account
44、In one of your databases:

  • The database default tablespace is EXAMPLE.

  • Deferred_segment_creation is false.

Examine these commands:

SQL> create user user1 identified by oracle_4u password expire;

User created.

SQL> alter user user1 account unlock;

User altered.

SQL>grant create session to user1;

Grant succeeded.

SQL> grant create table to user1 with admin option;

Grant succeeded.

Which three are true?

A. user1 can log in to the database instance.

B. user1 can grant the create table privilege to other users.

C. user1 can create tables in the example tablespace.

D. user1 must change it’s password at first login.

E. user1 can create indexes in example tablespace.

Correct Answer: ABD

北京CUUG整理,转载请注明,OCP讨论群:569933648/836361015

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读