Question 1

Oracle Instance comprises of

technology databases

Physical files
Memory buffers
Background processes
Database

Answer

Correct Option: B,C

Question 2

SGA size is defined by parameter

technology databases

SGA_SIZE
SGA_TARGET
SGA_TARGET_SIZE
SGA_INIT_SIZE

Answer

Correct Option: B

Question 3

PGA memory is allocated for each server process.

technology databases

True
False

Answer

Correct Option: A

Question 4

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

technology databases

True
False

Answer

Correct Option: B

Question 5

Application reterieves data from database buffer cache is referred as

technology databases

Cache hit
Cache miss
Cache init
Cache success

Answer

Correct Option: A

Question 6

Various buffers are internally managed by database buffer cache

technology databases

free buffers
dirty buffers
pinned buffers
access buffers

Answer

Correct Option: A,B,C

Question 7

How we can configure PGA area in Oracle?

technology databases

Specifying size of memory for each server process
Specifying size of total memory for all server process
No way to define
Specifying size of seperate memory and total memory for all server processes

Answer

Correct Option: B

Question 8

Redo log buffer data is used for recovery.

technology databases

True
False

Answer

Correct Option: B

Question 9

Which process writes redo log buffer to redo log files?

technology databases

DBWR
LGWR
CKPT
ARCH

Answer

Correct Option: B

Question 10

Shared Pool comprises of following components.

technology databases

Library Cache
Data Buffer Cache
Data Dictonary Cache
SQL buffer cache

Answer

Correct Option: A,C

Question 11

Transactions throughput is slower when data found from buffer cache.

technology databases

True
False

Answer

Correct Option: B

Question 12

Following is the optional area of SGA.

technology databases

Shared Pool
Java Pool
Large Pool
Redo log buffer

Answer

Correct Option: C

Question 13

Instance recovery is perfomed by which process?

technology databases

SMON
PMON
IMON
INSTMON

Answer

Correct Option: A

Question 14

Cursor bind information is stored in which area of PGA.

technology databases

Cursor and SQL area
Private SQL area
Data Dictonary Cache
Data Buffer Cache

Answer

Correct Option: B

Question 15

Background process responsible to write contents of database buffer to data files.

technology databases

LGWR
DBWR
PMON
CKPT

Answer

Correct Option: B

Question 16

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

technology databases

Shared Pool
Data Dictionary Cache
Data Buffer Cache
Library Cache

Answer

Correct Option: B

Question 17

BB Manager can be accessed through

technology databases

Start > Programs > Blackberry manager
Start > Programs > Blackberry Enterprise Server > Blackberry manager
Start >Blackberry Enterprise Server > Blackberry manager
Start > Control Panel > Blackberry Enterprise Server > Blackberry manager

Answer

Correct Option: B

Question 18

Can activation password for the user once set be deleted?

technology databases

True
False

Answer

Correct Option: B

Question 19

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

technology databases

MDS
BB Messaging agent
Attachment service
Controller

Answer

Correct Option: B

Question 20

Can IT policy be deleted and dispatched viz BB Manager?

technology databases

YES
NO
Yes but for version 5.0 and above
none

Answer

Correct Option: C

Description: databases Online Quiz - 29
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 29

Find more quizzes from top tags