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

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

Application reterieves data from database buffer cache is referred as

  1. Cache hit

  2. Cache miss

  3. Cache init

  4. Cache success

Correct Option: A

Various buffers are internally managed by database buffer cache

  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

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
  1. Shared Pool

  2. Java Pool

  3. Large Pool

  4. Redo log buffer

Correct Option: C

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

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

BB Manager can be accessed through

  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

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