Tag: programming languages

Questions Related to programming languages

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

  1. alter database archivelog;

  2. alter database open resetlogs;

  3. alter database mount exclusive

  4. alter system archive log all

Show answer
Correct Option: B

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

  1. PMON

  2. SMON

  3. ARCH

  4. LGWR

Show answer
Correct Option: D

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

  1. SGA

  2. SQL Area

  3. Library Cache

  4. PGA

  5. Shared Pool

Show answer
Correct Option: D

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?

technology programming languages

  1. 120

  2. 140

  3. 144

  4. 240

  5. 400

Show answer
Correct Option: C

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?
technology programming languages

  1. audit

  2. quota

  3. limit

  4. profile

Show answer
Correct Option: D

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

  1. default tablespace

  2. profile

  3. idle_time

  4. default role

Show answer
Correct Option: C

Which command will cause an automatic commit to occur?
technology programming languages

  1. CONNECT

  2. RENAME

  3. SELECT

  4. INSERT

  5. DELETE

Show answer
Correct Option: B

Which Oracle background process is responsible for coalescing free space?
technology programming languages

  1. PMON

  2. SMON

  3. ARCH

  4. LGWR

Show answer
Correct Option: B

The DBWR process is NOT responsible for:
technology programming languages

  1. Defers writes for I/O optimization

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

  3. Writes to database redo log files as people COMMIT data

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

Show answer
Correct Option: C

Which statement about the LGWR is false?
technology programming languages

  1. There is only one redo log writer per instance

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

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

  4. An Oracle instance cannot survive without a redo log writer

Show answer
Correct Option: B