• databases Online Quiz - 133
Back
0

databases Online Quiz - 133

Description: databases Online Quiz - 133
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Which component of the SGA contains the parsed SQL code?

technology databases

  1. Buffer cache

  2. Dictionary cache

  3. Library cache

  4. Parse cache

Show answer
Correct Option: C
Explanation:

To answer this question, the user needs to have knowledge of Oracle's System Global Area (SGA) and its components. The SGA is a shared memory area that stores data and control information for Oracle database instances. The components of the SGA include the buffer cache, the shared pool, and the large pool.

The parsed SQL code is stored in the Library Cache, which is part of the shared pool. The Library Cache is a part of the SGA that stores shared SQL and PL/SQL areas. These areas contain parsed and executable forms of SQL and PL/SQL statements.

Therefore, the correct answer to this question is:

The Answer is: C. Library cache

Which one is not mandatory background process ?

technology databases

  1. DBWn (Writes the dirty buffers to datafiles)

  2. LGWR (writes the redo log buffer data to online redo log files)

  3. CKPT (An Event that flushes the modified data in buffer cache to disk and updates the controlfile and datafile)

  4. ARCn (Copies online redo log file to another location before they are overwritten)

Show answer
Correct Option: D

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

technology databases

  1. Database, tablespace, extent, segment, block

  2. Database, tablespace, segment, extent, block

  3. Database, segment, tablespace, extent, block

  4. Database, extent, tablespace, segment, block

Show answer
Correct Option: B

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

  1. One

  2. Two

  3. Four

  4. None

Show answer
Correct Option: A

Which memory structures are shared? Choose two.
technology databases

  1. Sort area

  2. Program Global Area

  3. Library cache

  4. Large pool

Show answer
Correct Option: C,D

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

  1. One

  2. Two

  3. Four

  4. Zero

Show answer
Correct Option: B

Which view will contain the name of the database?
technology databases

  1. V$database

  2. v$controlfile

  3. v$log

  4. V$DB

Show answer
Correct Option: A

Which memory structures are shared? Choose two.
technology databases

  1. Sort area

  2. Program Global Area

  3. Library cache

  4. Large pool

Show answer
Correct Option: C,D

How do you check the user sessions in formatted mode?
technology databases

  1. iinamu

  2. iimonitor

  3. ipm

  4. accessdb

Show answer
Correct Option: B

How do you check the database consistency?
technology databases

  1. infodb

  2. ckpdb

  3. jnl

  4. accessdb

Show answer
Correct Option: A

What is the command used to manually commit the transactions?
technology databases

  1. accessdb

  2. rollforwarddb

  3. infodb

  4. lartool

Show answer
Correct Option: D

How many ingres server processes are mandatory?
technology databases

  1. 1

  2. 2

  3. 3

  4. 4

Show answer
Correct Option: D

Command to start ingres?
technology databases

  1. ingres start

  2. start ingres

  3. ingstart

  4. startup

Show answer
Correct Option: C

What is the utility to monitor ingres locks

technology databases

  1. lockstat

  2. logstat

  3. lock manager

  4. ipm

Show answer
Correct Option: D

Command to restore ingres database to valid state.
technology databases

  1. accessdb

  2. rollforwarddb

  3. restoredb

  4. dbrestore

Show answer
Correct Option: B

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

  1. True

  2. False

Show answer
Correct Option: A

What is the utility to used for database user management?

technology databases

  1. accessdb

  2. infodb

  3. tempdb

  4. userdb

Show answer
Correct Option: A

What is the utility for data migration?

technology databases

  1. unloaddb

  2. downloaddb

  3. copydb

  4. movedb

Show answer
Correct Option: A

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

technology databases

  1. Oracle

  2. IBM

  3. Teradata

  4. Microsoft

Show answer
Correct Option: C

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

technology databases

  1. Vertica

  2. Sybase IQ

  3. ParAccel

  4. SAND

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions