Shortcut Navigation:

Coalescing Free Quiz

Which component of an instance holds session variables and arrays when you are NOT running in MTS mode?

Which Oracle background process is responsible for coalescing free space?

The CKPT process is optional; which process assumes these duties if CKPT is not active?

The DBWR process is NOT responsible for:

Which statement about the LGWR is false?

The storage parmeters for a given table are: INITIAL=100, NEXT=100, MINEXTENTS=2, MAXEXTENTS=10, PCTINCREASE=20. If the first 3 extents are filled, what will the size of the FOURTH extent be?

Assume the database administrator wanted to limit the amount of idle time that any one user could have during a given session. Which of the following would be used to enforce such a limit?

Discarding redo logs is done with which of the following statements?

The DBA is creating a new user. Which of the following is NOT defined at user creation?

Which of the following background processes is used for coalescing free extents, in case dictionary managed tablespaces are used?

Tagged as: coalescing free, coalescing free, process
Home | About | Create | Register | Privacy | Terms | Sitemap | [Facebook] [Twitter] [Google+]