Tag: databases

Questions Related to databases

Which is the Oracle version used in CEMS?

technology databases

  1. 10.2.0.1

  2. 10.2.0.3

  3. 10.2.0.2

  4. 10.2.0.4

Show answer
Correct Option: D

Oracle Instance comprises of

technology databases

  1. Physical files

  2. Memory buffers

  3. Background processes

  4. Database

Show answer
Correct Option: B,C

SGA size is defined by parameter
technology databases

  1. SGA_SIZE

  2. SGA_TARGET

  3. SGA_TARGET_SIZE

  4. SGA_INIT_SIZE

Show answer
Correct Option: B

PGA memory is allocated for each server process.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Application reterieves data from database buffer cache is referred as

technology databases

  1. Cache hit

  2. Cache miss

  3. Cache init

  4. Cache success

Show answer
Correct Option: A

Various buffers are internally managed by database buffer cache
technology databases

  1. free buffers

  2. dirty buffers

  3. pinned buffers

  4. access buffers

Show answer
Correct Option: A,B,C

How we can configure PGA area in Oracle?
technology databases

  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

Show answer
Correct Option: B

Redo log buffer data is used for recovery.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which process writes redo log buffer to redo log files?

technology databases

  1. DBWR

  2. LGWR

  3. CKPT

  4. ARCH

Show answer
Correct Option: B