2006年资格考试OracleDBA数据库结构题选2

文章作者 100test 发表时间 2007:03:14 13:25:34
来源 100Test.Com百考试题网

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 0deleted 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