databases Online Quiz - 29

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

Oracle Instance comprises of

  1. Physical files

  2. Memory buffers

  3. Background processes

  4. Database

Correct Option: B,C

SGA size is defined by parameter





Correct Option: B

PGA memory is allocated for each server process.

  1. True

  2. False

Correct Option: A

We can access data of database before session has been established.

  1. True

  2. False

Correct Option: B
  1. free buffers

  2. dirty buffers

  3. pinned buffers

  4. access buffers

Correct Option: A,B,C

How we can configure PGA area in Oracle?

  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

Redo log buffer data is used for recovery.

  1. True

  2. False

Correct Option: B

Which process writes redo log buffer to redo log files?

  1. DBWR

  2. LGWR

  3. CKPT

  4. ARCH

Correct Option: B

Shared Pool comprises of following components.

  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

Instance recovery is perfomed by which process?

  1. SMON

  2. PMON

  3. IMON


Correct Option: A

Cursor bind information is stored in which area of PGA.

  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

When SQL query is parsed then it will look first definitions of table exist in following area.

  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

Can activation password for the user once set be deleted?

  1. True

  2. False

Correct Option: B

Which Blackberry service connects to mail serverto provide e-mail, calendar, address lookup, attachment and wireless encryption key generation?

  1. MDS

  2. BB Messaging agent

  3. Attachment service

  4. Controller

Correct Option: B
  1. YES

  2. NO

  3. Yes but for version 5.0 and above

  4. none

Correct Option: C
- Hide questions