版權聲明：版權所有，歡迎分享本文，轉載請保留出處，否則追究法律責任，謝謝合作。
注：本文将持續更新，可關注作者微信公衆号以便獲得最新筆試面試資料。
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772940&idx=2&sn=3dfc2102685b2b61a861b31e03db962c&chksm=fe8bb1b4c9fc38a282ce434f828fe2d38e92df7dcc4d267b57dd1aad54fb324060943a3c1487&scene=21" target="_blank">⊙ 【DB筆試面試200】在Oracle中，資料庫參數RESOURCE_LIMIT的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772938&idx=2&sn=c01cd9c9cb52fb034710fb154563b11f&chksm=fe8bb1b2c9fc38a4afb9ffbdf5259360d86440f1410375e8ae87bb425efc400e5bfb42a4f514&scene=21" target="_blank">⊙ 【DB筆試面試199】在Oracle中，kfed、kfod和amdu工具的作用分别是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772896&idx=2&sn=3da19cba579fc3368899024a90315a81&chksm=fe8bb1d8c9fc38ce7a9dc7df71a5bc4f2a89a8ca4d9defb4a7c773dfff0996428ddd6513b209&scene=21" target="_blank">⊙ 【DB筆試面試198】在Oracle中，Oracle中有哪些常用的字元函數？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772862&idx=2&sn=39aeb65608f8f38dee934d70574f694d&chksm=fe8bb106c9fc38106cbee854075b33335b585544e307f39bfff773ded9f9105ce0d003fce542&scene=21" target="_blank">⊙ 【DB筆試面試197】在Oracle中，什麼是Metalink或MOS?</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772861&idx=2&sn=1f2e58635550d041e24dc9472104138e&chksm=fe8bb105c9fc38139ca9f3e5138b71f88bf136f523973e2ba269ebd50d0e35a8aa784f04fda4&scene=21" target="_blank">⊙ 【DB筆試面試196】在Oracle中，Linux和Windows下如何快速解除安裝RAC？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772860&idx=2&sn=a04504e8faeb9db417816460d1329757&chksm=fe8bb104c9fc38124d1da728c074b4eccd60b0d493ff2f2199f87cf3cf9e407e71a80ef77bb1&scene=21" target="_blank">⊙ 【DB筆試面試195】在Oracle中，如果$GRID_HOME下的權限被人為修改過，那麼如何來修複該權限問題？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772859&idx=2&sn=ff02f0c8319699fcf886a3e6d7406a46&chksm=fe8bb103c9fc38156e01244e7c74a21cd9d2f30881ce9fdc7ff73ed70da2832c57034dbb7392&scene=21" target="_blank">⊙ 【DB筆試面試194】在Oracle中，如何徹底清除OCR的配置資訊？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772858&idx=2&sn=9b0b055628855f2bf7933fb382b16241&chksm=fe8bb102c9fc3814c4507542fc6f0b41a113180df69f34c3aa369dd613d9fe81803b945320cf&scene=21" target="_blank">⊙ 【DB筆試面試193】在Oracle中，叢集安裝過程中的$GRID_HOME/root.sh腳本的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772857&idx=2&sn=828689e5977a75d859c9189cd019ddb4&chksm=fe8bb101c9fc3817fce3d331c4fc6213ad040776d83adcd20369e518116f7e8dfe4e1cced621&scene=21" target="_blank">⊙ 【DB筆試面試192】在Oracle中，什麼是高可用？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772856&idx=2&sn=f718ac6b1ddc572d999c68fc02f34c15&chksm=fe8bb100c9fc381693bb6db1d0852e9df4d013f0ff743d6421bf2616c9393a2317015b0aa8f7&scene=21" target="_blank">⊙ 【DB筆試面試191】在Oracle中，如何清除Shared Pool中某條SQL語句？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772855&idx=2&sn=007a98d2dd219612c4c5e01bfbfd69ac&chksm=fe8bb10fc9fc381986f44f87242d145a1bb6ca7fee31786a7f721ebb3ba2fa8b866ef93ddf2f&scene=21" target="_blank">⊙ 【DB筆試面試190】在Oracle中，哪個視圖可以查詢資料庫使用者的密碼是不是原始預設密碼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772854&idx=2&sn=a1f397cbb62f42b58b1aeae923149996&chksm=fe8bb10ec9fc38180751280ed30833b541088ca324b6fa97ba134018cfc77113a447a87a358a&scene=21" target="_blank">⊙ 【DB筆試面試189】在Oracle中，密碼延遲驗證是什麼？如何屏蔽？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772853&idx=2&sn=49c278c58acbbeb0283c997562283310&chksm=fe8bb10dc9fc381b9cdfec624c11ef7080a0c0fa99f76641976d377d71ef89146630a316da5f&scene=21" target="_blank">⊙ 【DB筆試面試188】在Oracle中，哪個參數控制密碼的大小寫敏感性？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772852&idx=2&sn=af0459499b93fc322c540d82203bbbe2&chksm=fe8bb10cc9fc381a6bc2fe8a84c305a99a06f0bfec465b32154fbd4b43262be671ee3d6fea3a&scene=21" target="_blank">⊙ 【DB筆試面試187】在Oracle中，UNDER ANY TABLE或UNDER ANY VIEW的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772851&idx=2&sn=ca70525a67b5868e69c677ee146486f9&chksm=fe8bb10bc9fc381d0538583729273b21c432acf177fe10c8abb6d6e1132048bdccc37e6583d9&scene=21" target="_blank">⊙ 【DB筆試面試186】在Oracle中，建立使用者時PROFILE選項的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772850&idx=2&sn=d29704eaf2370705a9cbcbd81475d8c5&chksm=fe8bb10ac9fc381c75d3ffe366bd80ecb25ed1bc2bcb30a99470b11786b36c715eb2d294a5a1&scene=21" target="_blank">⊙ 【DB筆試面試185】在Oracle中，如何讓普通使用者可以TRUNCATE其他使用者的表？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772849&idx=2&sn=9a3eed6992c2fb5466b649ed5b37146d&chksm=fe8bb109c9fc381f446bbb1d448a2d3a5f8e602cc28d4a3288d3e515738ec0d880c6bd239d22&scene=21" target="_blank">⊙ 【DB筆試面試184】在Oracle中，如何監控TEMP和UNDO表空間并将耗費TEMP和UNDO空間非常大的SQL語句記錄？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772848&idx=2&sn=f61925db1260f060434a5702744e4409&chksm=fe8bb108c9fc381e80ba237b69d2a468ccff6698e7847551a8ff7e56d946646f9a22ae808d0c&scene=21" target="_blank">⊙ 【DB筆試面試183】在Oracle中，如何檢視存儲過程的編譯錯誤？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772847&idx=2&sn=5844df505fba7b832a77f5333f9d72b2&chksm=fe8bb117c9fc380128dc016bff9f3f64b3346dbe29e68b197b1528d1287d4d8bef9f2065dad4&scene=21" target="_blank">⊙ 【DB筆試面試182】在Oracle中，下列SQL語句共建立了多少個段？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772846&idx=2&sn=0d9dc09a46400dbadb199112bee2f3b5&chksm=fe8bb116c9fc380076eb8d143a0421e3311d02e535b51818ac3e52db1d21d47e2f05f00e4438&scene=21" target="_blank">⊙ 【DB筆試面試181】在Oracle中，重做日志檔案（Redo Log Files）的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772845&idx=2&sn=df339126137c2ec7aebadb1e9471732b&chksm=fe8bb115c9fc3803b2ccc9e2586150cc654f845032121b8a3ad98a781bdad68e4d53382e6e20&scene=21" target="_blank">⊙ 【DB筆試面試180】在Oracle中，UNDO的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772844&idx=2&sn=de9ed1fee84fbccbde9f992e9e3d1d06&chksm=fe8bb114c9fc3802ca7ce908e498b6565039c683bd6157abece5599a2148efee041470e374d3&scene=21" target="_blank">⊙ 【DB筆試面試179】在Oracle中，本地管理表空間（LMT）和字典管理表空間（DMT）的特點有哪些？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772843&idx=2&sn=4c445a2d4c622c3169cdf2c98373200f&chksm=fe8bb113c9fc3805b50fccabddb29e601702bf86d40ac3d71c81c58ddf3cfdc3fa5a25728b69&scene=21" target="_blank">⊙ 【DB筆試面試178】在Oracle中，如何通過SQL語句查詢資料庫伺服器主機的CPU和記憶體情況以及各個快照期間？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772842&idx=2&sn=0f916c97d1514d446bea2f99e1abbea3&chksm=fe8bb112c9fc3804dbfef7055df4bc113301a17334bee81d6d90d7ef6f22d86e47a53dff6437&scene=21" target="_blank">⊙ 【DB筆試面試177】在Oracle中，如何查詢超過10小時無響應的會話？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772841&idx=2&sn=af50c1d6a2e7ee7ff42818afd4b420f7&chksm=fe8bb111c9fc38070a5d7c6e6a319ac901e15573505d135da738d5ec6e4b3fca81d560084720&scene=21" target="_blank">⊙ 【DB筆試面試176】在Oracle中，如何用SQL實作AWR報告中Load Profile部分？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772839&idx=2&sn=7f2a1aaea69a74f9d6704084e877cc01&chksm=fe8bb11fc9fc38097cdd469a2d837ddfec58b555dfb11e09022da94cb0b8bfd86779f033f612&scene=21" target="_blank">⊙ 【DB筆試面試175】在Oracle中，如何知道哪些外鍵未建立索引？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772838&idx=2&sn=afae57278e3d204fb1056f395b672a08&chksm=fe8bb11ec9fc380852200261f0bf99df625de8f5d0e75b13f725eed6c8b95b1c8b6abfeb2395&scene=21" target="_blank">⊙ 【DB筆試面試174】在Oracle中，如何知道哪些業務使用者的表或索引建立在SYSTEM表空間上？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772837&idx=2&sn=f6f3b3438a9d9517a0cc3d0ce324f318&chksm=fe8bb11dc9fc380b13e9dbba4ec1c9c09368f6b5bcb45aa5a980962f924a7e1075aeb312abbd&scene=21" target="_blank">⊙ 【DB筆試面試173】在Oracle中，若使用者LHRSYS登入失敗，則從哪個視圖可以擷取登入失敗的次數？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772836&idx=2&sn=148808910edb1e2f6f0bc0724b110310&chksm=fe8bb11cc9fc380a4533e65d11777414e0c3dc79608fc8a666994eae16829f565090b4ee02c3&scene=21" target="_blank">⊙ 【DB筆試面試172】在Oracle中，如何查詢哪些使用者具有DBA角色？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772835&idx=2&sn=b4739e893801f6d8bfbda5839d840bbe&chksm=fe8bb11bc9fc380d4572dc6e2e73495f015c576926926800fdd3bdbfb71c989023e5c37fca9b&scene=21" target="_blank">⊙ 【DB筆試面試171】在Oracle中，如何按照小時查詢當天日志的切換次數？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772834&idx=2&sn=30debe976c7ea7c2d7d011edb8c3d3a4&chksm=fe8bb11ac9fc380ccdcc532578d73482e3466cb91b7c976d500fd53a083fc06beef78e4c7a3b&scene=21" target="_blank">⊙ 【DB筆試面試170】在Oracle中，如何查詢歸檔日志的生成情況？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772833&idx=2&sn=f41a1d7ec6762994c6a0d9aa01e56d3c&chksm=fe8bb119c9fc380f2e0f1d56f4b1b290ee94230c531e55b2332942370865f48c29d549164b78&scene=21" target="_blank">⊙ 【DB筆試面試169】在Oracle中，如何查詢RMAN的所有備份資訊？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772832&idx=2&sn=f2083dc697acf70e1761f28c72435179&chksm=fe8bb118c9fc380e08c8e1b7be5bb7fbe127116b8bfc2692587d39b03459048eb56eec85314e&scene=21" target="_blank">⊙ 【DB筆試面試168】在Oracle中，如何查詢ASM磁盤及ASM磁盤組的使用情況？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772831&idx=2&sn=fe07d3a5f7f167c3c4774e89d2a222f5&chksm=fe8bb127c9fc38310f58fcbbe33296327ffde932b44d5cc7688c4c4f44c08203c14172a5ec6c&scene=21" target="_blank">⊙ 【DB筆試面試167】在Oracle中，如何查詢資料庫閃回空間的使用情況？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772830&idx=2&sn=dc4177842558aea334e69f3ed9c36d8a&chksm=fe8bb126c9fc3830b3e45d7190abc02498d67848d29db787694219358f87d85b517b0a14b68d&scene=21" target="_blank">⊙ 【DB筆試面試166】在Oracle中，如何查詢到資料庫的增長情況？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772829&idx=2&sn=503dc3ca100c666808bc7f5192a0e546&chksm=fe8bb125c9fc3833182547a39634d7a8f5430a94737ae823e90d80c4c8719df3e4a51a4b2549&scene=21" target="_blank">⊙ 【DB筆試面試165】在Oracle中，如何跟蹤expdp和SQL*Plus指令？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772828&idx=2&sn=b807e7b20cf7db98a6e9b907d305bfb9&chksm=fe8bb124c9fc38325230539e007544e6e9b56f0b2e85981f338fbbff6db5666c25015af09db1&scene=21" target="_blank">⊙ 【DB筆試面試164】在Oracle中，如何徹底停止expdp程序？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772841&idx=3&sn=b8efb9d3fd2c95beceeb83a0d10c5bc5&chksm=fe8bb111c9fc380782d6c6b29c7ea47db77554f2ee53b03fd049ada7050c3539e9a4d0b7ebd3&scene=21" target="_blank">⊙ 【DB筆試面試163】在Oracle中，RMAN可以跨版本或跨平台執行還原或複制指令嗎？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772826&idx=2&sn=7fb253369a53c52f0ff5aa1cd8d90bc9&chksm=fe8bb122c9fc38348d54e469d3d241d7f1af30420d842b99d3bf741a9bee9524427adfe26582&scene=21" target="_blank">⊙ 【DB筆試面試162】在Oracle中，在UNDO表空間資料檔案丢失的情況下如何恢複？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772825&idx=2&sn=b791b5093eae0a67e92ec40fc8de5b59&chksm=fe8bb121c9fc3837b198fb942d143295e071efe0f2c451a62102cc1a5add4992c70d70703325&scene=21" target="_blank">⊙ 【DB筆試面試161】在Oracle中，資料泵中NETWORK_LINK選項的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772769&idx=2&sn=755b8aadbabdfa168d70301deff6fc59&chksm=fe8bb159c9fc384fdaf7f3d1b556a4e08eabce3644861f9c0fb13be5b2af307e5f69abf00ef1&scene=21" target="_blank">⊙ 【DB筆試面試160】在Oracle中，TWO_TASK環境變量的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772768&idx=2&sn=5a3dc71f3bde45751defc96bf3ae8f1e&chksm=fe8bb158c9fc384efb6d2fcfcaf1b025db2720b2b3fa93627bd871c59594e7e64ea6f92fe4c1&scene=21" target="_blank">⊙ 【DB筆試面試159】在Oracle中，sqlnet.ora檔案的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772767&idx=2&sn=3f8d0584c6f9bcc5f847820259a6609e&chksm=fe8bb167c9fc3871b0a21a67ca5e07f9ccf27520f2e38a032428228b96e25f217e17abb649f5&scene=21" target="_blank">⊙ 【DB筆試面試158】在Oracle中，tnsnames.ora檔案的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772766&idx=2&sn=0021a67f7f9930e5a33051191572d070&chksm=fe8bb166c9fc3870dcd715b68db96e6a20b01b3f9fb1c1ee951327a1acb9829549094aea8207&scene=21" target="_blank">⊙ 【DB筆試面試157】在Oracle中，SCHEMA和USER的差別是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772765&idx=2&sn=1cdd934448df81d28a88852b7d51a708&chksm=fe8bb165c9fc3873a71dc980285f611241c2dc9b068725709e4a69d9cba5828e659ed664436b&scene=21" target="_blank">⊙ 【DB筆試面試156】在Oracle中，如何查詢資料庫系統或目前會話的REDO和UNDO的生成量？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772764&idx=2&sn=f4b038b6d14059d3c9a2021dde9022c4&chksm=fe8bb164c9fc3872bec00738f5b3fe4bd4b463ef626cc0cf552f2a5da5fe7ae046fb1c363634&scene=21" target="_blank">⊙ 【DB筆試面試155】在Oracle中，建立ASM磁盤的方式有哪幾種？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772763&idx=2&sn=92d72d404ecf3c6b927e4c59c3f6b485&chksm=fe8bb163c9fc38754160040ec3a18bba018d1b2f92ce4690e414e9e9f72e18931aecfa467bc8&scene=21" target="_blank">⊙ 【DB筆試面試154】在Oracle中，ASMLIB是什麼？常用指令有哪些？其運作日志路徑在哪裡？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772762&idx=2&sn=dc5cb1c75c90de1bee5ede64cadc1799&chksm=fe8bb162c9fc387460e5a566d33b6a60d69e928e196c91a49408a2a768bbd56e29bc048266c6&scene=21" target="_blank">⊙ 【DB筆試面試153】在Oracle中，RAC等待事件gc buffer busy acquire和gc buffer busy</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772760&idx=2&sn=74dab640419950e8454c5000c21c44db&chksm=fe8bb160c9fc38760b5de080a592c344f2ac0050837b46fd51096670e657f012e8c585e01b45&scene=21" target="_blank">⊙ 【DB筆試面試152】在Oracle中，RAC下如何在目前的執行個體下殺掉另外一個執行個體的會話？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772759&idx=2&sn=a30de15ba10d0bb0330a310b195cf4e6&chksm=fe8bb16fc9fc38792757ab58d58bd424ff02444860c766e564a3a723d0356d4877c24fe003d1&scene=21" target="_blank">⊙ 【DB筆試面試151】在Oracle中，談談對Oracle中RAC用到的Cache Fusion的了解。</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772740&idx=2&sn=5107bbfe5c729e1c9144a920fc5fc411&chksm=fe8bb17cc9fc386a4bc4cec2964c65ec9f17de917310b643cb313b2e0a270ad9159e9f4eda28&scene=21" target="_blank">⊙ 【DB筆試面試150】在Oracle中，tkprof的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772739&idx=2&sn=dce4b400ed072d902e6a96b004ff7c21&chksm=fe8bb17bc9fc386d3daa15255ba15b3e8dc89b86d1240040a1c6c2593106112d1effa8aa1bb5&scene=21" target="_blank">⊙ 【DB筆試面試149】在Oracle中，imp工具的ignore參數有什麼作用？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772737&idx=2&sn=5721b788c700cbc60d11e8519bdca989&chksm=fe8bb179c9fc386f2fe1941378c11139a3c2e979a12c7db8d94a390e302afa0395aad3e65645&scene=21" target="_blank">⊙ 【DB筆試面試148】在Oracle中，如何找出目前有多少個使用者登入到資料庫？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772736&idx=2&sn=2c63c5e408aee6e3eb3dd1ea649f664d&chksm=fe8bb178c9fc386e80834cef9a0b78f29153e12a12ae007a0ec619c0dded5f519e1c40e65d41&scene=21" target="_blank">⊙ 【DB筆試面試147】在Oracle中，>，<一般情況下會走索引嗎？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772735&idx=2&sn=bd187af7dc3c1dc94683cff64b7a5844&chksm=fe8bb687c9fc3f919b307e5183cd4dbddabd56715202f4f8ff670fa6d57310b97eb49fe87970&scene=21" target="_blank">⊙ 【DB筆試面試146】在Oracle中，oraInventory目錄的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772734&idx=2&sn=4eb75fcfdd02a5ccedbb80522135fc2a&chksm=fe8bb686c9fc3f90421df851da24703d36c347da127399db012987ed948a9f09d4b29ecd40a9&scene=21" target="_blank">⊙ 【DB筆試面試145】在Oracle中，Oracle 11g安裝完後需要禁用哪些參數？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772733&idx=2&sn=3eee9ea9af906dcdea2724abd7d4d4a3&chksm=fe8bb685c9fc3f93e480c90a4a8b4b925c8ee2d828ab39d799304e5cdc02dc9b54f27ec9700e&scene=21" target="_blank">⊙ 【DB筆試面試144】在Oracle中，物化視圖（Materialized Views）的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772732&idx=2&sn=0b0eabe9998c1825bcbd5b21baee16d8&chksm=fe8bb684c9fc3f92650337b4e34165d5af2fc2ebef593254084008e9b6d46f3260411f012957&scene=21" target="_blank">⊙ 【DB筆試面試143】在Oracle中，如何查詢資料庫的時區？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772731&idx=2&sn=4ff528b7b80000790d2842ef56e8db6c&chksm=fe8bb683c9fc3f95d59e0fa5830dcf2aa814ba6fce8a5e83cba9b1b9de5d90091993644b3e0b&scene=21" target="_blank">⊙ 【DB筆試面試142】在Oracle中，$ORACLE_HOME和$ORACLE_BASE的差別是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772730&idx=3&sn=12d35a0b09cdc17ec89710f89357cf78&chksm=fe8bb682c9fc3f9479025f2588db9cbe87181199a8ebc9291eeb1bc4d3c1faa20123b7c71245&scene=21" target="_blank">⊙ 【DB筆試面試141】在Oracle中，歸檔檔案的命名格式由哪個參數來控制？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772718&idx=2&sn=da556f247f54914cb417f09062373b51&chksm=fe8bb696c9fc3f807dec9c47873e98f676d7b1e23f54faaf1ca59bfe947305cce6dc5393f16d&scene=21" target="_blank">⊙ 【DB筆試面試140】在Oracle中，errorstack的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772716&idx=2&sn=a96871d0a78ee57f23f7ec18f4d6f91a&chksm=fe8bb694c9fc3f825d737c941fd04f89a4b1770fd0773a2121480761c6c88de73c0673b7692e&scene=21" target="_blank">⊙ 【DB筆試面試139】在Oracle中，INTERVAL分區的STORE IN屬性存儲在哪張表中？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772715&idx=2&sn=ea443165bc002d8c87a4bc31279944a2&chksm=fe8bb693c9fc3f85a9e64d1f7d6368136bf23300c5dc0e70ed08c2c7dd4f631550add68adb31&scene=21" target="_blank">⊙ 【DB筆試面試138】在Oracle中，如何dump資料庫内部結構？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772714&idx=2&sn=108d544381d0b1ff4ec259d9cd3f70a7&chksm=fe8bb692c9fc3f84dc8cbc5127ce68b8c1e66b43f859dd164e3b02a9d7f7699ed88d335c02ed&scene=21" target="_blank">⊙ 【DB筆試面試137】在Oracle中，關于大池（Large Pool）說法正确的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772713&idx=2&sn=fcf3df5cffe69004346cedeb783f6581&chksm=fe8bb691c9fc3f87a43c6ae8143c939dc13e0c86a1e1eb50bed46e8bdf5b7a831f2cdc1ada40&scene=21" target="_blank">⊙ 【DB筆試面試136】在Oracle中，如何查找最近1分鐘内，最消耗CPU的SQL語句及會話資訊？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772710&idx=2&sn=bcecbd7c67a82107c22f9d377e6fab84&chksm=fe8bb69ec9fc3f885fccbefece841d8994591c573c4fde051496da27894ea53a62a40d8eb51f&scene=21" target="_blank">⊙ 【DB筆試面試135】在Oracle中，如何查詢邏輯讀、實體讀等SQL語句呢？如何尋找或監控效率低下的SQL語句？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772709&idx=2&sn=1420d2b95bc62c4f3cdf902e5c5f1fe5&chksm=fe8bb69dc9fc3f8b79699b11d0846508fb138caca4441a43ac3195ae752195a0f468809c2443&scene=21" target="_blank">⊙ 【DB筆試面試134】在Oracle中，COUNT(1)比COUNT(*)在執行效率上要快嗎？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772708&idx=2&sn=30eb26cd03cf356b21a24157c7072c3a&chksm=fe8bb69cc9fc3f8adfe2b4c90fc270f9e49ff2ad6fd922d7bdddd1c4d8557ac64151b7b88f45&scene=21" target="_blank">⊙ 【DB筆試面試133】在Oracle中，資料塊，重做日志塊及控制檔案資料塊的大小分别是多少？如何查詢？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772707&idx=2&sn=1b7d28bbbcecf3d4099ab7bfabac9d49&chksm=fe8bb69bc9fc3f8deef4dc65c8c5903753bb04d0b47d29d06e7fdf9b55b1a6fd064f78e49990&scene=21" target="_blank">⊙ 【DB筆試面試132】在Oracle中，PMON清理失敗程序的頻率是多長？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772706&idx=2&sn=cb7794f126ecda18adc36e5db050fb50&chksm=fe8bb69ac9fc3f8ca185e6a77a81e0f0889c1d7b5c6fd22d48b11520dbeb5e1987657aab0bb2&scene=21" target="_blank">⊙ 【DB筆試面試131】在Oracle中，對于一個比較複雜的存儲過程來說，如何快速定位到是什麼語句什麼原因導緻的失敗解</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772706&idx=3&sn=b3ac84e8f0d9e4b66a84f5e7f308da30&chksm=fe8bb69ac9fc3f8c8b2d86c4110bf3e33f5b65f3b0954f73c80cfc64594e011858cc2ab27bd0&scene=21" target="_blank">⊙ 【DB筆試面試130】在Oracle中，。。。external table? 外部表（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772702&idx=2&sn=ef8e02ceb2cd3ae79c63a8880975010a&chksm=fe8bb6a6c9fc3fb08444f30630796da0a0499cd3d7bf8a8daa64bf9019bac50576c43626fa69&scene=21" target="_blank">⊙ 【DB筆試面試129】在Oracle中，CREATE GLOBAL TEMPORARY TABLE（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772701&idx=2&sn=785e04aa556ab849cc677e721353f1f2&chksm=fe8bb6a5c9fc3fb3a7a4c3ca472112acc8236744aecbbb8120224092346b6cf225639594656a&scene=21" target="_blank">⊙ 【DB筆試面試128】在Oracle中，。。。 is supported on the table 。。。（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772665&idx=2&sn=938b27704e17182c93d6262d72f98e59&chksm=fe8bb6c1c9fc3fd77e8a84912ab8cb57eb12cb6b536bdd54ed8301c9c00ffe810e478c14b6ea&scene=21" target="_blank">⊙ 【DB筆試面試127】在Oracle中，如何在AWR中檢視每秒執行事務的個數？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772664&idx=2&sn=c06745e81f1339b80970a21bc5a0a678&chksm=fe8bb6c0c9fc3fd6cba0c9149bc140124b6ce3ab3352e8ee8fb9c90d3add33578bef4b2616b8&scene=21" target="_blank">⊙ 【DB筆試面試126】在Oracle中，You have set Tablespace Full Metrics。。。（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772662&idx=2&sn=2771d28b4be467e0a8bb8b0c34e83bdf&chksm=fe8bb6cec9fc3fd8d289162666a86f662a052e801789a43468ce2669247c6c40cb5856f073ee&scene=21" target="_blank">⊙ 【DB筆試面試125】在Oracle中，Why 。。。 execute 。。。 report obsolete 。。。（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772661&idx=2&sn=fd02ea463c2af717105dbad1e59c69cc&chksm=fe8bb6cdc9fc3fdbca1b4ffda7cc099032ad9e1e4940cbc298f7e72ef749a083b5a3fc958cde&scene=21" target="_blank">⊙ 【DB筆試面試124】在Oracle中，You have not OMF。。。（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772660&idx=2&sn=9f879403c98134b1e8e54cc1bce4847a&chksm=fe8bb6ccc9fc3fda1ec862531404eb3294a75d433288422429ac9653aa8d1a5178eb584ab46c&scene=21" target="_blank">⊙ 【DB筆試面試123】在Oracle中，Which of。。 point-in-time recovery?（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772657&idx=2&sn=6d8c7af0c076b9695c8cfc551e6d122b&chksm=fe8bb6c9c9fc3fdf50857855f4a0cb44a6c2d89c8e19ae8c50041b9f67226730bead64b2a359&scene=21" target="_blank">⊙ 【DB筆試面試122】在Oracle中，Which options 。。。TSPITR by using RMAN?</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772656&idx=2&sn=970ec7ee302b0e5c432a3de001de62c3&chksm=fe8bb6c8c9fc3fde30b039e59ac5a7fb67efbe0b3a286d68b81b946e7a7fbda438521e050d9c&scene=21" target="_blank">⊙ 【DB筆試面試121】在Oracle中，What methods of point-in-time recovery 。。。（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772656&idx=4&sn=c0fe8409df9c83c4dd07bb9f173bccab&chksm=fe8bb6c8c9fc3fde4775e7f4bf5cfc8176f8327020aff23a259fbfee34c25e9d923bb5df0a0c&scene=21" target="_blank">⊙ 【DB筆試面試120】在Oracle中，Which of the following 。。。RMAN?</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772652&idx=2&sn=4af8f2413416ed2882b61cf2dbed35e4&chksm=fe8bb6d4c9fc3fc252ab5ce9b4b78908ca345932202ab7b87eadcccd91b7fe5ec6610e8181b2&scene=21" target="_blank">⊙ 【DB筆試面試119】在Oracle中，Identify three key features of ASM（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772616&idx=2&sn=8661be7df09a7ac850b5b76badf583ba&chksm=fe8bb6f0c9fc3fe66b08f9654d2cd76c041a964008e4bd331601a5cc2a36e1e1e4a1bb6ad9e6&scene=21" target="_blank">⊙ 【DB筆試面試118】在Oracle中，An index called ORD_CUSTNAME（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772615&idx=2&sn=292e001a21e15963d79553c09965b0f8&chksm=fe8bb6ffc9fc3fe9f892d3399a18e229d5b8e5b8cc5ef7aee6a43c22bbe6be77a1c108776537&scene=21" target="_blank">⊙ 【DB筆試面試117】在Oracle中，You have statistics collected for some。。。 （）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772614&idx=3&sn=77d8bb43de0dc17b936a58d225e2a95b&chksm=fe8bb6fec9fc3fe8c56f14602ec5dfd504db9deef6af0ad0f4363da5a18a1e6b9eb877e19c2a&scene=21" target="_blank">⊙ 【DB筆試面試116】在Oracle hint中的DRIVING_SITE的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772614&idx=2&sn=83cb32adb7083b764a6a83dc1088fc8b&chksm=fe8bb6fec9fc3fe854b339da8329fd593db1e00fcac7ef47951b707b80d40e379e72815b310c&scene=21" target="_blank">⊙ 【DB筆試面試115】在Oracle中， Which three statements 。。。spfile。 ()</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772612&idx=2&sn=12919cae8fb117961d6cae0603691494&chksm=fe8bb6fcc9fc3fea555efb021257146969e9b7a735184247ebf9667eabcadb3b679aea301a48&scene=21" target="_blank">⊙ 【DB筆試面試114】在Oracle中，。。。 background processes（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772609&idx=2&sn=9ca95b43fa92f050186f3b43820318af&chksm=fe8bb6f9c9fc3fefa1cd985625716a2cb36ca17da5d0edae738c22168a9bc1d403d47f19d53f&scene=21" target="_blank">⊙ 【DB筆試面試113】在Oracle中，DATA BLOCK，EXTENT和SEGMENT的差別是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772602&idx=2&sn=e6b399adb45505aa9c156ed4c481e86d&chksm=fe8bb602c9fc3f1481076a701ace6b48a855ce991cf0fc32f392bfe454c60b31d86bf2921f61&scene=21" target="_blank">⊙ 【DB筆試面試112】在Oracle中，下面有關TABLESPACE和DATAFILE之間的關系的描述中，說法錯誤的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772601&idx=2&sn=9f8b6b0632c8869a49daf23f9f64f473&chksm=fe8bb601c9fc3f17dcdf1a74a1f3a5f5dd11a681625c35c0485d1263157ee12220b65cbe7faf&scene=21" target="_blank">⊙ 【DB筆試面試111】在Oracle中，Note the following structures。。。邏輯結構（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772566&idx=2&sn=8349253302819d2755643a5fd61f7163&chksm=fe8bb62ec9fc3f38b51b5fe3d16a3d5b3d5b0c5aabed2d7a1a26da635f5d876681fb96015ee0&scene=21" target="_blank">⊙ 【DB筆試面試110】在Oracle中，下列關于AUTHID的說法哪些是正确的？（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772565&idx=2&sn=d7664328487aa5ce3d53d821f3c6e333&chksm=fe8bb62dc9fc3f3bda06ed36f4b96e3aa4a6d354591336fb56393cc3a996c7de5c3850ef72a0&scene=21" target="_blank">⊙ 【DB筆試面試109】在Oracle中，Which 。。。conventional path of SQL*Loader?（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772559&idx=2&sn=5c80ae9262ca622ce329b1c17c6ba203&chksm=fe8bb637c9fc3f21b1def8d0e67dd9e6e9792c047c1702e8258a4dd4aec81502cf41537034a6&scene=21" target="_blank">⊙ 【DB筆試面試108】在Oracle中，sqldlr true 。。。SQL*Loader utility?（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772556&idx=2&sn=5df00fcc49ef6afed6a4b8e077371b57&chksm=fe8bb634c9fc3f220950f279454c92cc4ccfd1f6036f5d0b4d8bab5de55ea3141aba6e48e4d6&scene=21" target="_blank">⊙ 【DB筆試面試107】在Oracle中，有如下圖的資料，那麼SQL語句SELECT AVG(AGE) FROM STUINFO</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772553&idx=2&sn=ed3c3e392636e062744a108d604b5299&chksm=fe8bb631c9fc3f277ae9bf1a362ba125bec5b8d2098d94784cc675d35560b62e5d49052c0e5e&scene=21" target="_blank">⊙ 【DB筆試面試106】在Oracle中，下面有關SQL綁定變量的描述中，錯誤的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772552&idx=2&sn=3045d93acf5c3fe6fabe7fdf8be1f8d7&chksm=fe8bb630c9fc3f26a7c1ca7c680100cc521540afe3edfb3a542d4c52a288742aa9ba50173634&scene=21" target="_blank">⊙ 【DB筆試面試105】在Oracle中，資料庫中有一張如下所示的表，表名為sales。。。查詢出如下所示的結果。【行轉列】</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772542&idx=2&sn=ed3d304a82e93900d5202eb902dfb2a8&chksm=fe8bb646c9fc3f505019e449e2c1095696e59733557f3087563a6dded988e71b0f2c76854e5a&scene=21" target="_blank">⊙ 【DB筆試面試104】在Oracle中，假定SERV表有a、b、c三個字段。。。判斷PL/SQL能否正常執行？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772541&idx=2&sn=01bd07d90416341284fc5bc738d56b09&chksm=fe8bb645c9fc3f531db49176aa6f1c8a4a396a7124bdae69bfabea31911ed0f7bd09f699c30b&scene=21" target="_blank">⊙ 【DB筆試面試103】在Oracle中，如何将一個IP位址分解為4個字段？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772662&idx=3&sn=a58e9752009007fb3c6149a76821e44e&chksm=fe8bb6cec9fc3fd8200cd60ed4c3b162a774e3e20d729719cd8efce816364089e2eb71ffa6e1&scene=21" target="_blank">⊙ 【DB筆試面試102】在Oracle中，如何計算一個字元在字元串中出現的次數？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772660&idx=3&sn=b37e2a49a3746bd8c55b1d283b9a5304&chksm=fe8bb6ccc9fc3fda52f5b40c59eb8a85542d3ba2b028cb55f3d2e92922858e98be8f2b7e7bf2&scene=21" target="_blank">⊙ 【DB筆試面試101】在Oracle中，Which statement is true 。。。 COALESCE 。。。（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772523&idx=2&sn=d0c779f4e859e8889dcbb23715afa393&chksm=fe8bb653c9fc3f452bcfaff7e533976abba351a3615bdc1c858a0de19bc733d12cbe2aae8f6f&scene=21" target="_blank">⊙ 【DB筆試面試100】在Oracle中，如下指令：CREATE SEQUENCE seq1（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772516&idx=2&sn=a506d6babbd04d383f340471acbdf34a&chksm=fe8bb65cc9fc3f4ac6b60c031d459014c434d95ca42057912ca2d93c98e6c91e87eedcae70ec&scene=21" target="_blank">⊙ 【DB筆試面試99】幾道MySQL基礎題</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772512&idx=3&sn=edb86f4a7e24a97aa193871bb88491f0&chksm=fe8bb658c9fc3f4e9349f7d389e260196ace95721213a4f0ff5bd63f5420ff15cd8b18678a5d&scene=21" target="_blank">⊙ 【DB筆試面試98】在MySQL中，有兩個複合索引(A,B)和(C,D)，以下語句會怎樣使用索引？可以做怎樣的優化？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772511&idx=3&sn=6d21526f84e26906d305bf3ad61f6bfe&chksm=fe8bb667c9fc3f71bac560a68fb00bb8899835e3cd1607658356e47ecd2ac7f72cc917d76325&scene=21" target="_blank">⊙ 【DB筆試面試97】在MySQL中，如何分析一條SQL語句的執行性能？需要關注哪些資訊？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772507&idx=2&sn=32e1e7118fbb23486f8f84ddd7254acb&chksm=fe8bb663c9fc3f75fd275a45556ffda022053a2274ba0c1f5383f50d20b173ea917b06755ab8&scene=21" target="_blank">⊙ 【DB筆試面試96】在MySQL中，下列SQL語句中，可為使用者ZHANGSAN配置設定資料庫USERDB表USERINFO的查詢（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772498&idx=2&sn=1a8cd9881fb66d2da5b918e268ff87e6&chksm=fe8bb66ac9fc3f7c463ab76956840d513c63ec96d19a9a784d844f98eaf2dc713257cf52575f&scene=21" target="_blank">⊙ 【DB筆試面試95】在MySQL中，MyISAM和InnoDB各有哪些特性？分别适用在怎樣的場景下？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772535&idx=3&sn=0f1dceaa7caebbe5e9f85ce16b4ce4ef&chksm=fe8bb64fc9fc3f59d1b8f81f250e3deb01608a93775a79f4a409eb3e039a3e6eb6e688b051e5&scene=21" target="_blank">⊙ 【DB筆試面試94】在MySQL中，VARCHAR與CHAR的差別是什麼？VARCHAR(50)中的50代表的含義是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772489&idx=3&sn=df12eb8e8f3c6a2bd6c244d0f45b8093&chksm=fe8bb671c9fc3f67954148af5c8f7233a8af39eebf5c2ce9d5ae0d081fd28d8ff0699fd274a7&scene=21" target="_blank">⊙ 【DB筆試面試93】在MySQL中，建立GBK字元集的資料庫NEWLHR，并檢視已建庫的完整語句。</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772488&idx=2&sn=dd21076e18d871aec498c2ab974ee5db&chksm=fe8bb670c9fc3f66a087fa09ea583058dacfb909f7f342ff44a7f37c1bc300b10a792ae17070&scene=21" target="_blank">⊙ 【DB筆試面試92】在MySQL中，有如下表結構，其中，NAME字段代表“姓名”，SCORE字段代表“分數”。</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772479&idx=2&sn=f0f534b232d40f90faa3f8b19b8ed195&chksm=fe8bb787c9fc3e912a071f2bd0a62f55a916dae7b73eb5a6b551883a148e6f028f74d77fd63c&scene=21" target="_blank">⊙ 【DB筆試面試91】在MySQL中，建立一個存儲引擎為InnoDB，字元集為GBK的表TEST，字段為ID和NAME</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772469&idx=2&sn=f996b4a6f02090ee59b2455b928280b1&chksm=fe8bb78dc9fc3e9b171c88a3e210fd70e9e44de7ecdfb018b4420f777ab298a10b527b96de8e&scene=21" target="_blank">⊙ 【DB筆試面試90】SQL Server的兩種存儲結構是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772456&idx=2&sn=c63ddc5b99c7743b081c0eea1aeab33d&chksm=fe8bb790c9fc3e86001ba08a8ec37335080109b37dc4f76f1481d2ddca4bfb1b2d5b12087f5f&scene=21" target="_blank">⊙ 【DB筆試面試89】SQL Server、Access、Oracle三種資料庫之間的差別是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772431&idx=2&sn=7697f16ccbabedd86600bc6f7a5c1faf&chksm=fe8bb7b7c9fc3ea151b83aeae1e7e686970e36f45320b7d9c84ab29e98d6adff82570fc8f048&scene=21" target="_blank">⊙ 【DB筆試面試88】學生資訊管理系統中有張表STUDENT，其中，有字段ID、NAME、SEX、BIRTH，請回答如下問題</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772430&idx=2&sn=b0bc78cb2b358bb603449d4263162db5&chksm=fe8bb7b6c9fc3ea02985e292c6004584dbec4bb3821e011784f2fec493f9da9b0efdf237b46d&scene=21" target="_blank">⊙ 【DB筆試面試87】COMMIT操作和ROLLBACK操作的作用是什麼？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772427&idx=2&sn=95d3bcd93246c5fc4902682110f4256e&chksm=fe8bb7b3c9fc3ea5b98c299b6fb78bb0a9db6c161f38681db4b8f67bc744d6b920b9a934d151&scene=21" target="_blank">⊙ 【DB筆試面試86】設有如下關系表。。。供應者：SUPPLIER（SNO，SNAME，CITY）。。。</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772417&idx=2&sn=74f7ac04fe7c1313352483ed35a777de&chksm=fe8bb7b9c9fc3eaf09aacc6f574311ffc4a4cda49102cb8bcfe9cb6377999fa14b6a7c0b7179&scene=21" target="_blank">⊙ 【DB筆試面試85】設教學資料庫中有三個基本表。。。下面的題目都是針對上述三個基本表操作的。</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772415&idx=2&sn=5b0923f538dc9a073428ab78c8466857&chksm=fe8bb7c7c9fc3ed13612219cc1f4717f7e4da765063f61dfe918fc23e54546f9b04e3ee02d2e&scene=21" target="_blank">⊙ 【DB筆試面試84】假設有表資料：TABLE 。。。請寫出獲得此結果的SQL語句。</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772362&idx=2&sn=87faf2346bf13c05c4457e739b163018&chksm=fe8bb7f2c9fc3ee4095ae10f6338f7a26f757f2ff8d465f4e4c7232e31bf3dce0518cee013a8&scene=21" target="_blank">⊙ 【DB筆試面試83】在SQL Server中，（）儲存所有的臨時表和臨時存儲過程</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772360&idx=2&sn=5f772a7ec4b4a69b6a4718279db003f1&chksm=fe8bb7f0c9fc3ee6337469638ab7929ec519cfe92cb1bb749b66d1cefc2ae22de5bc33ec749a&scene=21" target="_blank">⊙ 【DB筆試面試82】在MySQL中，把TEST表的ID列設定為主鍵，并在NAME字段上建立普通索引。</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772358&idx=2&sn=29a0a780ffcd0f627b5be06190da6112&chksm=fe8bb7fec9fc3ee863a0024079f48732582b194c210bce92ffed09a048afeca9ba0766917812&scene=21" target="_blank">⊙ 【DB筆試面試81】在MySQL中，如何檢視建立的使用者OLDLHR擁有哪些權限？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772355&idx=2&sn=8c9866412bb8c90b3427d75f9e4a89c3&chksm=fe8bb7fbc9fc3eedb8c8b3ba575c908e6aca664b4598a3cb664c9af8d2c0ed199abcb2e2f2c9&scene=21" target="_blank">⊙ 【DB筆試面試80】在MySQL中，建立使用者OLDLHR，使之可以管理資料庫OLDLHR</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772353&idx=2&sn=860f7a910768cd55eb6f7de44c4f1b0d&chksm=fe8bb7f9c9fc3eef39781959596b9d12f04215947958c35507973d8f2dfcf43876c65f814b6e&scene=21" target="_blank">⊙ 【DB筆試面試79】MySQL如何查詢SQL語句的執行計劃，進而知道是否使用了索引</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772351&idx=2&sn=8439f4efe6107e6b9ed752ce453f20cf&chksm=fe8bb707c9fc3e11d5999456c511fdc8ad46f895fded4617b65f8b1426c52a71e21a3efea346&scene=21" target="_blank">⊙ 【DB筆試面試78】表USERS中有字段ID，NAME。要求用資料庫腳本實作以下功能，以ID為升序排列，并分頁，每頁10行。</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772346&idx=2&sn=df9caee351afdb4df6de90c81bec7f43&chksm=fe8bb702c9fc3e14cdb40621843e89b4c675b2c4673d97e0e08e3fa7d44aca33290ca33670bc&scene=21" target="_blank">⊙ 【DB筆試面試77】有學生表（學号，姓名，所在系，年齡），找出系内學生平均年齡高于全體學生平均年齡的系資訊，正确的語句是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772322&idx=2&sn=29b7d5a085d5771e138452b398d9870f&chksm=fe8bb71ac9fc3e0cec434a4214b6fbbc88d09f82f9cf0bbbb5f6fae4a515234baa7f5be3b679&scene=21" target="_blank">⊙ 【DB筆試面試76】在UML機制中，關于包和包圖下列說法中錯誤的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772321&idx=2&sn=de505f49918066394751898d2053b051&chksm=fe8bb719c9fc3e0fc1c3e575cc6552103f1b7fe0810665d577f6235352567d8418298e8f25e6&scene=21" target="_blank">⊙ 【DB筆試面試75】關于對SQL對象的操作權限的描述正确的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772286&idx=2&sn=ca0f512ac1b147464c8ee51054da132f&chksm=fe8bb746c9fc3e502c26235ccaf9a288651c5897ccc46e848b69a6fdb9be340221873700100e&scene=21" target="_blank">⊙ 【DB筆試面試74】下列關于鎖的說法錯誤的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772285&idx=2&sn=1dced5690a1e17f69419483927d5772d&chksm=fe8bb745c9fc3e5335639b9f5d01b5e24769cf94d420352457b01acf65adba2802cba6d1d080&scene=21" target="_blank">⊙ 【DB筆試面試73】資料庫系統中部分或全部事務由于無法獲得對需要通路的資料項的控制權而處于等待狀态，并且一直等待下去的一種系統狀</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772280&idx=2&sn=0cc0ecb4ed1e8f9620aff5282d598d15&chksm=fe8bb740c9fc3e56d2260eb60a8ae446017b751a3354805651258209991b263cbb71427a2717&scene=21" target="_blank">⊙ 【DB筆試面試72】将STUDENT表中的年齡屬性的資料類型改為半位元組整數，下列SQL語句中哪一個是正确的？（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772279&idx=2&sn=7063f4f3d7451acb9ee2e68e34d79795&chksm=fe8bb74fc9fc3e59dd313681aff581716715674ac30017e4f9f4ec8453762b89df7a1cb1a2fa&scene=21" target="_blank">⊙ 【DB筆試面試71】有一個關系：（學生學号，姓名，系别），規定學号的值域是8個數字組成的字元串，這一規則屬于下列哪一項限制？（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772278&idx=2&sn=20ccdb5e61bd6a2f3c300356624662ee&chksm=fe8bb74ec9fc3e582c44231a17887d127acc05e1942110bfe18cfce02135aa22ea7682a082f7&scene=21" target="_blank">⊙ 【DB筆試面試70】要為每一位工資低于1000元的女職工加薪200元，下列哪一個是實作上述要求的正确的SQL語句？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772274&idx=2&sn=21392f1f121d1e033b062cade584cc76&chksm=fe8bb74ac9fc3e5cb71617f0a0a1406b5b51c3fefdac99601aba9841bead856acce2dac02969&scene=21" target="_blank">⊙ 【DB筆試面試69】下列關于資料模型的資料限制的叙述中，哪一條是錯誤的？（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772218&idx=2&sn=eb778697ad9026f00239d4c10e7b1b07&chksm=fe8bb482c9fc3d94dce8f7a4efcbf4e9d0775d903b7ed4acc5a2d9b4bba3da10167085605faa&scene=21" target="_blank">⊙ 【DB筆試面試68】下列關于資料庫資料字典的叙述中，哪一條是錯誤的？（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772217&idx=2&sn=039277677b5d0ea7162d97559d17726b&chksm=fe8bb481c9fc3d972b2191451bcea326529547c8072fd6c044dcb8d25de6b5ec21f8ec49eb99&scene=21" target="_blank">⊙ 【DB筆試面試67】在Oracle中，關于表分區下列描述不正确的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772206&idx=2&sn=2a7f90af363fa9b50049819e7417c404&chksm=fe8bb496c9fc3d804817bd152be17934ec0355a86c0461c22bb6c4213ff10f0a07908bc86d63&scene=21" target="_blank">⊙ 【DB筆試面試66】在Oracle中，關于鎖，下列描述不正确的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772204&idx=2&sn=5449dac3fc322b6096a26e8aaaa79617&chksm=fe8bb494c9fc3d8265b7614e5c4b7e2f98e8e9b163a53c545fc8ef8ed2d033d739287706100f&scene=21" target="_blank">⊙ 【DB筆試面試65】在Oracle中，哪一種表分區方式建議的分區數是2的幂（2、4、8等），以獲得最平均的資料釋出（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772203&idx=2&sn=d98ad5814a317a83c18ab786d72115ed&chksm=fe8bb493c9fc3d854906db816d3121938ea46a3e0bc209c01702a1c518291e7f7ce696d2fa6b&scene=21" target="_blank">⊙ 【DB筆試面試64】在Oracle中，以下不屬于集合操作符的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772201&idx=2&sn=e0b8a5afb110b79b8cc4862f9b11076a&chksm=fe8bb491c9fc3d87695821fd8385b7988ccade59c33c837f12199c73df82c5984b9a45f85eb7&scene=21" target="_blank">⊙ 【DB筆試面試63】要以NAME’s address is ADDR格式傳回資料，以下SQL語句正确的是</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772197&idx=2&sn=8341e52e95e97ac7fe759dfa6132cdf5&chksm=fe8bb49dc9fc3d8bed74e316db9aa3dacff655701004b0b817bdb49f105b295c3137c21ea77d&scene=21" target="_blank">⊙ 【DB筆試面試62】下列哪個選項是資料庫技術與并行處理技術相結合的産物，是為了處理大型複雜資料庫管理應用領域中的海量資料而提出的</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772176&idx=2&sn=cd85e8e038d54b25e62c2c0a1d5f53e2&chksm=fe8bb4a8c9fc3dbeaaacbb12bad41336582ab9aa1ac7316976ba33f746e01dd01c5d3ef60c6e&scene=21" target="_blank">⊙ 【DB筆試面試61】以下關于資料模型要求錯誤的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772175&idx=2&sn=024c977f775f1c5c531374f5dcdeaa04&chksm=fe8bb4b7c9fc3da1682f68cb1beafda20460408bb95df608b3c4f639b55afd276579c7da2c05&scene=21" target="_blank">⊙ 【DB筆試面試60】關于E-R圖的叙述正确的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772174&idx=2&sn=9ff1fa29824613d4127d73f29a8695eb&chksm=fe8bb4b6c9fc3da052c21e64fa3d38db6661885d6099b6e6c080953674683e7091f7a5cbda3d&scene=21" target="_blank">⊙ 【DB筆試面試59】以下關于視圖叙述不正确的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772173&idx=2&sn=c8c51be0ff95803c977446880a3cfbef&chksm=fe8bb4b5c9fc3da33c5359609f1eac697e1be52d4c72f358dff45803e16f7cf5aac459325257&scene=21" target="_blank">⊙ 【DB筆試面試58】SQL Server 2000 提供了完全備份、差異備份和日志備份等幾種備份方法，其中差異備份的内容是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772172&idx=2&sn=cd7215ac02b4491d0520c5d3d00e4377&chksm=fe8bb4b4c9fc3da23f8eb3fa2d6906a0f4891400d125db163d75ad633e4bac9eb0241aa4efb2&scene=21" target="_blank">⊙ 【DB筆試面試57】下列關于SQL語言特點的描述中，哪些是正确的？（）（多選題）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772170&idx=2&sn=2c1b62468cafbd1c295f890994ba3c9d&chksm=fe8bb4b2c9fc3da42bfb97b5fa64479b1eacb96e65cf957b45fc3e0144003447410cbb78e745&scene=21" target="_blank">⊙ 【DB筆試面試56】下列關于資料庫三級模式結構的叙述中，哪些是正确的？（）（多選題）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772169&idx=2&sn=e2877d6beab5e7c3a86ba4d3e0f992f2&chksm=fe8bb4b1c9fc3da75c811e234b291796172ef467874563f62d26f59b461b605646b51e52a565&scene=21" target="_blank">⊙ 【DB筆試面試55】在資料庫設計的概念結構設計階段，表示概念結構的常用方法和描述工具是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772159&idx=2&sn=9826d979d14fb2ba943c0bce1aed3ef6&chksm=fe8bb4c7c9fc3dd1dc7f9c49b850954360ec1dd44486033ae2a95e37b4c62d8d0025f9aeaaa5&scene=21" target="_blank">⊙ 【DB筆試面試54】把對表STUDENT的INSERT權限授予使用者user4，并允許其将此權限再授予其他使用者</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772158&idx=2&sn=2f2611dbb30234f4cfeb36ac16a705e2&chksm=fe8bb4c6c9fc3dd0d7e4cf051d78f9bb1e4f6f329abd301af28d73e7c25c3bca44a33eac8c8a&scene=21" target="_blank">⊙ 【DB筆試面試53】在Oracle中，不屬于遊标屬性的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772157&idx=2&sn=b8155051cea83a00be5240ef99fc535a&chksm=fe8bb4c5c9fc3dd34c84612927d43396816d3edcfbc1d60a10670c354532797925c9d5f1628a&scene=21" target="_blank">⊙ 【DB筆試面試52】在Oracle中，下列哪種标量類型不能儲存到資料庫表中（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772156&idx=2&sn=ec1674a984cab6b52ee004a7ca7d1f7f&chksm=fe8bb4c4c9fc3dd2eb4b991257f5d1c26f91b7520a75c25030bef7eeaab04016cf63c408bfae&scene=21" target="_blank">⊙ 【DB筆試面試51】請問序列MY_SEQ的目前值是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772155&idx=2&sn=c4d86a2891e7b73c85997c347d8f8a46&chksm=fe8bb4c3c9fc3dd5b11ef5c8cdbab7360461a2d3182104a93617594244cc12e0ffa1032fd498&scene=21" target="_blank">⊙ 【DB筆試面試50】哪個函數的傳回值不等于-97（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772146&idx=2&sn=9b45cd2fb58da29fc53e70a54f478255&chksm=fe8bb4cac9fc3ddcc688ae35437c202a5375a0b04e534739aa60a6109fcff2fb3f07b697b956&scene=21" target="_blank">⊙ 【DB筆試面試49】在Oracle中，你需要建立索引提高薪水審查的性能，該審查要對員工薪水提高12個百分點後進行分析處理</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772142&idx=2&sn=826ac993e4dabc65a0880c96b0fbe576&chksm=fe8bb4d6c9fc3dc0c90d87404b4c8b9087e3f2e43ede4d35f22bc62105df794ab609b504507b&scene=21" target="_blank">⊙ 【DB筆試面試48】下面哪個選項中的内容填入SQL語句中是正确的（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772121&idx=2&sn=8b4ea34de0a27e3917212fa47d698c8b&chksm=fe8bb4e1c9fc3df72938ab277aa1ec159dd5c87bb968428bc17b75fe774b45fefc501d346831&scene=21" target="_blank">⊙ 【DB筆試面試47】事務的一緻性是指（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772112&idx=2&sn=4cbc9028e07ac9c55f00335c41efc7fb&chksm=fe8bb4e8c9fc3dfed2e434bc2c5700fddf6c9d20df7b1eb45a8f7bec9a6e915285aeb046e5ea&scene=21" target="_blank">⊙ 【DB筆試面試46】存儲過程是存儲在資料庫中的代碼，具有很多優點。下列陳述中不屬于存儲過程優點的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772109&idx=3&sn=21483cd9beb638dbe1aca6940945602a&chksm=fe8bb4f5c9fc3de3198885a4ab94203cda9875062e0be2983df9b0905ec430ed48c1ed65478b&scene=21" target="_blank">⊙ 【DB筆試面試45】以下關于死鎖檢測和恢複叙述錯誤的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772109&idx=2&sn=c43d31d64c91a342351d0fa150f136db&chksm=fe8bb4f5c9fc3de34f82bb35869d0da2b4ca35016623e57458d9895dd55d46baa7bfc5999a05&scene=21" target="_blank">⊙ 【DB筆試面試44】根據資料庫應用系統生命周期模型，完成資料庫關系模式設計的階段是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772107&idx=2&sn=ac638ef67032db84f63881e070452705&chksm=fe8bb4f3c9fc3de5b3d1c584674927593b9f63f37fddbdbdfdce33ba6eb26e7ce276041ba38a&scene=21" target="_blank">⊙ 【DB筆試面試43】事務的持久性是指（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772106&idx=2&sn=2ed24118c6641252fb09efbbabcc17bc&chksm=fe8bb4f2c9fc3de49e795ec6a3363509ef57c3d37286faec10d7c7eddba8f13647d68d249030&scene=21" target="_blank">⊙ 【DB筆試面試42】下面哪一個語句是SQL标準中用來調用存儲過程的（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772105&idx=2&sn=0e35b3b282abb0e8ed6eb6f5e9b2936c&chksm=fe8bb4f1c9fc3de7f0be9913efdbfb0be788ca03daac58c5b8093ee7c41f3c1caf1ee7b36eb5&scene=21" target="_blank">⊙ 【DB筆試面試41】下列實作“将學生的學号和他的平均成績定義為一個視圖”功能的SQL語句中哪一個是正确的？（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772102&idx=2&sn=4387cfe3e04b275372404b8d89295ebb&chksm=fe8bb4fec9fc3de814d199df7d804d8e05ae32ccfdbe2e65258f3c8caeef2acd277a1f10c3a3&scene=21" target="_blank">⊙ 【DB筆試面試40】請問正确實作“查詢張三同學沒有選修的課程的課程号”的SQL語句是下列哪一個？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772101&idx=2&sn=e6546b177e18a94679b6a5c326c3c970&chksm=fe8bb4fdc9fc3debe2d5de8516a2638d36dc0f7681b405f5dd3aa7389a625bde4c36f59989fc&scene=21" target="_blank">⊙ 【DB筆試面試39】删除STUDENT表的DEPT列，但是隻有在沒有視圖或限制引用該列時才能執行删除，否則拒絕删除。</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772100&idx=2&sn=7456ba7c9d8ab20cfc672df0c23837ba&chksm=fe8bb4fcc9fc3dea003e793988c01b647a672459ca367b3b514b5cdfbc5f6e9c9428d14d5d37&scene=21" target="_blank">⊙ 【DB筆試面試38】建立表T1，并使得表中EMPLOYID字段值非空且唯一的SQL語句是下列哪一個？</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772098&idx=2&sn=ba23daaeffcabfd86500ffca08508e1e&chksm=fe8bb4fac9fc3decf506fda0eecd02fcb28e2f4ac6b709d27e9322bb3ca347b5a96862486432&scene=21" target="_blank">⊙ 【DB筆試面試37】下列關于關系模型的參照完整性規則的叙述中，哪一條是錯誤的？（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772097&idx=2&sn=90646ceb2d1fb4edc183d993c8e333cd&chksm=fe8bb4f9c9fc3def695bc9fd09fa50b261beb2de0a1a08ba225b25c6d0d2051b04ef780f34bb&scene=21" target="_blank">⊙ 【DB筆試面試36】下列關于E-R模型和E-R圖的叙述中，哪一條是錯誤的？（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772091&idx=3&sn=e0ca60d1015231d015122aa4499d06a8&chksm=fe8bb403c9fc3d151de7bebe6c0fc78e4cc642b86bc72fec26a3c2c874ee777b5bc085b6fb22&scene=21" target="_blank">⊙ 【DB筆試面試35】下列關于資料字典的叙述中，哪一條是錯誤的？（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772075&idx=3&sn=6e15ecc1ec90c21a7b33bdfb5072c703&chksm=fe8bb413c9fc3d05626a68307e08112c8290baaef66770c23cf3872d86a20ac6e58e2012b1ff&scene=21" target="_blank">⊙ 【DB筆試面試34】Oracle系統程序和作用的描述，說法正确的有（）（多選題）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772070&idx=2&sn=0462aaadd572d48dcd66643b23ff130a&chksm=fe8bb41ec9fc3d08e286234f11df8c24ee20991b870b027b2416fd74c6f53a5d8947b7164f39&scene=21" target="_blank">⊙ 【DB筆試面試33】Which three components does the Scheduler</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772064&idx=3&sn=157c82c8114a1dd3a73a9ee6e6041e27&chksm=fe8bb418c9fc3d0e8a8c562f204225d8c77c758215f4ec8127e5e4e7de3cca16f6de897f655c&scene=21" target="_blank">⊙ 【DB筆試面試32】Which of the following are valid program</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772060&idx=3&sn=2c7a39118304f93a2fcecf385fc317e4&chksm=fe8bb424c9fc3d324212d2b59907896293d067701055e87d2183175944b4f2be065f4fffa250&scene=21" target="_blank">⊙ 【DB筆試面試31】下面是EMP雇員表的資訊，依靠這些資訊完成下面的試題：</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772059&idx=2&sn=9b1851e0238b6693ed57e41fbf40ea2d&chksm=fe8bb423c9fc3d354dc85203b753d419a3c4039f8b09997c57af19d50b8da73a5e3fb75f7345&scene=21" target="_blank">⊙ 【DB筆試面試30】下列SQL指令中，能夠在SQL*PLUS環境下執行特定的腳本檔案的是（）（兩個選項）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772048&idx=3&sn=11f307456e8c8e2232ffabffff5d5c7f&chksm=fe8bb428c9fc3d3e07480413be22e96cec160db522758a13e8512c2a52e62fde88ddf3ad4bd2&scene=21" target="_blank">⊙ 【DB筆試面試29】在用戶端配置本地服務名時，下列資訊中，不需要提供的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772047&idx=3&sn=b7f596f00181e4c540689b83d49bf02b&chksm=fe8bb437c9fc3d2126ded5ad35e3b3febc9a79df87dc8f93cecc165e0d72a92d8286f5b672f6&scene=21" target="_blank">⊙ 【DB筆試面試28】下列關于SQL語句書寫規則的描述中，正确的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772039&idx=3&sn=f3246ec6c9ebbd85669a3ba39cbad789&chksm=fe8bb43fc9fc3d294e57586e2205ccfe560b63603b4ee4af1a63753878517efd4302b0d661ab&scene=21" target="_blank">⊙ 【DB筆試面試27】下列選項中，不屬于SQL語句的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772030&idx=3&sn=f0649897ea26d865a8b83f741bc8b26d&chksm=fe8bb446c9fc3d502023449e7745ba1cab52d34dd9e52c98cab621a88e8a33d8c65bed323e33&scene=21" target="_blank">⊙ 【DB筆試面試26】從用戶端通過SQL*Plus登陸Oracle某個特定使用者，必須要提供的資訊有（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772029&idx=3&sn=cf6fa576e27bbc7162132bc36c79ed8e&chksm=fe8bb445c9fc3d53efd5ccd288557491656921294ad987db6d086251e376182c2f5f591aebce&scene=21" target="_blank">⊙ 【DB筆試面試25】下列有關InnoDB和MyISAM的說法中，正确的是（）（多選題）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772019&idx=3&sn=1180262e3dd0a4f776e8955c5c081b5d&chksm=fe8bb44bc9fc3d5d45a8474533fe64deab0ce74e48c590a46f33e1dd93d480e9234f0ac0a02e&scene=21" target="_blank">⊙ 【DB筆試面試24】Oracle執行個體啟動和關閉的資訊記載到（）中</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772011&idx=2&sn=1b4ff05dad485cce319f869c577a2aef&chksm=fe8bb453c9fc3d45fffd7b6ef9882419c2d0b1482cf45ab95e7b1c269d996ee577c98148be2f&scene=21" target="_blank">⊙ 【DB筆試面試23】SQL語言集資料定義功能、資料操縱功能和資料控制功能于一體。如下所列語句中，屬于資料控制功能的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772010&idx=2&sn=a1b37a378e6722fd5172e7d1f3d9a1d3&chksm=fe8bb452c9fc3d4429acd92f986c5e62e8480e7eae989ad5945067d915d9ae6da6b71405c750&scene=21" target="_blank">⊙ 【DB筆試面試22】SQL語言集資料查詢、資料操縱、資料定義和資料控制功能于一體，其中，CREATE、DROP、ALTER</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772008&idx=2&sn=0971f9046015973ca68e802c220d4bf0&chksm=fe8bb450c9fc3d46f1d01aeef83cd9d3a673f3fb67dc83407ed77726311c6f5c6c04e07db8ef&scene=21" target="_blank">⊙ 【DB筆試面試21】一般資料庫若出現日志滿了，會出現（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454772000&idx=2&sn=8f5364afd6792b3c808ebb6b37d5c5a9&chksm=fe8bb458c9fc3d4eedad82ca1a1176e4a9b4731115ba66df57d9ca3f4977f6d45b70edaeac96&scene=21" target="_blank">⊙ 【DB筆試面試20】下列比較為真的有（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771995&idx=2&sn=092bc4541a841f1e136eb8b5f1d9b5f3&chksm=fe8bb463c9fc3d756c41f279ace79375799a15ae3c07b8d66faebc84508d63d7b9029540fb16&scene=21" target="_blank">⊙ 【DB筆試面試19】下列關于TO_CHAR()、TO_DATE()函數使用過程中不會出錯的有（）（兩個選項）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771983&idx=3&sn=ccf7bc2b0aedd7b58d63697e8d358799&chksm=fe8bb477c9fc3d61561d19a3c659a408cca9f1f283fc74ea5a399ba7b87c949ae9cd698b86d8&scene=21" target="_blank">⊙ 【DB筆試面試18】限制可以防止無效資料進入表中，維護資料一緻性，Oracle提供了若幹種限制，下列描述正确的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771980&idx=2&sn=1983e13d8bb4394fd526313905dec6fb&chksm=fe8bb474c9fc3d6294d01deaa416f2206a7eeecea9257623edcd2f2fcecad1b2159732094e74&scene=21" target="_blank">⊙ 【DB筆試面試17】下列對于視圖的描述中，錯誤的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771971&idx=2&sn=0582a672a4455a476f9ba784e123ec3b&chksm=fe8bb47bc9fc3d6d6f985c1ff3b41830d83d333a61b39dfbc430ffc37cce7fb3ae47bf6f7c2e&scene=21" target="_blank">⊙ 【DB筆試面試16】下列情況中，會導緻Oracle事務結束的有（）（兩個選項）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771967&idx=3&sn=fd9380809589db570759cc86bc152fd9&chksm=fe8bb587c9fc3c91c88c19183e510af97c9c123c79378008b7032da2852c87230c74cc844db4&scene=21" target="_blank">⊙ 【DB筆試面試15】下列語句中使用了列别名，會導緻錯誤的有（）（兩個選項）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771936&idx=2&sn=e1c1413df5fb7d82cd131587bedec828&chksm=fe8bb598c9fc3c8e566a1d07542ed22f056626a6d0aa97024ceefb0ba2b6e4c60e60abf0729d&scene=21" target="_blank">⊙ 【DB筆試面試14】PL/SQL中的注釋符有（）（兩個選項）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771932&idx=4&sn=e29722d953de90fda7531e4a1dc3d214&chksm=fe8bb5a4c9fc3cb217b9aca17c6405c75e4e7cc0279be6b33724ea4b15aacd24756e19429ffa&scene=21" target="_blank">⊙ 【DB筆試面試13】下列關于NULL的描述中，不正确的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771930&idx=2&sn=eff905d19e43be273ad31e4232a26a7a&chksm=fe8bb5a2c9fc3cb4b43e3631df1b270734339bee01cf8502cebec9920703e12ef56dd694dfbf&scene=21" target="_blank">⊙ 【DB筆試面試12】根據題目要求寫出以下50道SQL語句（2）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771928&idx=2&sn=1a69d494f25dfe63fcb0f1b5ca677d1f&chksm=fe8bb5a0c9fc3cb64f2c7c24ab873650700f0ccfc26d50d0a6ba3d1618d29886f22c27442469&scene=21" target="_blank">⊙ 【DB筆試面試11】根據題目要求寫出以下50道SQL語句（1）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771922&idx=2&sn=2a8b1e59c530b3aa5a27177c88194013&chksm=fe8bb5aac9fc3cbc22de1b3bebb9b5da1d948b0024863d790fb9a61037b2ead982d5924cb65e&scene=21" target="_blank">⊙ 【DB筆試面試10】下列選項中，不屬于SQL限制的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771921&idx=2&sn=f4b4b216e763d46d6c34ab4c4f727c00&chksm=fe8bb5a9c9fc3cbf3e649843c872460c832e38e99f9b5fc4ea720ef1f3a2e6217496b9d18254&scene=21" target="_blank">⊙ 【DB筆試面試9】對資料庫第二範式的了解，正确的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771908&idx=2&sn=35f4831e784f796d8c45685a9873e39f&chksm=fe8bb5bcc9fc3caa248780695f5b5bc7b43a51c855e401940ef1b3665282a229a57ab19b9b18&scene=21" target="_blank">⊙ 【DB筆試面試8】小明設計了如下的學籍管理系統，已知關系：</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771894&idx=2&sn=f605c49f7ad63c6051e680cee44d3733&chksm=fe8bb5cec9fc3cd8ddac9f1c022b471d5489e602c76012299e3150d4d822ec313b1fb90c3e2e&scene=21" target="_blank">⊙ 【DB筆試面試7】運作上面的程式，下面選項中哪幾個更改永久儲存到資料庫（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771886&idx=2&sn=ee7a764260894a101c3f8caddf48fc20&chksm=fe8bb5d6c9fc3cc0472677d17e28a43b259df0a18f0f93ece0e2e1a869bd5e6b402f55692825&scene=21" target="_blank">⊙ 【DB筆試面試6】适合建立索引的字段是（）（多選題）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771884&idx=2&sn=856e245d4ced1bc41d1f373fe60d680e&chksm=fe8bb5d4c9fc3cc2f5cebd871f241dbbfa9e83236d9d40c0e125e4afb97e65610600b70ccabf&scene=21" target="_blank">⊙ 【DB筆試面試5】在Oracle資料庫中，下面關于函數的描述正确的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771874&idx=2&sn=3d1c4c8bd6da411d08270a43fc17f8e6&chksm=fe8bb5dac9fc3ccca66ed2b927cda99799846493a4f220a5a791567a87dd51876f7ad04df6a5&scene=21" target="_blank">⊙ 【DB筆試面試4】在Oracle中，關于PL/SQL下列描述正确的是（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771867&idx=2&sn=fe5b2dd02cd48014f6f80f54109951da&chksm=fe8bb5e3c9fc3cf51e7738230c0ca34f2a2a91bcfc58f2f0f46a6fb6852a30e680cd7caf4211&scene=21" target="_blank">⊙ 【DB筆試面試3】下面哪種情況會讓普通使用者連接配接到Oracle資料庫，但不能建立表（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771858&idx=3&sn=c0d80165851b78250d1223b28ca0d29e&chksm=fe8bb5eac9fc3cfcf3e4db4f3307e535df3d7bd0055131802fe7a5b68b113f8cbdcd32969656&scene=21" target="_blank">⊙ 【DB筆試面試2】下面哪個使用者不是Oracle預設安裝後就存在的使用者（）</a>
<a href="http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771853&idx=2&sn=ed153e0924116f9d1d2f8568663f0da2&chksm=fe8bb5f5c9fc3ce3d874ead3c67e3cbd5bcf065ec8329e40c6006e7709755799bfc4b3909e94&scene=21" target="_blank">⊙ 【DB筆試面試1】下列不屬于Oracle的邏輯結構的是（）</a>
本文轉自lhrbest 51CTO部落格，原文連結：http://blog.51cto.com/lhrbest/1903708，如需轉載請自行聯系原作者
![【MySQL資料庫】資料庫索引事務1.索引2.事務[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)