OCP-052考试题库汇总（62）-CUUG内部解答版

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;

User created.

SQL>GRANT CREATE SESSION TO user1;

User altered

Which two are true?

A)USER1 can create tables in EXAMPLE tablespace

B)USER1 must change their password at first login

C)USER1 can create tables in the EXAMPLE tablespace

D)USER1 can be granted access to tables in other schemas

E)USER1 can login to the database instance.

Answer: DE

赵：

D 译：可以授予 USER 1 访问其他模式中的表的权限。

AC 错，没有授权表空间的配额。B 错，设置密码时并没有使用 EXPIRE 关键字。