OCP-1Z0-052-V8.02-152题

152. Examine the command:

SQL> ALTER USER skd ACCOUNT LOCK;

Which two statements are true after the command is executed? (Choose two.)

A.The SKD user cannot log in to the database instance.

B.The objects owned by the SKD user are not accessible to any user.

C.The other users can access the objects owned by the SKD user, on which they have access.

D.The password for the SKD user expires and the user is forced to change the password at the next log in.

Answer: AC

答案解析：

1、将scott用户上锁

sys@TEST0910> alter user scott account lock;

User altered.

2、不能连接到数据库，A正确。

下一次连接时，只是不能连接到数据库，但密码没有过期，也没有强制要求改变密码，D错误。

sys@TEST0910> conn scott/tiger

ERROR:

ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.

3、使用SYS用户可以访问到scott用户的表，C正确，B错误

sys@TEST0910> conn /as sysdba

Connected.

sys@TEST0910> select * from scott.emp;

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO

---------- ---------- --------- ---------- --------- ---------- ---------- ----------

7369 SMITH CLERK 7902 17-DEC-80 800 20

7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30

7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30