• databases Online Quiz - 18
Back
0

databases Online Quiz - 18

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

which is an unconnected transformation

technology databases

  1. look up

  2. stored procedure

  3. both

  4. none

Show answer
Correct Option: C

How many transformations are there

technology databases

  1. 1

  2. 2

  3. 3

  4. 10

Show answer
Correct Option: B

Datawarehouse is used to load

technology databases

  1. operational data

  2. historical data

  3. both

  4. none

Show answer
Correct Option: B

which one is reporting tool

technology databases

  1. Informatica

  2. Datastage

  3. Cognos

  4. Abnitio

Show answer
Correct Option: C

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

technology databases

  1. constraint based load

  2. e-mail

  3. target load plan

  4. none

Show answer
Correct Option: A

mapping consist of......?

technology databases

  1. source

  2. target

  3. transformations

  4. All the above

Show answer
Correct Option: D

how many transformations are there?

technology databases

  1. 2

  2. 3

  3. 10

  4. 25

Show answer
Correct Option: A

what is datawarehousing?

technology databases

  1. programming language

  2. scripting language

  3. database

  4. operating system

Show answer
Correct Option: C

what is datamart?

technology databases

  1. an variable

  2. subset of datawarehouse

  3. both

  4. none

Show answer
Correct Option: B

How many types of datamarts are there?

technology databases

  1. 2

  2. 3

  3. 4

  4. 5

Show answer
Correct Option: A

Datawarehouse is used to store?

technology databases

  1. historical data

  2. operational data

  3. both

  4. none

Show answer
Correct Option: A

which one is the advantage of datawarehouse?

technology databases

  1. less joins

  2. more indexes

  3. both

  4. none

Show answer
Correct Option: C

what is ODI?

technology databases

  1. operational data store

  2. operating database system

  3. open data source

  4. none

Show answer
Correct Option: A

which one is efficent?

technology databases

  1. top-down approach

  2. bottom-up approach

  3. both

  4. none

Show answer
Correct Option: B

operational data base contains?

technology databases

  1. historical data

  2. partial history

  3. both

  4. none

Show answer
Correct Option: B

SCD type1 is used to store?

technology databases

  1. current data

  2. historical data

  3. both

  4. none

Show answer
Correct Option: A

SCD type 2 stores ?

technology databases

  1. current data

  2. historical data

  3. both

  4. none

Show answer
Correct Option: C

CREATE,ALTER,DROP and TRUNCATE comes under?

technology databases

  1. DML

  2. DDL

  3. DRL

  4. DCL

Show answer
Correct Option: B

INSERT,UPDATE AND DELETE COMES UNDER?

technology databases

  1. DDL

  2. DML

  3. DRL

  4. DCL

Show answer
Correct Option: B

SELECT Statement comes under?

technology databases

  1. DRL

  2. DDL

  3. DML

  4. DCL

Show answer
Correct Option: A
- 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