Tag: databases

Questions Related to databases

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