Shortcut Navigation:

Page Content
Site Navigation
Footer

Create

This
Quiz

Hello Guest,
100 points

Quiz Survey Challenge

Quizific is the easiest free and fun way to take or make a quiz or survey About Help Contact/Follow > Tag Cloud Our Competition Sitemap Thanks!

Stats

Facebook

Twitter

Google+

Temporary Profile Forgot Password? Create Account

Profile Logout

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:

Defers writes for I/O optimization

Uses a LRU algorithm to keep most recently used blocks in memory

Writes to database redo log files as people COMMIT data

Writes all changed (i.e. dirty) buffers to datafiles

Which statement about the LGWR is false?

There is only one redo log writer per instance

A commit confirmation may be issued before a transaction has been recorded in the redo log file

During long transactions Oracle can flush data to the redo logs before it is committed.

An Oracle instance cannot survive without a redo log writer

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?

alter database archivelog;

alter database open resetlogs;

alter database mount exclusive;

alter system archive log all;

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?

Please fix these errors before submitting your responses

Please wait, your data is being saved...

This quiz is tagged as: coalescing free, coalescing free, process