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

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

  1. SGA_SIZE

  2. SGA_TARGET

  3. SGA_TARGET_SIZE

  4. SGA_INIT_SIZE


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

  4. INSTMON


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