databases Online Quiz - 18 Online Test

0

databases Online Quiz - 18

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

which is an unconnected transformation

technology databases

look up
stored procedure
both
none

How many transformations are there

technology databases

1
2
3
10

Datawarehouse is used to load

technology databases

operational data
historical data
both
none

which one is reporting tool

technology databases

Informatica
Datastage
Cognos
Abnitio

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

technology databases

constraint based load
e-mail
target load plan
none

mapping consist of......?

technology databases

source
target
transformations
All the above

how many transformations are there?

technology databases

2
3
10
25

what is datawarehousing?

technology databases

programming language
scripting language
database
operating system

what is datamart?

technology databases

an variable
subset of datawarehouse
both
none

How many types of datamarts are there?

technology databases

2
3
4
5

Datawarehouse is used to store?

technology databases

historical data
operational data
both
none

which one is the advantage of datawarehouse?

technology databases

less joins
more indexes
both
none

what is ODI?

technology databases

operational data store
operating database system
open data source
none

which one is efficent?

technology databases

top-down approach
bottom-up approach
both
none

operational data base contains?

technology databases

historical data
partial history
both
none

SCD type1 is used to store?

technology databases

current data
historical data
both
none

SCD type 2 stores ?

technology databases

current data
historical data
both
none

CREATE,ALTER,DROP and TRUNCATE comes under?

technology databases

DML
DDL
DRL
DCL

INSERT,UPDATE AND DELETE COMES UNDER?

technology databases

DDL
DML
DRL
DCL

SELECT Statement comes under?

technology databases

DRL
DDL
DML
DCL

- Hide questions