Oracle認(rèn)證綜合練習(xí)章節(jié)練習(xí)(2019.12.03)

A.%NOTFOUND
B.%FOUND
C.%ISCLOSE
D.%ISOPEN

A.授予了CONNECT的角色，但沒有授予RESOURCE的角色
B.沒有授予用戶系統(tǒng)管理員的角色
C.數(shù)據(jù)庫實(shí)例沒有啟動(dòng)
D.數(shù)據(jù)庫監(jiān)聽沒有啟動(dòng)

A.正斜杠(/)
B.反斜杠(\)
C.感嘆號(hào)(!)
D.句號(hào)(.)
E.以上所述都不正確

A.ALTER TABLE CUSTOMER RENAME CUSTOMER_CHANGE
B.ALTER TABLE CUSTOMER RENAME TO CUSTOMER_CHANGE
C.RENAME TABLE CUSTOMER TO CUSTOMER_CHANGE
D.RENAME TABLE CUSTOMER CUSTOMER_CHANGE

A.MAX
B.SUM
C.COUNT
D.AVG

A.SQL*Plus
B.Oracle Net
C.Oracle Listner
D.Oracle Database Configuration Assistant

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.CONNECT SYS/password SYSDBA
B.CONNECT SYS/password AS SYSDBA
C.CONNECT AS SYSDBA SYS/password
D.CONNECT DBA SYS/password

A.從SELECT語句調(diào)用的函數(shù)均不能修改數(shù)據(jù)庫表
B.函數(shù)可以帶有IN、OUT等模式的參數(shù)
C.函數(shù)的返回值必須是數(shù)據(jù)庫類型，不得使用PL/SQL類型
D.形式參數(shù)必須使用數(shù)據(jù)庫類型，不得使用PL/SQL類型

A.DELETE
B.REVOKE
C.INSERT
D.UPDATE