資源描述:
《oracle_開發(fā)數(shù)據(jù)庫應(yīng)用工程師面試題 必備》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在工程資料-天天文庫。
1、Oracle_開發(fā)數(shù)據(jù)庫英語工程師面試題必備////////////////////////////////////////////////////////////1.()是Oracle維護(hù)數(shù)據(jù)庫中其他文件的列表、數(shù)據(jù)庫名稱和系統(tǒng)改變號(hào)(SCN)的文件。(第二章)A.控制文件。B.參數(shù)文件。C.數(shù)據(jù)文件。D.可執(zhí)行文件。答案.A2.Oracle數(shù)據(jù)庫被劃分為()的邏輯存儲(chǔ)單元,該邏輯存儲(chǔ)單元本身由操作系統(tǒng)磁盤文件和原始分區(qū)組成。(第二章)A.表空間。B.聯(lián)機(jī)重做日志文件。C.歸檔重做日志文件。D.回滾段。答案.A3.()是包含Oracle數(shù)據(jù)庫中所有數(shù)
2、據(jù)的數(shù)據(jù)庫對(duì)象。(第二章)yearsmortgagehousing;4.mortgageregistrationformalitiesarecompleted.(D)pledge1.borrower(includingthepledgor)between18-65yearsofage,withfullcivilcapacity;2.collateral93A.視圖。B.索引。C.存儲(chǔ)過程。D.表。答案.D4.()是為了加速對(duì)特定表數(shù)據(jù)的訪問而創(chuàng)建的數(shù)據(jù)段。(第二章)A.視圖。B.索引。C.存儲(chǔ)過程。D.觸發(fā)器。答案.B5.下面是有關(guān)date數(shù)據(jù)類型和t
3、imestamp數(shù)據(jù)類型的描述,請(qǐng)問哪一種描述是正確的?(第二章)A.兩者都只能存儲(chǔ)日期數(shù)據(jù),不能存儲(chǔ)時(shí)間數(shù)據(jù)。B.兩者都只能存儲(chǔ)時(shí)間數(shù)據(jù),不能存儲(chǔ)日期數(shù)據(jù)。C.date數(shù)據(jù)類型比timestamp數(shù)據(jù)類型的存儲(chǔ)時(shí)間精度高。D.date數(shù)據(jù)類型比timestamp數(shù)據(jù)類型的存儲(chǔ)時(shí)間精度低。答案.Dyearsmortgagehousing;4.mortgageregistrationformalitiesarecompleted.(D)pledge1.borrower(includingthepledgor)between18-65yearsofage,
4、withfullcivilcapacity;2.collateral936.可以自動(dòng)執(zhí)行操作的存儲(chǔ)對(duì)象是()。?(第二章)A.程序包。B.函數(shù)。C.過程。D.觸發(fā)器。答案.D7.當(dāng)Oracle創(chuàng)建數(shù)據(jù)庫時(shí),所有為數(shù)據(jù)庫的數(shù)據(jù)字典所建立的基本表和視圖都存儲(chǔ)在()模式中。A.SYS。B.SYSTEM。C.USER。D.TEMP。答案.A8.()是Oracle數(shù)據(jù)庫對(duì)象的別名,可以強(qiáng)化對(duì)象的安全性。(第二章)A.觸發(fā)器。B.視圖。C.表。D.同義詞。答案.Dyearsmortgagehousing;4.mortgageregistrationformalit
5、iesarecompleted.(D)pledge1.borrower(includingthepledgor)between18-65yearsofage,withfullcivilcapacity;2.collateral939.()是具有只讀類型的表和視圖集,存儲(chǔ)了數(shù)據(jù)庫的物理和邏輯結(jié)構(gòu)信息。?(第二章)A.表空間。B.盤區(qū)。C.數(shù)據(jù)字典。D.方案。答案.C10.()是一組Oracle進(jìn)程和SGA。(第二章)A.實(shí)例。B.數(shù)據(jù)庫。C.表空間。D.實(shí)體化視圖。答案.A11.()可以用于存儲(chǔ)4Gb字節(jié)的數(shù)據(jù)。(第二章)A.Clob。B.Blob。C.
6、Text。D.Varchar2。答案.A12.NUMBER數(shù)據(jù)類型存儲(chǔ)的最大精度是()。(第二章)A.12。B.38。C.127。D.64。答案.Byearsmortgagehousing;4.mortgageregistrationformalitiesarecompleted.(D)pledge1.borrower(includingthepledgor)between18-65yearsofage,withfullcivilcapacity;2.collateral9313.當(dāng)需要描述一個(gè)表table1對(duì)象結(jié)構(gòu)時(shí),可以使用();(第三章)A.DE
7、Stable1。B.DESCtable1。C.DESCRtable1。D.DESCRIBtable1。答案.B14.()是目前各類數(shù)據(jù)庫中最重要、最流行的數(shù)據(jù)庫類型。?(第三章)A.網(wǎng)絡(luò)數(shù)據(jù)庫。B.圖像數(shù)據(jù)庫。C.關(guān)系數(shù)據(jù)庫。D.對(duì)象數(shù)據(jù)庫。答案.C?15.()是對(duì)事物的符號(hào)表示,是用于表示事物的未經(jīng)加工的原始素材。(第三章)A.信息。B.數(shù)據(jù)。C.文本。D.文件。答案.Byearsmortgagehousing;4.mortgageregistrationformalitiesarecompleted.(D)pledge1.borrower(incl
8、udingthepledgor)between18-65yearsofage,withfull