0

databases Online Quiz - 133

Description: databases Online Quiz - 133
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Buffer cache

  2. Dictionary cache

  3. Library cache

  4. Parse cache


Correct Option: C
  1. DBWn (Writes the dirty buffers to datafiles)

  2. LGWR (writes the redo log buffer data to online redo log files)

  3. CKPT (An Event that flushes the modified data in buffer cache to disk and updates the controlfile and datafile)

  4. ARCn (Copies online redo log file to another location before they are overwritten)


Correct Option: D
  1. Database, tablespace, extent, segment, block

  2. Database, tablespace, segment, extent, block

  3. Database, segment, tablespace, extent, block

  4. Database, extent, tablespace, segment, block


Correct Option: B
  1. Sort area

  2. Program Global Area

  3. Library cache

  4. Large pool


Correct Option: C,D

What is the minimum number of online redo log files required in a database?

  1. One

  2. Two

  3. Four

  4. Zero


Correct Option: B

Which view will contain the name of the database?

  1. V$database

  2. v$controlfile

  3. v$log

  4. V$DB


Correct Option: A
  1. Sort area

  2. Program Global Area

  3. Library cache

  4. Large pool


Correct Option: C,D
  1. ingres start

  2. start ingres

  3. ingstart

  4. startup


Correct Option: C
  1. lockstat

  2. logstat

  3. lock manager

  4. ipm


Correct Option: D
  1. accessdb

  2. rollforwarddb

  3. restoredb

  4. dbrestore


Correct Option: B
  1. unloaddb

  2. downloaddb

  3. copydb

  4. movedb


Correct Option: A
- Hide questions