OracleDBA数据库结构试题选2Oracle认证考试

文章作者 100test 发表时间 2009:04:29 22:02:23
来源 100Test.Com百考试题网

1
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$

5　
q. 5 : a collection of segments is a (an)
1. extent
2. segment
3. tablespace
4. database

6　
q. 6 : when the database is open, which of the following tablespaces must be online
1. system
2. temporary
3. rollback
4. users