假设在数据库中已经创建了某个用户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
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.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 ACCOUNT
B.ALTER USER test NOLOCK
C.ALTER USER test ACCOUNT NOLOCK
D.ALTER test ACCOUNT NOLOCK
A.该用户的口令为TOMSYS
B.TOM默认为表空间为SYSTEM
C.TOM的临时表空间为TEMP
D.使ORANTUPDATE命令可以修改TOM的口令
A.TAKE BACK CREATE ANY TABLE FROM test
B.REVOKE CREATE ANY TABLE FROM test
C.REVOKE CREATE ANY TABLE test
D.TAKE BACK CREATE ANY TABLE test
A.仅仅创建一个数据库实例
B.创建了数据库实例并且挂载了数据库
C.创建了数据库实例,同时也创建了数据库
D.打开了数据库,但只能供系统用户访问
E.创建了数据库实例,并且以只读方式打开了数据库
A.set listner listner1
B.set current_listner listner1
C.alter current_listner listner1
D.alter system current_listner listner1
A.DELETE ROLE test_role
B.REVOKE ROLE test_role
C.DROP ROLE test_role
D.DELETE test_role