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
责任编辑：小草
您现在的位置： 