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

OCP题库变了,2018新版052考题及答案整理-29题

发布时间:2020-12-12 13:28:16 所属栏目:百科 来源:网络整理
导读:29、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
29、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.

14、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

(编辑:李大同)

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

    推荐文章
      热点阅读