Question 1

Which component of the SGA contains the parsed SQL code?

technology databases

Buffer cache
Dictionary cache
Library cache
Parse cache

Answer

Correct Option: C

Question 2

Which one is not mandatory background process ?

technology databases

DBWn (Writes the dirty buffers to datafiles)
LGWR (writes the redo log buffer data to online redo log files)
CKPT (An Event that flushes the modified data in buffer cache to disk and updates the controlfile and datafile)
ARCn (Copies online redo log file to another location before they are overwritten)

Answer

Correct Option: D

Question 3

Choose the correct hierarchy, from largest to smallest, from this list of logical database structures.

technology databases

Database, tablespace, extent, segment, block
Database, tablespace, segment, extent, block
Database, segment, tablespace, extent, block
Database, extent, tablespace, segment, block

Answer

Correct Option: B

Question 4

RAC has more then ....instance associated with database.

technology databases

One
Two
Four
None

Answer

Correct Option: A

Question 5

Which memory structures are shared? Choose two.

technology databases

Sort area
Program Global Area
Library cache
Large pool

Answer

Correct Option: C,D

Question 6

What is the minimum number of online redo log files required in a database?

technology databases

One
Two
Four
Zero

Answer

Correct Option: B

Question 7

Which view will contain the name of the database?

technology databases

V$database
v$controlfile
v$log
V$DB

Answer

Correct Option: A

Question 8

Which memory structures are shared? Choose two.

technology databases

Sort area
Program Global Area
Library cache
Large pool

Answer

Correct Option: C,D

Question 9

How do you check the user sessions in formatted mode?

technology databases

iinamu
iimonitor
ipm
accessdb

Answer

Correct Option: B

Question 10

How do you check the database consistency?

technology databases

infodb
ckpdb
jnl
accessdb

Answer

Correct Option: A

Question 11

What is the command used to manually commit the transactions?

technology databases

accessdb
rollforwarddb
infodb
lartool

Answer

Correct Option: D

Question 12

How many ingres server processes are mandatory?

technology databases

1
2
3
4

Answer

Correct Option: D

Question 13

Command to start ingres?

technology databases

ingres start
start ingres
ingstart
startup

Answer

Correct Option: C

Question 14

What is the utility to monitor ingres locks

technology databases

lockstat
logstat
lock manager
ipm

Answer

Correct Option: D

Question 15

Command to restore ingres database to valid state.

technology databases

accessdb
rollforwarddb
restoredb
dbrestore

Answer

Correct Option: B

Question 16

Is ingres net server a mandate server process for user connection to database?

technology databases

True
False

Answer

Correct Option: A

Question 17

What is the utility to used for database user management?

technology databases

accessdb
infodb
tempdb
userdb

Answer

Correct Option: A

Question 18

What is the utility for data migration?

technology databases

unloaddb
downloaddb
copydb
movedb

Answer

Correct Option: A

Question 19

Which company tops the 2008 Gartner's Magic Quadrant for DW?

technology databases

Oracle
IBM
Teradata
Microsoft

Answer

Correct Option: C

Question 20

This is the first column-oriented database to hit the data warehousing market.

technology databases

Vertica
Sybase IQ
ParAccel
SAND

Answer

Correct Option: B

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

databases Online Quiz - 133

Find more quizzes from top tags