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 CKPT process is optional; which process assumes these duties if CKPT is not active?
PMON
SMON
ARCH
LGWR
Which component of an instance holds session variables and arrays when you are NOT running in MTS mode?
SGA
SQL Area
Library Cache
PGA
Shared Pool
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?
120
140
144
240
400
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?
audit
quota
limit
profile
The DBA is creating a new user. Which of the following is NOT defined at user creation
default tablespace
idle_time
default role
Which command will cause an automatic commit to occur?
CONNECT
RENAME
SELECT
INSERT
DELETE
Which Oracle background process is responsible for coalescing free space?
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