OracleDBA数据库结构试题选2

文章作者 100test 发表时间 2007:03:14 13:26:49
来源 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