First page Back Continue Last page Graphics

Intro to Oracle9i Workshop B


Notes:

Workshop 1B
What is an instance?
The SGA is a shared memory area that contains the buffer cache. TRUE or FALSE
The buffer cache increase database performance be keeping recently used data blocks in memory, lowering physical I/O counts. TRUE or FALSE
The database can be accessed even if the instance is not started. TRUE or FALSE
What object can be created to eliminate the need to include the schema name in a reference to another users object?
What object can be created to improve the performance of a query?
Workshop continues on the next page…