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
责任编辑:小草