0

databases Online Quiz - 29

Description: databases Online Quiz - 29
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Physical files

  2. Memory buffers

  3. Background processes

  4. Database


Correct Option: B,C
  1. SGA_SIZE

  2. SGA_TARGET

  3. SGA_TARGET_SIZE

  4. SGA_INIT_SIZE


Correct Option: B
  1. free buffers

  2. dirty buffers

  3. pinned buffers

  4. access buffers


Correct Option: A,B,C
  1. Specifying size of memory for each server process

  2. Specifying size of total memory for all server process

  3. No way to define

  4. Specifying size of seperate memory and total memory for all server processes


Correct Option: B

Which process writes redo log buffer to redo log files?

  1. DBWR

  2. LGWR

  3. CKPT

  4. ARCH


Correct Option: B
  1. Library Cache

  2. Data Buffer Cache

  3. Data Dictonary Cache

  4. SQL buffer cache


Correct Option: A,C

Transactions throughput is slower when data found from buffer cache.

  1. True

  2. False


Correct Option: B

Following is the optional area of SGA.

  1. Shared Pool

  2. Java Pool

  3. Large Pool

  4. Redo log buffer


Correct Option: C
  1. Cursor and SQL area

  2. Private SQL area

  3. Data Dictonary Cache

  4. Data Buffer Cache


Correct Option: B

Background process responsible to write contents of database buffer to data files.

  1. LGWR

  2. DBWR

  3. PMON

  4. CKPT


Correct Option: B
  1. Shared Pool

  2. Data Dictionary Cache

  3. Data Buffer Cache

  4. Library Cache


Correct Option: B
  1. Start > Programs > Blackberry manager

  2. Start > Programs > Blackberry Enterprise Server > Blackberry manager

  3. Start >Blackberry Enterprise Server > Blackberry manager

  4. Start > Control Panel > Blackberry Enterprise Server > Blackberry manager


Correct Option: B
  1. YES

  2. NO

  3. Yes but for version 5.0 and above

  4. none


Correct Option: C
- Hide questions