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複習知識點彙總
Oracle認證考試由Oracle公司授權國際考試認證中心對考生進行資格認證的。那麼Oracle認證考試複習要點有哪些呢?下面跟yjbys小編一起來學習吧!descemp;顯示emp表的結構selectcount(*)FROMemp;統計記錄條數count(*)是統計函數SELECT*FROMemp;查詢所有的列SELECTe...
-
Oracle數據庫的基本介紹
數據庫名、實例名、數據庫域名、全局數據庫名、服務名,這是幾個令很多初學者容易混淆的概念。相信很多初學者都與我一樣被標題上這些個概念搞得一頭霧水。下面yjbys為大家分享關於數據庫的介紹及Oracle數據庫的學習教程!一、數據庫名什麼是數據庫名?數據庫名就...
-
Oracle認證基本介紹
Oracle雖然規模很大,但名聲不像微軟、IBM那樣顯赫,很多非計算機專業的在校學生不知道Oracle是何物。但是如果你是一位想在畢業後進入IT行業的學生,那麼,你必須知道什麼是Oracle。首先,Oracle是一家軟件公司。這家1977成立於加利福尼亞的軟件公司是世界上第一個推出...
-
Oracle認證簡介
Oracle認證是由Oracle公司,為能夠滿足對Oracle核心人士需求,Oracle公司頒佈並實施的一項權威品的服務與支持。並具有嫻熟的專業技術標準,它是專為認證那些有操作能力與廣泛理論知識的專業人。標準:Oracle認證證書只是讓僱主瞭解到來應聘的'人通過了Oracle數據庫方...