单选题假设在数据库中已经创建了某个用户test,需要将其口令修改为oracle,可以使用如下()语句。AALTER USER test IDENTIFIED BY oracleBALTER USER test PASSWORD oracleCCREATE USER test IDENTIFIED BY oracleDUPDATE USER test IDENTIFIED BY oracle
单选题
假设在数据库中已经创建了某个用户test,需要将其口令修改为oracle,可以使用如下()语句。
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
参考解析
解析:
暂无解析
相关考题:
在Oracle中,将scott的资源文件改为otherprofile,下列哪个是正确的?( )A.ALTER PROFILE USER scott otherprofileB.ALTER otherprofile USER scottPROFILEC.ALTER USER scott PROFILE otherprofileD.ALTER scott USER PROFILE otherprofile
● 下列电子邮件地址正确的是(61) 。(61)A.mail.test.com@user B .user @ mail.test.comC .http://mail.test.com D.http: \\mail.test.com
● 下列电子邮件地址正确的是 (21) 。(21)A.mail.test.com@user B.user @ mail.test.comC.http://mail.test.com D.http: \\mail.test.com
Which statement creates a new user? () A. CREATIVE USER susan;B. CREATIVE OR REPLACE USER susan;C. CREATE NEW USER susan DEFAULTD. CREATE USER susan IDENTIFIED BY blue;E. CREATE NEW USER susan IDENTIFIED BY blue;F. CREATE OR REPLACE USER susan IDENTIFIED BY blue;
在Oracle中,用ALTER将scott的口令改为hello,下列哪个是正确的?( )A.ALTER USER scott IDENTIFIED BY helloB.ALTER scott USER IDENTIFIED BY helloC.ALTER USER scott IDENTIFIED AS helloD.ALTER USER hello IDENTIFIED BY scott
在Oracle中,使用了如下的语句创建用户TOM,则对于该用户而言,以下说法错误的是()。CREATE USER TOM IDENTIFIED BY TOMSYS A.该用户的口令为TOMSYSB.TOM默认为表空间为SYSTEMC.TOM的临时表空间为TEMPD.使ORANTUPDATE命令可以修改TOM的口令
假设在数据库中已经创建了某个用户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
假设需要在数据库中创建角色test_role,可以使用如下()语句。 A.ALTER DATABASE ROLE test_roleB.CREATE ROLE test_roleC.UPDATE ROLE test_roleD.ALTER ROLE test_role
假设在数据库中创建了用户test,需要为其授予CREATE ANY TABLE系统权限,可以使用如下()语句。 A.GRANT CREATE ANY TABLE testB.GRANT CREATE ANY TABLE TO testC.TAKE CREATE ANY TABLE TO testD.ALTER CREATE ANY TABLE TO test
假设数据库中创建了一个用户test,状态为锁定状态,需要使用SQL语句解除锁定,可以使用如下()语句。 A.ALTER USER test ACCOUNTB.ALTER USER test NOLOCKC.ALTER USER test ACCOUNT NOLOCKD.ALTER test ACCOUNT NOLOCK
更改oracle用户HR,使其变为不可用(锁定)状态()A、UPDATE USER HR ACCOUNT DISABLEB、UPDATE USER HR ACCOUNT LOCKC、ALTER USER HR ACCOUNT DISABLED、ALTER USER HR ACCOUNT LOCK
Which statement creates a new user?()A、CREATE USER susan;B、CREATE OR REPLACE USER susan;C、CREATE NEW USER susan DEFAULT;D、CREATE USER susan IDENTIFIED BY blue;E、CREATE NEW USER susanIDENTIFIED by blue;F、CREATE OR REPLACE USER susan IDENTIFIED BY blue;
假设需要在数据库中创建角色test_role,可以使用如下()语句。A、ALTER DATABASE ROLE test_roleB、CREATE ROLE test_roleC、UPDATE ROLE test_roleD、ALTER ROLE test_role
Which statement creates a new user?()A、CREATIVE USER susan;B、CREATIVE OR REPLACE USER susan;C、CREATE NEW USER susan DEFAULTD、CREATE USER susan IDENTIFIED BY blue;E、CREATE NEW USER susan IDENTIFIED BY blue;F、CREATE OR REPLACE USER susan IDENTIFIED BY blue;
假设在数据库中创建了用户test,需要为其授予CREATE ANY TABLE系统权限,可以使用如下()语句。A、GRANT CREATE ANY TABLE testB、GRANT CREATE ANY TABLE TO testC、TAKE CREATE ANY TABLE TO testD、ALTER CREATE ANY TABLE TO test
假设数据库中创建了一个用户test,状态为锁定状态,需要使用SQL语句解除锁定,可以使用如下()语句。A、ALTER USER test ACCOUNTB、ALTER USER test NOLOCKC、ALTER USER test ACCOUNT NOLOCKD、ALTER test ACCOUNT NOLOCK
在Oracle中,使用了如下的语句创建用户TOM,则对于该用户而言,以下说法错误的是()。 CREATE USER TOM IDENTIFIED BY TOMSYSA、该用户的口令为TOMSYSB、TOM默认为表空间为SYSTEMC、TOM的临时表空间为TEMPD、使ORANTUPDATE命令可以修改TOM的口令
假设在数据库中已经创建了某个用户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
CREATE TABLE test(t_idINT,t_nmae CHAR(10))后,增加t_sex字段,以下语句正确的是()。A、ALTER TABLE test ADD t_sex CHAR(2)B、ALTER TABLE test ADD t_sexC、ALTER TABLE test ALTER t_sex CHAR(2)D、ALTER TABLE test DROP(t_sex CHAR(2))
单选题假设数据库中创建了一个用户test,状态为锁定状态,需要使用SQL语句解除锁定,可以使用如下()语句。AALTER USER test ACCOUNTBALTER USER test NOLOCKCALTER USER test ACCOUNT NOLOCKDALTER test ACCOUNT NOLOCK
单选题假设在数据库中已经创建了某个用户test,需要将其口令修改为oracle,可以使用如下()语句。AALTER USER test IDENTIFIED BY oracleBALTER USER test PASSWORD oracleCCREATE USER test IDENTIFIED BY oracleDUPDATE USER test IDENTIFIED BY oracle
单选题假设在数据库中创建了用户test,需要为其授予CREATE ANY TABLE系统权限,可以使用如下()语句。AGRANT CREATE ANY TABLE testBGRANT CREATE ANY TABLE TO testCTAKE CREATE ANY TABLE TO testDALTER CREATE ANY TABLE TO test
单选题在Oracle中,使用了如下的语句创建用户TOM,则对于该用户而言,以下说法错误的是()。 CREATE USER TOM IDENTIFIED BY TOMSYSA该用户的口令为TOMSYSBTOM默认为表空间为SYSTEMCTOM的临时表空间为TEMPD使ORANTUPDATE命令可以修改TOM的口令