Tag: databases

Questions Related to databases

Shared Pool comprises of following components.

technology databases

  1. Library Cache

  2. Data Buffer Cache

  3. Data Dictonary Cache

  4. SQL buffer cache

Show answer
Correct Option: A,C

Transactions throughput is slower when data found from buffer cache.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Following is the optional area of SGA.
technology databases

  1. Shared Pool

  2. Java Pool

  3. Large Pool

  4. Redo log buffer

Show answer
Correct Option: C

Instance recovery is perfomed by which process?

technology databases

  1. SMON

  2. PMON

  3. IMON

  4. INSTMON

Show answer
Correct Option: A

Cursor bind information is stored in which area of PGA.

technology databases

  1. Cursor and SQL area

  2. Private SQL area

  3. Data Dictonary Cache

  4. Data Buffer Cache

Show answer
Correct Option: B

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

  1. LGWR

  2. DBWR

  3. PMON

  4. CKPT

Show answer
Correct Option: B

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

technology databases

  1. Shared Pool

  2. Data Dictionary Cache

  3. Data Buffer Cache

  4. Library Cache

Show answer
Correct Option: B

BB Manager can be accessed through

technology databases

  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

Show answer
Correct Option: B

Can activation password for the user once set be deleted?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

technology databases

  1. MDS

  2. BB Messaging agent

  3. Attachment service

  4. Controller

Show answer
Correct Option: B