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