152.Examine the command:

来源:互联网 发布:udp端口扫描器报告 编辑:程序博客网 时间:2024/05/17 04:11
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.
答案:AC
解析:
A:正确,用户锁定了,该用户肯定是无法登陆系统了
B:错误,只是锁定了用户,并不是用户下的对象
C:正确
D:错误,用户锁定和密码过期是两个概念,对应的语句也是两个
  alter user username identified by password --修改密码
  alter user username account unlock;  --解锁
  alter user username identified by hr account unlock; --我们也可以一行  
0 0
原创粉丝点击