在Oracle中,将scott的资源文件改为otherprofile,下列哪个是正确的?()
A.ALTER PROFILE USER scott otherprofile
B.ALTER otherprofile USER scottPROFILE
C.ALTER USER scott PROFILE otherprofile
D.ALTER scott USER PROFILE otherprofile
第1题
A.LTER PROFILE USER scott otherprofile
B.LTER otherprofile USER scottPROFILE
C.LTER USER scott PROFILE otherprofile
D.LTER scott USER PROFILE otherprofile
第2题
在Oracle中,将scott的缺省表空间改为data2_ts,下列哪个是正确的?()
A、ALTER USER scott DEFAULT TABLESPACE data2_ts
B、ALTER DEFAULT TABLESPACE data2_ts USER scott
C、ALTER USER scott TABLESPACE DEFAULT data2_ts
D、ALTER scott USER DEFAULT TABLESPACE data2_ts
第3题
在Oracle中,用ALTER将scott的口令改为hello,下列哪个是正确的?()
A.ALTER USER scott IDENTIFIED BY hello
B.ALTER scott USER IDENTIFIED BY hello
C.ALTER USER scott IDENTIFIED AS hello
D.ALTER USER hello IDENTIFIED BY scott
第5题
A.LTER USER scott IDENTIFIED BY hello
B.LTER scott USER IDENTIFIED BY hello
C.LTER USER scott IDENTIFIED AS hello
D.LTER USER hello IDENTIFIED BY scott
第6题
在Oracle中,将当前系统所有角色都授予scott,除Payroll外,下列哪个是正确的?()
A、ALTER DEFAULT ROLLE USER scott ALL EXCEPT Payroll
B、ALTER USER DEFAULT ROLLE ALL EXCEPT Payroll
C、ALTER DEFAULT ROLLE ALL EXCEPT USER scott
D、ALTER USER scott DEFAULT ROLLE ALL EXCEPT Payroll
第7题
A.LTER USER scott DEFAULT TABLESPACE data2_ts
B.LTER DEFAULT TABLESPACE data2_ts USER scott
C.LTER USER scott TABLESPACE DEFAULT data2_ts
D.LTER scott USER DEFAULT TABLESPACE data2_ts
第9题
A、ALTER USER scott TEMPORARY TABLESPACE temp2_ts
B、ALTER TEMPORARY TABLESPACE USER scott temp2_ts
C、ALTER USER scott temp2_ts TEMPORARY TABLESPACE
D、ALTER scott USER TEMPORARY TABLESPACE temp2_ts
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!