151.View the Exhibit1, which shows the options that are selected to create the user SL_REP.
Which two statements are true regarding this user? (Choose two.)
A.The user is authenticated by the operating system.
B.The objects created by the user are placed in the USERS tablespace.
C.The user does not require quota on the TEMP tablespace to perform sort operations.
D.The user is forced to change the password at the first login to the database instance.
E.The objects created by the user in future are unlocked to be accessed by all the users in the database by default.
答案:BC
解析:
A:错误,图1中显示的是密码认证
B:正确,图1种没有指定用户的默认表空间,那么就在 数据库的默认表空间,从图2中可以看出默认表空间为users
C:正确,这里说的是排序的是后不需要指定临时表空间,已经指定了用户的临时表空间了,临时表空间就是用来排序的
D:错误,这里没有勾选,expire password now,因此新创建的用户第一次登陆的时候不会过期,如果这里通过命令创建的话,使用下面的语法
create user user_name identified {
by password | --设置的密码
externally| --操作系统检测机制,需要修改参数文件中参数的配置,还需要修改操作系统的检测机制
globally as external name}
[default tablespace default_tablespace]
[temporary tablespace temporary_tablespace]
[quota {正整数 [k|m]|unlimited} on 表空间名
[quota {正整数 [k|m]|unlimited} on 表空间名]...]
[password expire] --第一次登陆就过期
[account {lock|unlock}]
[profile {概要文件名|default]
E:这里说的是权限问题了,图1种的unlock指的是用户没有锁,并不是用户下的对象