oracle-10g-數(shù)據(jù)庫(kù)基礎(chǔ)教程課后習(xí)習(xí)題答案擇題(中文)

PAGE26第3章創(chuàng)建數(shù)據(jù)庫(kù)后臺(tái)進(jìn)程跟蹤文件的位置是（C）A．LOGFILE_DEST B．ORACLE_HOME

C．BACKGROUND_DUMP_DEST D．CORE_DUMP_DEST

手動(dòng)創(chuàng)建數(shù)據(jù)庫(kù)的第一步是（C）A．啟動(dòng)實(shí)例

B．啟動(dòng)SQL*Plus

以SYSDBA身份連接OracleC．查看系統(tǒng)的實(shí)例名D．創(chuàng)建參數(shù)文件關(guān)于控制文件以下正確的是（A）A．Oracle建議至少二個(gè)控制文件存放在二個(gè)磁盤分區(qū)B．Oracle建議至少二個(gè)控制文件存放在一個(gè)磁盤分區(qū)C．Oracle建議存放一個(gè)控制文件D．一個(gè)控制文件不足以運(yùn)行數(shù)據(jù)庫(kù)執(zhí)行CREATEDATABASE命令之前，應(yīng)該發(fā)出的命令是（B）A．STARTUPINSTANCE

B．STARTUPNOMOUNTC．STARTUPMOUNTD．以上都不是創(chuàng)建數(shù)據(jù)庫(kù)時(shí)，Oracle如何得知需要?jiǎng)?chuàng)建的控制文件信息（A）A．從初始化參數(shù)文件B．從CREATEDATABASE命令C．從環(huán)境變量D．從$ORACLE_HOME目錄名為<db_name>.ctl的文件哪個(gè)腳本文件創(chuàng)建數(shù)據(jù)字典視圖（A）A．B．C．D．創(chuàng)建數(shù)據(jù)庫(kù)時(shí)，DATAFILE子句能定義幾個(gè)數(shù)據(jù)文件（C）A．一個(gè)B．二個(gè)C．多個(gè)；僅一個(gè)屬于系統(tǒng)表空間D．多個(gè)；都屬于系統(tǒng)表空間誰(shuí)擁有數(shù)據(jù)字典（A）A．SYSB．SYSTEMC．DBAD．ORACLE在CREATEDATABASE命令中，非法子句是（B）

A．MAXLOGMEMBERSB．MAXLOGGROUPS

C．MAXDATAFILES

D．MAXLOGHISTORY創(chuàng)建一個(gè)數(shù)據(jù)庫(kù)至少需要幾個(gè)控制文件（A）

A．一個(gè)B．二個(gè)C．三個(gè)D．無(wú)第5章物理存儲(chǔ)結(jié)構(gòu)關(guān)于聯(lián)機(jī)重做日志，以下哪兩個(gè)說(shuō)法是正確的(BC)A．所有日志組的所有文件都是同樣大小B．一組中的所有成員文件都是同樣大小C．成員文件應(yīng)置于不同的磁盤D．回滾段大小決定成員文件大小DBA使用哪個(gè)命令顯示當(dāng)前歸檔狀態(tài)（A）A．ARCHIVELOGLIST

B．FROMARCHIVELOGSC．SELECT*FROMV$THREADD．SELECT*FROMARCHIVE_LOG_LIST創(chuàng)建一個(gè)數(shù)據(jù)庫(kù)需要多少個(gè)控制文件（A）A．1B．2C．3D．0將下句補(bǔ)充完整：控制文件的建議配置是（C）A．每數(shù)據(jù)庫(kù)一個(gè)控制文件B．每磁盤一個(gè)控制文件C．二個(gè)控制文件置于二個(gè)磁盤D．二個(gè)控制文件置于一個(gè)磁盤當(dāng)創(chuàng)建控制文件時(shí)，數(shù)據(jù)庫(kù)必須處于什么狀態(tài)（B）A．加載B．未加載C．打開D．受限哪個(gè)數(shù)據(jù)字典視圖顯示數(shù)據(jù)庫(kù)處于歸檔狀態(tài)（C）A.V$INSTANCEB．V$LOGC．V$DATABASED．V$THREAD把多路鏡像控制文件存于不同磁盤最大的好處是（B）A．?dāng)?shù)據(jù)庫(kù)性能提高B．防止失敗C．提高歸檔速度D．能并發(fā)訪問提高控制文件的寫入速度哪個(gè)文件用于記錄數(shù)據(jù)庫(kù)的改變，并且用于實(shí)例的恢復(fù)（B）A．ArchivelogfileB．RedologfileC．ControlfileD．Alertlogfile一個(gè)實(shí)例可以建立幾個(gè)歸檔進(jìn)程（C）A．5B．4C．10D．取決于操作系統(tǒng)定義歸檔目標(biāo)地址時(shí)，哪兩個(gè)參數(shù)不能一起使用（BC）A．LOG_ARCHIVE_DESTandLOG_ARCHIVE_DUPLEX_DESTB．LOG_ARCHIVE_DESTandLOG_ARCHIVE_DEST_1C．LOG_ARCHIVE_DESTandLOG_ARCHIVE_DEST_2D．以上都不是;可以指定所有的歸檔參數(shù)第6章邏輯存儲(chǔ)結(jié)構(gòu)段的集合稱為（C）A．區(qū)B．段C．表空間D．?dāng)?shù)據(jù)庫(kù)當(dāng)數(shù)據(jù)庫(kù)崩潰，何時(shí)使用回滾信息（C）A．在崩潰之前B．恢復(fù)完成之后C．?dāng)?shù)據(jù)庫(kù)重新打開之后、恢復(fù)之前D．?dāng)?shù)據(jù)庫(kù)崩潰后回滾信息不被使用數(shù)據(jù)字典表和視圖存儲(chǔ)在（B）A．USERS表空間B．SYSTEM表空間C．TEMPORARY表空間D．以上三個(gè)中任意PCTFREE與PCTUSED之和不應(yīng)超過(guò)（A）A．100B．50C．25D．10數(shù)據(jù)塊的哪三個(gè)部分合稱為塊頭部（C）A．表目錄、行目錄和行數(shù)據(jù)B．標(biāo)題、表目錄、空閑區(qū)C．表目錄、行目錄、標(biāo)題D．塊頭部、行數(shù)據(jù)、行頭部數(shù)據(jù)庫(kù)打開時(shí)，以下哪個(gè)表空間必須聯(lián)機(jī)（A）A．SYSTEM

B．TEMPORARY

C．ROLLBACK

D．USERS指定哪個(gè)表空間參與排序操作，可以提高排序效率BA．SYSEM

B．TEMPORARY

C．ROLLBACK

D．USERS

臨時(shí)表空間中用于排序的段是何時(shí)創(chuàng)建的（A）A．排序操作開始的時(shí)候

B．臨時(shí)表空間創(chuàng)建的時(shí)候

C．當(dāng)排序操作需要內(nèi)存操過(guò)1KB的時(shí)候。

D．上述所有選項(xiàng)。以下哪個(gè)段是自管理的（C）A．TEMPORARY

B．ROLLBACK

C．CACHE

D．INDEX如果未定義臨時(shí)表空間，哪一個(gè)會(huì)作為默認(rèn)的臨時(shí)表空間（D）A．ROLLBACK

B．USERS

C．INDEX

D．SYSTEM

回滾段的作用是（D）A．?dāng)?shù)據(jù)的讀一致性 B．事務(wù)回滾

C．?dāng)?shù)據(jù)庫(kù)恢復(fù) D．以上都是回滾段存儲(chǔ)（A）A．事務(wù)修改的數(shù)據(jù)原值B．事務(wù)修改的數(shù)據(jù)新值C．事務(wù)修改的數(shù)據(jù)原值和新值D．以上都不是第7章數(shù)據(jù)庫(kù)實(shí)例Oracle實(shí)例是（D）A．Oracle內(nèi)存結(jié)構(gòu) B．OracleI/O結(jié)構(gòu)C．Oracle后臺(tái)進(jìn)程 D．以上都是SGA區(qū)包括（D）A．?dāng)?shù)據(jù)高速緩沖區(qū) B．共享池 C．重做日志緩沖區(qū) D．以上都是最近使用過(guò)的SQL語(yǔ)句存儲(chǔ)在（B）A．共享池 B．?dāng)?shù)據(jù)高速緩沖區(qū) C．私有全局區(qū)D．用戶全局區(qū)以下哪個(gè)不是Oracle后臺(tái)服務(wù)進(jìn)程（B）A．DBWR B．DBCM C．LGWR D．SMON以下哪個(gè)是合法的Oracle后臺(tái)服務(wù)進(jìn)程（D）A．ARCH B．LGWR C．DBWR D．以上都是將修改過(guò)的數(shù)據(jù)塊寫入數(shù)據(jù)文件的進(jìn)程是（A）

A．DBWR B．LGWR C．PMON D．SMON已提交的事務(wù)所做的改變由哪個(gè)進(jìn)程記錄（D）A．DBWR B．SMON C．CKPT D．以上都不是Oracle事務(wù)提交即（B）A．?dāng)?shù)據(jù)由DBWR進(jìn)程寫入磁盤文件B．LGWR進(jìn)程成功寫入日志C．PMON進(jìn)程提交D．SMON進(jìn)程寫數(shù)據(jù)回收表空間碎片的進(jìn)程是___________（B）A．PMON B．SMON

C．DBWR

D．ARCH管理用戶會(huì)話連接的進(jìn)程是______________（A）PMON B．SMON C．SERV D．NET8第8章數(shù)據(jù)庫(kù)啟動(dòng)與關(guān)閉實(shí)例啟動(dòng)時(shí)數(shù)據(jù)庫(kù)所處的狀態(tài)是（C）A．MOUNT

B．OPEN

C．NOMOUNTD．None數(shù)據(jù)庫(kù)啟動(dòng)時(shí)，如果一個(gè)數(shù)據(jù)文件或日志文件不可用，會(huì)出現(xiàn)什么結(jié)果（B）A．Oracle返回警告信息并打開數(shù)據(jù)庫(kù)。B．Oracle

返回警告信息，不打開數(shù)據(jù)庫(kù)。C．Oracle

返回警告信息，并進(jìn)行數(shù)據(jù)庫(kù)恢復(fù)。D．Oracle忽略不可用的文件。受限會(huì)話的系統(tǒng)權(quán)限應(yīng)授予哪些用戶（B）A．在客戶端與服務(wù)器之間通過(guò)SQL*NET

或NET8傳輸數(shù)據(jù)，需要特別安全保護(hù)的用戶。B．執(zhí)行數(shù)據(jù)導(dǎo)入、導(dǎo)出的DBA用戶。C．上面兩類用戶都包括。D．上面幾項(xiàng)都不正確。啟動(dòng)數(shù)據(jù)庫(kù)時(shí)，如果一個(gè)或多個(gè)CONTROL_FILES參數(shù)指定的文件不存在或不可用，會(huì)出現(xiàn)什么樣的結(jié)果（A）A．Oracle返回警告信息，但不加載數(shù)據(jù)庫(kù)。B．Oracle返回警告信息，并加載數(shù)據(jù)庫(kù)。C．Oracle忽略不可用的控制文件。D．Oracle

返回警告信息，并進(jìn)行數(shù)據(jù)庫(kù)恢復(fù)。Bob試圖正常關(guān)閉數(shù)據(jù)庫(kù)，Oracle說(shuō)實(shí)例處于空閑狀態(tài)，他試圖啟動(dòng)數(shù)據(jù)庫(kù)，Oracle說(shuō)數(shù)據(jù)庫(kù)已啟動(dòng)，Bob最好使用什么命令強(qiáng)制關(guān)閉數(shù)據(jù)庫(kù)（B）A．NORMAL

B．ABORT

C．IMMEDIATE

D．NONE

Tom發(fā)出啟動(dòng)數(shù)據(jù)庫(kù)的命令，實(shí)例和數(shù)據(jù)庫(kù)經(jīng)過(guò)怎樣的過(guò)程最終打開（B）A．OPEN,

NOMOUNT,

MOUNTB．NOMOUNT,

MOUNT,

OPEN

C．NOMOUNT,

OPEN,

MOUNT

D．MOUNT,

OPEN,

NOMOUNT

Diane是一個(gè)新DBA，當(dāng)數(shù)據(jù)庫(kù)服務(wù)器正在運(yùn)行時(shí)她發(fā)出了關(guān)閉數(shù)據(jù)庫(kù)的命令，等一會(huì)兒，她發(fā)現(xiàn)Oracle正在等待所有用戶主動(dòng)斷開，她使用的是哪一個(gè)關(guān)閉命令（A）NORMAL

B．ABORT

C．IMMEDIATE

D．NONE

下面哪個(gè)腳本文件用于創(chuàng)建數(shù)據(jù)字典視圖BA．A．

B．

C．

D．

為了執(zhí)行一次完整的數(shù)據(jù)庫(kù)介質(zhì)恢復(fù)操作，數(shù)據(jù)庫(kù)必須處于那種狀態(tài)（B）A．處于Mount狀態(tài)，并且使用RESETLOG方式打開數(shù)據(jù)庫(kù)。B．處于Mount狀態(tài)，但不打開數(shù)據(jù)庫(kù)。C．處于Mount狀態(tài)，并且使用

ARCHIVELOG方式打開數(shù)據(jù)庫(kù)。D．

不能執(zhí)行完整的數(shù)據(jù)庫(kù)介質(zhì)恢復(fù)操作。數(shù)據(jù)庫(kù)啟動(dòng)過(guò)程中哪一步讀取初始化參數(shù)文件（C）數(shù)據(jù)庫(kù)打開數(shù)據(jù)庫(kù)加載實(shí)例啟動(dòng)每個(gè)階段第9章模式對(duì)象（1）用于刪除約束的命令是哪一個(gè)（C）A．ALTERTABLEMODIFYCONSTRAINTB．DROPCONSTRAINTC．ALTERTABLEDROPCONSTRAINTD．ALTERCONSTRAINTDROP（2）哪個(gè)不是ROWID的組成部分（A）A．表空間B．文件編號(hào)C．對(duì)象編號(hào)D．塊內(nèi)行號(hào)（3）唯一值約束和主鍵約束的區(qū)別是什么（D）

A．唯一值約束建立唯一索引、主碼約束建立非唯一索引

B．主碼列可以為空、唯一值約束的列不可以為空

C．主碼約束可以使用已有的索引、唯一值約束總是創(chuàng)建索引

D．唯一值約束的列可以為空、主碼列不可以為空（4）什么是模式（B）A．?dāng)?shù)據(jù)庫(kù)對(duì)象的物理組織結(jié)構(gòu)B．?dāng)?shù)據(jù)庫(kù)對(duì)象的邏輯組織結(jié)構(gòu)C．索引模式D．以上都不是（5）選擇兩個(gè)正確的答案，當(dāng)創(chuàng)建一個(gè)表時(shí)：（AB）A．直接路徑加載使用SQL*Loader實(shí)用程序不會(huì)記錄在重做日志文件。B．直接加載不記錄在重做日志文件。C．表的插入和更新操作不記錄在重做日志文件。D．常規(guī)路徑加載使用SQL*Loader實(shí)用程序不會(huì)記錄在重做日志文件。（6）位圖索引適合建于怎樣的列（A）A．索引基數(shù)高B．索引基數(shù)低C．插入率高D．修改率高（7）選擇2個(gè)可以被PUBLIC用戶組擁有的模式對(duì)象。（AC）A．?dāng)?shù)據(jù)庫(kù)鏈接B．回滾段

C．同義詞D．表（8）ALTERTABLE命令不能用于（D）A．將一個(gè)表移動(dòng)到其他的表空間中B．修改表的初始分區(qū)大小C．修改表名D．禁用觸發(fā)器（9）哪個(gè)約束不會(huì)自動(dòng)建立索引（B）A．主碼B．外碼C．唯一（10）哪個(gè)不是建立分區(qū)表的方法（C）

A．范圍B．列表C．函數(shù)D．散列 第10章安全管理創(chuàng)建用戶命令中DEFAULTTABLESPACE子句指定_______的位置。（A）用戶創(chuàng)建的數(shù)據(jù)庫(kù)對(duì)象用戶創(chuàng)建的臨時(shí)對(duì)象用戶創(chuàng)建的系統(tǒng)對(duì)象以上都不是資源文件中SESSIONS_PER_USER限制了什么（B）數(shù)據(jù)庫(kù)的并發(fā)會(huì)話數(shù)量每用戶會(huì)話數(shù)量每用戶進(jìn)程數(shù)量以上都不是哪個(gè)參數(shù)限制用戶在斷開前的最大空閑時(shí)間（A）A．IDLE_TIME

B．DISCONNECT_TIME

C．CONNECT_TIME

D．以上都不是使用ALTERUSER命令時(shí)，以下哪個(gè)子句有錯(cuò)誤（A）A．ADD

QUOTA

5MB．IDENTIFIEDBYuseraC．DEFAULTTABLESPACESYSTEM

D．以上都不是哪個(gè)視圖包含所有概要文件的資源使用參數(shù)（B）A．DBA_PROFILE

B．DBA_PROFILES

C．DBA_USERS

D．DBA_RESOURCES

以下哪個(gè)不是系統(tǒng)權(quán)限（A）A．SELECTB．UPDATEANYC．CREATEVIEWD．CREATESESSION創(chuàng)建用戶的命令中哪個(gè)子句限制用戶對(duì)象在數(shù)據(jù)庫(kù)占用的空間（D）A．Size

B．NEXT_EXTENT

C．MAX_EXTENTS

D．QUOTA對(duì)表空間配額的分配限制了哪個(gè)操作（C）A．UPDATE

B．DELETE

C．CREATE

D．以上都是概要文件不能限制________。（D）A．CPU占用時(shí)間B．最大數(shù)據(jù)庫(kù)連接時(shí)間C．最大會(huì)話空閑時(shí)間D．讀取數(shù)據(jù)塊時(shí)間以下哪個(gè)不是角色（D）A．CONNECTB．DBAC．RESOURCED．CREATESESSION第13章SQL語(yǔ)言基礎(chǔ)（1）哪個(gè)單行函數(shù)能夠得到字符串的一部分（B）A．INSERT

B．SUBSTRC．LPADD．LEAST（2）哪個(gè)函數(shù)接受任何類型的參數(shù)，可以多選。（BD）A．SUBSTRB．NVLC．ROUNDD．DECODEE．SIGN（3）SIGN（ABS(NVL(-23,0))）的返回值是（A）A．1B．32C．-1D．0E．NULL（4）哪個(gè)函數(shù)能返回字符串的首字符，選擇2個(gè)。（AB）A．LTRIMB．SUBSTRC．RTRIMD．INSERTE．MOD（5）哪行代碼有錯(cuò)誤（C）A．SELECTdname,ename

B．FROMempe,deptdC．WHERE=

D．ORDERBY1,2（6）哪個(gè)語(yǔ)句不會(huì)建立隱式事務(wù)（E）A．INSERTB．UPDATEC．DELETED．SELECTFORUPDATEE．以上語(yǔ)句都會(huì)建立隱式事務(wù)（7）以下查詢語(yǔ)句是哪種連接（D）SELECTdname，enameFROMdeptd，empeWHERE=ORDERBYdname，ename;自連接B．等值連接C．外連接D．不等值連接（8）使用多表查詢時(shí)，在哪個(gè)子句指定多個(gè)表的名字（D）A．HAVINGB．GROUPBYC．WHERED．FROM（9）這兩個(gè)操作不允許使用外部聯(lián)接兩個(gè)表之間（AC）A．ORB。ANDC。ANDD。=（10）如果查詢表A(有3行數(shù)據(jù))和表B（有4行數(shù)據(jù)），使用select*froma,b，返回的查詢結(jié)果有多少行（D）A．7B．1C．0D．12（11）你需要把NEW_CUST表中的新客戶信息導(dǎo)入CUST和CUST_SPECIAL表，如果客戶信譽(yù)度大于10000，需要導(dǎo)入CUST_SPECIAL表，所有新客戶信息都要導(dǎo)入CUST表，使用哪種技術(shù)可以盡快完成導(dǎo)入（D）A．外部表B．MERGE命令C．INSERT多表插入命令D．帶有WITHCHECKOPTION子句的INSERT命令（12）關(guān)于以下SQL語(yǔ)句的作用正確的說(shuō)法是（B）ALTERTABLESETUNUSED(mgr_id)?A．EMP表上的同義詞需要被重建B．MGR_ID列上的約束都被取消C．任何包含MGR_ID列的視圖都必須刪除和重建D．MGR_ID列的索引仍然有效直到執(zhí)行DROPUNUSEDCOLUMNS命令（13）什么情況下在GROUPBY子句中使用ROLLUP（C）A．對(duì)每組進(jìn)行橫向統(tǒng)計(jì)和不分組統(tǒng)計(jì)B．對(duì)GROUPBY指定的列進(jìn)行分組智能統(tǒng)計(jì)C．對(duì)GROUPBY指定的列從右到左分組統(tǒng)計(jì)D．對(duì)GROUPBY指定的列進(jìn)行橫向和縱向分組統(tǒng)計(jì)（14）關(guān)于子查詢以下哪兩種說(shuō)法是正確的（AD）外層查詢返回結(jié)果之后，執(zhí)行內(nèi)層查詢先執(zhí)行子查詢，再執(zhí)行外層查詢對(duì)于子查詢返回的結(jié)果，外層查詢只執(zhí)行一次外層查詢返回的每行結(jié)果都與內(nèi)層查詢結(jié)果進(jìn)行比較（15）OE和SCOTT是數(shù)據(jù)庫(kù)用戶，ORDERS表被OE所擁有。DBA執(zhí)行以下操作會(huì)導(dǎo)致：(B)CREATEROLEr1?GRANTSELECT,INSERTONTOr1?GRANTr1TOscott?GRANTSELECTONTOscott?REVOKESELECTONFROMscott?SCOTT能查詢；SCOTT不能查詢；REVOKE命令回收了SCOTT和R1的SELECT權(quán)限；REVOKE命令會(huì)發(fā)生錯(cuò)誤，因?yàn)镾ELECT權(quán)限已被授予R1。（16）empdet包含外部表empno和ename列。該命令將關(guān)系到empdet表工作(C)外部數(shù)據(jù)表都是只讀的，因此在外部表不能夠執(zhí)行DML操作，也不能創(chuàng)建索引A.UPDATEempdetSETename='Amit'WHEREempno=1234;B.DELETEFROMempdetWHEREenameLIKE'J%';C.CREATEVIEWempvuASSELECT*FROMempdept;D.CREATEINDEXempdet_idxONempdet(empno);ViewtheExhibitandexaminethedatainthePROMOTIONStablePROMOBEGINDATEisstoredinthedefaultdateformat,dd-mon-rrYouneedtoproduceareportthatprovidesthename,cost,andstartdateofallpromosinthePOSTcategorythatwerelaunchedbeforeJanuary1,2000WhichSQLstatementwouldyouuseA.SELECTpromo_name,promo_cost,promo_begin_dateFROMpromotionsWHEREpromo_category='post'ANDpromo_begin_date<'01-01-00';B.SELECTpromo_name,promo_cost,promo_begin_dateFROMpromotionsWHEREpromo_costLIKE'post%'ANDpromo_begin_date<'01-01-2000';C. SELECTpromo_name,promo_cost,promo_begin_dateFROMpromotionsWHEREpromo_categoryLIKE'P%'ANDpromo_begin_date<'l-JANUARY-00';D. SELECTpromo_name,promo_cost,promo_begin_dateFROMpromotionsWHEREpromo_categoryLIKE'%post%'ANDpromo_begin_date<'l-JAN-00';Answer:DWhichstatements/commandswouldnotcauseatransactiontoendBA.COMMITB.SELECTC.CREATED.ROLLBACKWhichtwostatementsarenottrueregardingconstraintsDA.AforeignkeycancontainNULLvaluesB.AcolumnwiththeUNIQUEconstraintcancontainNULLvaluesC.AconstraintcanbedisabledeveniftheconstraintcolumncontainsdataconstraintscanbedefinedatthecolumnlevelaswellasthetablelevelWhichstatementarenottrueregardingtheORDERBYclauseBA.ItmustbethelastclauseintheSELECTstatementB.ItcannotbeusedinaSELECTstatementcontainingaHAVINGclauseC.YoucanspecifyacolumnnamefollowedbyanexpressioninthisclauseD.YoucanspecifyacombinationofnumericpositionsandcolumnnamesinthisclauseWhichstatementistrueregardingthedefaultbehavioroftheORDERBYclauseAA.Inacharactersort,thevaluesarecase-sensitiveB.NULLvaluesarenotconsideredatallbythesortoperationC.OnlythosecolumnsthatarespecifiedintheSELECTlistcanbeusedintheORDERBYclauseD.NumericvaluesaredisplayedfromthemaximumtotheminimumvalueiftheyhavedecimalpositionsWhichthreestatementsarenottrueregardingsubqueriesCA.SubqueriescancontainGROUPBYandORDERBYclausesB.MainqueryandsubquerycangetdatafromdifferenttablesC.MainqueryandsubquerymustgetdatafromthesametablesD.MultiplecolumnsorexpressionscanbecomparedbetweenthemainqueryandsubqueryWhichstatementistrueregardingsynonymsCA.SynonymscanbecreatedonlyforatableB.SynonymsareusedtoreferenceonlythosetablesthatareownedbyanotheruserC.ApublicsynonymandaprivatesynonymcanexistwiththesamenameforthesametableD.TheDROPSYNONYMstatementremovesthesynonym,andthetableonwhichthesynonymhasbeencreatedbecomesinvalidViewtheExhibitandexaminethestructureofthePROMOTIONStableYouneedtogenerateareportofallpromosfromthePROMOTIONStablebasedonthefollowingconditions:1.Thepromonameshouldnotbeginwith'T'or'N'2.Thepromoshouldcostmorethan$200003.Thepromoshouldhaveendedafter1stJanuary2001WhichWHEREclausewouldgivetherequiredresult（C）A. WHEREpromo_nameNOTLIKE'T%'ORpromo_nameNOTLIKE'N%'ANDpromo_cost>20000ANDpromo_end_date>'l-JAN-0l'B. WHERE(promo_nameNOTLIKE'T%'ANDpromo_nameNOTLIKE'N%')ORpromo_cost>20000ORpromo_end_date>'l-JAN-0l'C. WHEREpromo_nameNOTLIKE'T%'ANDpromo_nameNOTLIKE'N%'ANDpromo_cost>20000ANDpromo_end_date>'l-JAN-0l'D. WHERE(promo_nameNOTLIKE'%T%'ORpromo_nameNOTLIKE'%N%')AND(promo_cost>20000ANDpromo_end_date>'l-JAN-0l')Youneedtocreateatablewiththefollowingcolumnspecifications:1.EmployeeID(numericdatatype)foreachemployee2.EmployeeName(characterdatatype)thatstorestheemployeename3.Hiredate,whichstoresthedateofjoiningtheorganizationforeachemployee4.Status(characterdatatype),thatcontainsthevalue'ACTIVE'ifnodataisentered5.Resume(characterlargeobject[CLOB]datatype),whichcontainstheresumesubmittedbytheemployeeWhichisthecorrectsyntaxtocreatethistable（D）A. CREATETABLEEMP_1(emp_idNUMBER(4),emp_nameVARCHAR2(25),start_dateDATE,e_statusVARCHAR2(l0)DEFAULT'ACTIVE',resumeCLOB(200));B. CREATETABLE1_EMP(emp_idNUMBER(4),emp_nameVARCHAR2(25),start_dateDATE,emp_statusVARCHAR2(l0)DEFAULT'ACTIVE',resumeCLOB);C. CREATETABLEEMP_1(emp_idNUMBER(4),emp_nameVARCHAR2(25),start_dateDATE,emp_statusVARCHAR2(l0)DEFAULT"ACTIVE",resumeCLOB);D. CREATETABLEEMP_1(emp_idNUMBER,emp_nameVARCHAR2(25),start_dateDATE,emp_statusVARCHAR2(l0)DEFAULT'ACTIVE',resumeCLOB);Evaluatethefollowingquery:Whatwouldbetheoutcomeoftheabovequery（C）A.ItproducesanerrorbecauseflowerbraceshavebeenusedB.ItproducesanerrorbecausethedatatypesarenotmatchingC.Itexecutessuccessfullyandintroducesan'sattheendofeachpromo_nameintheoutputD.Itexecutessuccessfullyanddisplaystheliteral"{'sstartdatewas}"foreachrowintheoutputWhichstatementsarenottrueregardingindexes（B）A.Whenatableisdropped,thecorrespondingindexesareautomaticallydroppedB.AFOREIGNKEYconstraintonacolumninatableautomaticallycreatesanonuniqueindexC.AnondeferrablePRIMARYKEYorUNIQUEKEYconstraintinatableautomaticallycreatesauniqueindexD.Foreachdatamanipulationlanguage(DML)operationperformed,thecorrespondingindexesareautomaticallyupdatedWhichstatementaretrueaboutsequencescreatedinasingleinstancedatabase（D）A.ThenumbersgeneratedbyasequencecanbeusedonlyforonetableB.DELETE<sequencename>wouldremoveasequencefromthedatabaseC.NEXTVALisusedtorefertothelastsequencenumberthathasbeengeneratedD.WhentheMAXVALUElimitforasequenceisreached,youcanincreasetheMAXVALUElimitbyusingtheALTERSEQUENCEstatementYouissuedthefollowingcommandtodropthePRODUCTStable:（C）SQL>DROPTABLEproducts;WhatisnottheimplicationofthiscommandA.AlldataalongwiththetablestructureisdeletedB.ThependingtransactioninthesessioniscommittedC.AllindexesonthetablewillremainbuttheyareinvalidatedD.AllviewsandsynonymswillremainbuttheyareinvalidatedWhichstatementaretrueregardingviews（C）A.AsimpleviewinwhichcolumnaliaseshavebeenusedcannotbeupdatedB.RowsaddedthroughaviewaredeletedfromthetableautomaticallywhentheviewisdroppedC.TheORREPLACEoptionisusedtochangethedefinitionofanexistingviewwithoutdroppingandre-creatingitD.TheWITHCHECKOPTIONconstraintcanbeusedinaviewdefinitiontorestrictthecolumnsdisplayedthroughtheviewViewtheExhibitandexaminethestructureoftheORDtableEvaluatethefollowingSQLstatementsthatareexecutedinausersessioninthespecifiedorder.Whatwouldbetheoutcomeoftheabovestatements（A）A.AllthestatementswouldexecutesuccessfullyandtheORD_NOcolumnwouldcontainthevalue2fortheCUSTID101B.TheCREATESEQUENCEcommandwouldnotexecutebecausetheminimumvalueandmaximumvalueforthesequencehavenotbeenspecifiedC.TheCREATESEQUENCEcommandwouldnotexecutebecausethestartingvalueofthesequenceandtheincrementvaluehavenotbeenspecifiedD.AllthestatementswouldexecutesuccessfullyandtheORD_NOcolumnwouldhavethevalue20fortheCUST_ID101becausethedefaultCACHEvalueis20Evaluatethefollowingquery:（C）SQL>SELECTTRUNC(ROUND,-1),-1) FROMDUAL;WhatwouldbetheoutcomeA.16B.100C.160D.200Whichstatementistrueregardingsubqueries（D）A.TheLIKEoperatorcannotbeusedwithsingle-rowsubqueriesB.TheNOTINoperatorisequivalenttoISNULLwithsingle-rowsubqueriesC.=ANYand=ALLoperatorshavethesamefunctionalityinmultiple-rowsubqueriesD.TheNOToperatorcanbeusedwithIN,ANY,andALLoperatorsinmultiple-rowsubqueriesWhichstatementarenottrueregardingthedatatypesinOracleDatabase10g（B）A.OnlyoneLONGcolumncanbeusedpertableB.ATIMESTAMPdatatypecolumnstoresonlytimevalueswithfractionalsecondsC.TheminimumcolumnwidththatcanbespecifiedforaVARCHAR2datatypecolumnisoneD.ThevalueforaCHARdatatypecolumnisblank-paddedtothemaximumdefinedcolumnwidthWhichisthevalidCREATETABLEstatement （A） A.CREATETABLEemp9$# (emp_noNUMBER(4)); B.CREATETABLE9emp$# (emp_noNUMBER(4)); C.CREATETABLEemp*123(emp_noNUMBER(4)); D.CREATETABLEemp9$# (emp_noNUMBER(4), date DATE);WhichtwostatementsarenottrueregardingtheCOUNTfunction（A）A.TheCOUNTfunctioncanbeusedonlyforCHAR,VARCHAR2,andNUMBERdatatypesB.COUNT(*)returnsthenumberofrowsincludingduplicaterowsandrowscontainingNULLvalueinanyofthecolumnsC.COUNT(cust_id)returnsthenumberofrowsincludingrowswithduplicatecustomerIDsvalueintheCUST_IDcolumnD.COUNT(DISTINCTinv_amt)returnsthenumberofrowsexcludingrowscontainingduplicatesandNULLvaluesintheINV_AMTcolumnWhichstatementistrueregardingtheINTERSECToperator（D）A.ItignoresNULLvaluesB.ReversingtheorderoftheintersectedtablesalterstheresultC.ThenamesofcolumnsinallSELECTstatementsmustbeidenticalD.ThenumberofcolumnsanddatatypesmustbeidenticalforallSELECTstatementsinthequeryTheORDERStablebelongstotheuserOE.OEhasgrantedtheSELECTprivilegeontheORDERStabletotheuserHR.WhichstatementwouldcreateasynonymORDsothatHRcanexecutethefollowingquerysuccessfully（D）SELECT*FROMord;A.CREATESYNONYMordFORorders;ThiscommandisissuedbyOEB.CREATEPUBLICSYNONYMordFORorders;ThiscommandisissuedbyOEC.CREATESYNONYMordFOR;ThiscommandisissuedbythedatabaseadministratorD.CREATEPUBLICSYNONYMordFOR;ThiscommandisissuedbythedatabaseadministratorWhendoesnotatransactioncomplete（A）A.whenaDELETEstatementisexecutedB.whenaROLLBACKcommandisexecutedC.whenadatadefinitionlanguage(DDL)statementisexecutedD.whenaTRUNCATEstatementisexecutedafterthependingtransactionYouexecutedtheSTARTUPMOUNTcommandtostartyourdatabase.ForwhichdatabaseoperationdoyouneedtostartthedatabaseintheMOUNTstate（C）A.renamingthecontrolfilesB.droppingauserinyourdatabaseC.enablingordisablingredologarchivingatablespaceinyourdatabaseWhichstatementaretruenotaboutthestagesofdatabasestartup（B）A.DatafilesandredologfilescanberenamedattheMOUNTstage.B.ControlfilesarerequiredtobringthedatabasetotheNOMOUNTstage.C.DatafilesandredologfilesaremadeavailabletousersattheOPENstage.D.Datafilesandonlineredologfilesarecheckedforconsistencywhileopeningthedatabase（一致性檢查）Which

statement

regarding

the

contents

of

the

V$PARAMETER

view

is

true

（C）A.

displays

only

the

list

of

default

values

B.

displays

only

the

list

of

all

basic

parameters

C.

displays

the

currently

in

effect

parameter

values

the

list

of

all

the

parameter

files

of

a

database

Because

of

a

power

outage,

instance

failure

has

occurred.

From

what

point

in

the

redo

log

does

recovery

begin

and

where

does

it

end

（B）A.

current

redo

log

and

inactive

redo

log

B.

checkpoint

position

to

end

of

redo

log

C.

beginning

of

redo

log

to

end

of

redo

log

D.

all

redo

logs

before

the

point

of

last

commit

Whichoperationdoesrequireundodata（B）A.committingatransactionB.rollingbackatransactionC.recordingatransactiontoredologfilesD.rollingforwardduringinstancerecoveryYourdatabaseisconfiguredinNOARCHIVELOGmode.Allthecontrolfileshavebeenlostduetoaharddiskfailurebutthedatafilesarenotlost.Youhavetheclosedwholedatabasebackupavailabletoyou.Whichstatementaretrueinthisscenario（D）databasecannotberecovered.B.Thedatabasecanberecoveredbyrestoringthecontrolfilesfromthebackup.C.ThedatabaseremainsopenedandyouhavetoshutitdownwiththeABORToption.D.Thedatabasecanberestoredtillthepointofthelastclosedwholedatabasebackup.AusercomplainsthathegetsthefollowingerrormessagerepeatedlyafterexecutingsomeSQLstatements.Theerrormessageforcestheusertologofffromandlogontothedatabasetocontinuehiswork.ORA-02392:exceededsessionlimitonCPUusage,youarebeingloggedoff.WhichactionwouldyoutaketoincreasethesessionlimitonCPUusage（A）A)Modifytheprofileassignedtotheuser.B)Modifytherolesassignedtotheusers.C)Modifytheobjectprivilegesassignedtotheuser.D)Modifythesystemprivilegesassignedtotheusers.WhichstatementarenottrueabouttherolesintheOracledatabase（A）A.RolesareownedbytheSYSuser.B.Rolescanbegrantedtootherroles.C.Arolecannotbeassignedexternalauthentication.D.Arolecancontainbothsystemandobjectprivileges.ViewtheExhibittoobservetheprivilegesgrantedtotheMGR_ROLErole.TheSCOTTuserhasbeengrantedtheCONNECTandRESOURCErolesonly.Thedatabaseadministrator(DBA)grantsMGR_ROLEtotheSCOTTuserbyusingthiscommand:SQL>GRANTMGR_ROLETOSCOTTWITHADMINOPTION;WhichstatementistrueabouttheSCOTTuserafterheisgrantedthisrole（C）A)TheSCOTTusercangranttheMGR_ROLEroleandtheprivilegesinittootherusers.B)TheSCOTTusercangranttheprivilegesintheMGR_ROLEroletootherusersbutnotwithADMIN_OPTION.C)TheSCOTTusercangrantonlytheMGR_ROLEroletootherusersbutnottheprivilegesinit.D)TheSCOTTusercangranttheprivilegesintheMGR_ROLEroletootherusersbutcannotrevokeprivilegesfromthem.YouexecutedthefollowingcommandtoexporttheEMPLOYEEStablefromaremoteMachine:$EXPDPDUMPFILE=my_dir：LOGFILE=data_pump_dir：TABLES=employeesWhatwouldbetheoutcomeofthiscommand（A）A)ThecommandwouldexecutesuccessfullyandtheexportdumpfilewouldbecreatedinthedestinationofthedirectoryobjectMY_DIR.B)Thecommandwouldexecutesuccessfully.ButlogfilewouldnotbecreatedasDATA_PUMP_DIRdirectoryisonlyaccessibletouserwithSYSDBAprivilege.C)ThecommandfailswithanerrorbecauseDATA_PUMP_DIRdirectoryhavehigherprecedenceovertheper-filedirectory.D)Thecommandfailswithanerrorbecausenoabsolutepathisspecifiedforlogfileanddumpfile.Youexecutethefollowingcommandtoauditthedatabaseactivities:SQL>AUDITDROPANYTABLEBYscottBYSESSIONWHENEVERSUCCESSFUL;Whatistheeffectofthiscommand（A）A)OneauditrecordiscreatedforthewholesessionifuserSCOTTsuccessfullydropsoneormoretablesinhissession.B)OneauditrecordiscreatedforeverysessionwhenanyusersuccessfullydropsatableownedbySCOTT.C)OneauditrecordiscreatedforeachsuccessfulDROPTABLEcommandexecutedbyanyusertodroptablesownedbySCOTT.D)OneauditrecordisgeneratedforthesessionwhenSCOTTgrantstheDROPANYTABLEprivilegetootherusersinhissession.Examinethefollowingcommandsexecutedinyourdatabase:SQL>ALTERSESSIONRECYCLEBIN=ON;SessionalteredSQL>CREATETABLEempTABLESPACEtbsfdASSELECT*FROM;Tablecreated.Further,youexecutedthefollowingcommandtodropthetable:SQL>DROPTABLEemp;Tabledropped.Whathappensinthisscenario（D）A)ThetableismovedtotheSYSAUXtablespace.B)ThetableismovedtotheSYSTEMtablespace.C)Thetableisremovedfromthedatabasepermanently.D)ThetableisrenamedandremainsintheTBSFDtablespace.WhataretheconsequencesofexecutingtheSHUTDOWNABORTcommand（B）A)Thedatabasefilesaresynchronized.B)Uncommittedchangesarenotrolledback.C)Thedatabaseisclosed,buttheinstanceisstillstarted.D)ThedatabaseundergoesautomaticmediarecoveryduringthenextstartupUserSCOTTwantstoexporthisobjectsusingOracleDataPumpandexecutesthefollowingcommand:$expdpscott/tigerdirectory=EXPORT_DIRdumpfile=include=tableinclude=view:"like'%DEPARTMENTS%'"content=DATA_ONLYWhichtaskwouldthecommandaccomplish（C）A)OracleDataPumpwouldexportonlythedataofallofthetablesandviews.B)OracleDataPumpwouldexportallofthetablestructuresalongwithdataandalltheviews.C)OracleDataPumpwouldexportthetabledataandtheviewdefinitionswheretheviewnamecontainsastringnamedDEPARTMENTS.D)OracleDataPumpwouldexportthetabledataandtheviewdefinitionswithdatawhereviewnamecontainsastringnamedDEPARTMENTS.Youexecutedthefollowingcommandtostartthedatabase:SQL>STARTUPORACLEinstancestarted.TotalSystemGlobalArea8bytesFixedSize789000bytesVariableSize6bytesDatabaseBuffersbytesRedoBuffers262144bytesORA-00205:errorinidentifyingcontrolfile,checkalertlogformoreinfoWhichviewwouldyouqueryatthisstagetoinvestigatethismissingcontrolfile（B）A)V$INSTANCEB)V$CONTROLFILEC)DBA_CONTROL_FILESD)V$DATABASE_PROPERTIESWhichstatementistrueaboutthelossofsystem-criticaldatafilesinARCHIVELOGmodeA)Thedatafilescanberecoveredtillthelastcommittedtransaction.B)Thedatafilescanberecoveredwithoutshuttingdownthedatabase.C)Thedatafileistakenofflineautomatically;thedatabaseremainsopen.D)Thedatafilescanberecoveredtothetimeofthemostrecentbackup.答案：AUserAexecutesthefollowingcommandtoupdatetheTRANStable)SQL>UPDATESETtr_amt=tr_amt+500WHEREc_code='C005';BeforeuserAissuesaCOMMITorROLLBACKcommand,userBexecutesthefollowingcommandontheTRANStable:SQl>ALTERTABLEtransMODIFY(tr_typeVARCHAR2(3));Whatwouldhappeninthisscenario（A）A)ThetransactionforuserAisrolledback.B)TheALTERTABLEcommandmodifiesthecolumnsuccessfully.C)TheALTERTABLEcommandfailsduetotheresourcebeingbusy.D)TheALTERTABLEcommandwaitsuntiluserAendsthetransaction.Youbackedupthecontrolfiletotrace.Whichstatementistrueaboutthetracefilegenerated（B）A)Thetracefileisinbinaryformat.B)ThetracefilehasaSQLscripttore-createthecontrolfile.C)Thetracefileisabackupsetcreatedduringthebackupofthecontrolfile.D)Thetracefilecontainstheinstructionstomanuallyre-createthecontrolfile.ViewtheExhibitandanalyzetheCREATETABLEstatementsusedtocreatetheITEMSandORDERStables.TheITEMStablehas50rowsandORDERStablehas500rows.Becauseyoudecidetonotdealwiththeitemcode188infuture,youexecutethefollowingcommandtoremovetheitem:SQL>DELETEFROMitemsWHEREitem_code=188;Whatistheeffectofthiscommand（C）A)Thecommandfailswithintegrityviolationerror.B)Therowcontainingthevalue188correspondingtotheITEM_CODEcolumnisdeletedfromtheITEMStable,andtheforeignkeyconstraintisdisabledintheORDERStable.C)Therowcontainingthevalue188correspondingtotheITEM_CODEcolumnisdeletedfromtheITEMStable,andthedependentrowsintheORDERStablearealsodeletedautomatically.D)The