0

databases Online Quiz - 19

Description: databases Online Quiz - 19
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

How many tables may be included with a join?

  1. 1

  2. 2

  3. 3

  4. all of the above


Correct Option: D
  1. You do not create them with SQL.

  2. They execute against only some applications that access a database.

  3. They have an event, condition, and action.

  4. They cannot cascade (cause another trigger to fire).


Correct Option: C
  1. Log buffer is one-third full

  2. Commit transaction

  3. every three seconds

  4. redo log file switch


Correct Option: A,B,C

Which process kicks in DBWR process?

  1. LGWR

  2. DBWR

  3. CKPT

  4. ARCH


Correct Option: C

Which process creates archive log files?

  1. LGWR

  2. ARCH

  3. ZIP

  4. CKPT


Correct Option: B

Which is the smallest logical unit in Oracle database?

  1. Extent

  2. Block

  3. Segment

  4. Table


Correct Option: B

Which file contains database name, location of data files and important information used to start the Oracle database?

  1. Redo log file

  2. Data file

  3. Archive log file

  4. Control file


Correct Option: D

Give names of different segments.

  1. Data Segment

  2. Index Segment

  3. Table Segment

  4. Rollback Segment

  5. Temporary Segment


Correct Option: A,B,D,E

Which file contains all different Oracle configuration parameters?

  1. Data file

  2. Control file

  3. Parameter file

  4. Redo log file


Correct Option: C

Which Oracle background process performs instance recovery?

  1. PMON

  2. SMON

  3. INSTMON

  4. IMON


Correct Option: B

which are ETL tools

  1. Informatica

  2. Datastage

  3. Abnitio

  4. All the above


Correct Option: D

who is the father of datawarehouse

  1. Bill Inmon

  2. Dennis Ritchie

  3. shiva

  4. Tal mukha talma


Correct Option: A
  1. filter

  2. aggregator

  3. expression

  4. none


Correct Option: C
- Hide questions