0

databases Online Quiz - 18

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

which is an unconnected transformation

  1. look up

  2. stored procedure

  3. both

  4. none


Correct Option: C

How many transformations are there

  1. 1

  2. 2

  3. 3

  4. 10


Correct Option: B

Datawarehouse is used to load

  1. operational data

  2. historical data

  3. both

  4. none


Correct Option: B

which one is reporting tool

  1. Informatica

  2. Datastage

  3. Cognos

  4. Abnitio


Correct Option: C

how to load data in target using primary and foreign keys through?

  1. constraint based load

  2. e-mail

  3. target load plan

  4. none


Correct Option: A

mapping consist of......?

  1. source

  2. target

  3. transformations

  4. All the above


Correct Option: D

how many transformations are there?

  1. 2

  2. 3

  3. 10

  4. 25


Correct Option: A
  1. programming language

  2. scripting language

  3. database

  4. operating system


Correct Option: C

what is datamart?

  1. an variable

  2. subset of datawarehouse

  3. both

  4. none


Correct Option: B
  1. historical data

  2. operational data

  3. both

  4. none


Correct Option: A
  1. less joins

  2. more indexes

  3. both

  4. none


Correct Option: C
  1. operational data store

  2. operating database system

  3. open data source

  4. none


Correct Option: A

which one is efficent?

  1. top-down approach

  2. bottom-up approach

  3. both

  4. none


Correct Option: B

operational data base contains?

  1. historical data

  2. partial history

  3. both

  4. none


Correct Option: B

SCD type1 is used to store?

  1. current data

  2. historical data

  3. both

  4. none


Correct Option: A

SCD type 2 stores ?

  1. current data

  2. historical data

  3. both

  4. none


Correct Option: C

CREATE,ALTER,DROP and TRUNCATE comes under?

  1. DML

  2. DDL

  3. DRL

  4. DCL


Correct Option: B

INSERT,UPDATE AND DELETE COMES UNDER?

  1. DDL

  2. DML

  3. DRL

  4. DCL


Correct Option: B
- Hide questions