2016年Oracle DBA創建數據庫練習題及答案
Q. 1 : When will the rollback information applied in the event of a database crash
1. before the crash occurs
2. after the recovery is complete
3. immediately after re-opening the database before the recovery
4. roll back infrmation is never applied if the database crashes
2
Q. 2 : The data dictionary tables and views are stored in
1. USERS tablespace
2. SYSTEM tablespace
3. TEMPORARY tablespace
4. any of the three
3
Q. 3 : Oracle uses the data dictionary tables and views
1. to make the database user friendly
2. to store user data
3. to store application data
4. for proper database functioning
4
Q. 4 : No data in any data dictionary tables should be deleted or altered by any user. Which of the following object is an exception to this rule,
1. AUD$
2. PENDING_SESSIONS$
3. USER_HISTORY$
4. PENDING_TRANS$
1
Q. 5 : A collection of segments is a (an)
1. extent
2. segment
3. tablespace
4. database
3
Q. 6 : When the database is open, which of the following tablespaces must be online
1. SYSTEM
2. TEMPORARY
3. ROLLBACK
4. USERS
1
Q. 7 : Sorts can be managed efficiently by assigning ____ tablespace to sort operations.
1. SYSEM
2. TEMPORARY
3. ROLLBACK
4. USERS
2
Q. 8 : The sort segment of a temporary tablespace is created
1. at the time of the first sort operation
2. when the TEMPORARY tablespace is created
3. when the memory required for sorting is 1kb
4. all of the above
1
Q. 9 : Which of the following segments is self administered
1. TEMPORARY
2. ROLLBACK
3. CACHE
4. INDEX
3
Q. 10 : What is the default temporary tablespace, if no temporary tablespace is defined
1. ROLLBACK
2. USERS
3. INDEX
4. SYSTEM
4
Q. 11 : Rollback segments are used for
1. read consistency
2. rolling back transactions
3. recovering the database
4. all of the above
4
Q. 12 : Rollback segment stores
1. old values of the data changed by each transaction
2. new values of the data changed by each transaction
3. both old and new values of the data changed by each transaction
4. none
1
相關文章
-
Oracle DBA數據庫結構精選試題及答案
這是一款內外都採用反縫製作的揹包,包口採用口金的製作方法,體積不大,容量不小,得益於直上直下的設計,短途旅遊攜帶衣物非常方便,所以稱爲媽媽包或者離家出走包。主要材料:進口掌紋牛皮1.5mm 90x95cm進口掌紋牛皮0.8mm 9 -
2016年Oracle DBA審計數據庫試題
Q. 1 : What feature in oracle allows you to monitor Suspicious Activity on the Datbase1. Replication2. Auditing3. Monitoring4. Tuning Q. 2 : Auditing can be tued on by setting this parameter1. -
Oracle數據庫DBA基礎試題
篇一 三年的函授學習和社會實踐是我不斷的挑戰自我、充實自己的一個過程,本人在思想認識、業務知識和專業技能方面都有了很大的提高。現總結如下:一、思想認識方面:本人明白了只有理論知識而沒有實戰經驗在當今社會是無 -
Adobe Acrobat6試題庫及答案
1、下列關於Adobe Acrobat Reader的敘述正確的是?A CA. Acrobat Reader是可以免費使用的軟件B. Acrobat Reader必須得到Adobe授權才能免費使用C. Acrobat Reader可以在因特網上下載得到D. Acrobat Reader必須通過購買 -
2016年Oracle DBA用戶管理試題及答案
Q. 1 : The default tablespace clause in the create user command sets the location for1. Database Objects created by the user2. Temporary Objects Created By the User3. System Objects Created by the -
2016年Oracle數據庫面試試題及答案
最近很火的一部韓劇《藍色大海的傳說》,劇中全智賢的婚紗造型好美呢,作爲韓國的女明星,全智賢顏值和氣質都是極好的,韓式髮型是亞洲比較流行的,女明星演繹的髮型可是女孩們爭相模仿的,五款全智賢演繹最新韓式髮型趕快來下手 -
Adobe Acrobat試題庫及答案
1、下列關於PDF文件特性的描述錯誤的是?BA. PDF格式被描述爲與應用程序、硬件和操作系統無關。B. PDF文件頁面中可以包含文本、圖像、超級鏈接、聲音和視頻。C. PDF是Portable Document Format的首字母縮寫,亦稱"便攜 -
OracleDBA數據庫性能進行優化
很多的時侯,做Oracle DBA的我們,當應用管理員向我們通告現在應用很慢、數據庫很慢的時侯,我們到數據庫時做幾個示例的Select也發現同樣的問題時,有些時侯我們會無從下手,因爲我們認爲數據庫的各種命種率都是滿足Oracle文檔 -
2016年Adobe認證Illustrator試題及答案
整個村落橫屍遍野,空氣像一張被太陽烤焦的遺書。火烈的陽光饋贈給人們的是死亡。夸父只能眼睜睜地看着自己部落裏的人一個個死去。身爲部落的首領,他卻無力挽救這些人們。當他看見一個將要死去的人靠在枯樹邊時,當他看見 -
Adobe Illustrator CS試題庫及答案
在現實生活或工作學習中,大家總少不了接觸作文吧,作文一定要做到主題集中,圍繞同一主題作深入闡述,切忌東拉西扯,主題渙散甚至無主題。那麼,怎麼去寫作文呢?以下是小編收集整理的長大的感覺真好作文,歡迎閱讀,希望大家能夠喜歡