OCP11g+12c考试资料群:1015267481 验证码:ocp

OCP题库变了,2018年052新题库-29题

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

posted @ 2018-07-31 13:26  cnblogs_5359  阅读(353)  评论(0编辑  收藏  举报