单选题假设在数据库中已经创建了某个用户test，需要将其口令修改为oracle，可以使用如下（）语句。A ALTER USER test IDENTIFIED BY oracleB ALTER USER test PASSWORD oracleC CREATE USER test IDENTIFIED BY oracleD UPDATE USER test IDENTIFIED BY oracle

● 下列电子邮件地址正确的是 （21） 。

（21）A.mail.test.com@user B.user @ mail.test.com

C.http://mail.test.com D.http: \\mail.test.com

在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

在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

A.GRANT CREATE ANY TABLE test

B.GRANT CREATE ANY TABLE TO test

C.TAKE CREATE ANY TABLE TO test

D.ALTER CREATE ANY TABLE TO test

A.ALTER USER test IDENTIFIED BY oracle

B.ALTER USER test PASSWORD oracle

C.CREATE USER test IDENTIFIED BY oracle

D.UPDATE USER test IDENTIFIED BY oracle

A. CREATIVE USER susan;

B. CREATIVE OR REPLACE USER susan;

C. CREATE NEW USER susan DEFAULT

D. CREATE USER susan IDENTIFIED BY blue;

E. CREATE NEW USER susan IDENTIFIED BY blue;

F. CREATE OR REPLACE USER susan IDENTIFIED BY blue;

A.该用户的口令为TOMSYS

B.TOM默认为表空间为SYSTEM

C.TOM的临时表空间为TEMP

D.使ORANTUPDATE命令可以修改TOM的口令

● 下列电子邮件地址正确的是（61） 。

（61）A．mail.test.com@user B ．user @ mail.test.com

C ．http://mail.test.com D．http: \\mail.test.com

A.ALTER DATABASE ROLE test_role

B.CREATE ROLE test_role

C.UPDATE ROLE test_role

D.ALTER ROLE test_role

A.DELETE USER test

B.DROP USER test

C.DROP test

D.DELETE test