Tag: databases

Questions Related to databases

Which datatype can store large and unstructured data such as text, image, video?
technology databases

  1. BLOB

  2. CLOB

  3. NCLOB

  4. BFILE

  5. ALL

Show answer
Correct Option: E

Find the odd one out?
technology databases

  1. MicroStrategies

  2. Actuate

  3. Siebel Analytics

  4. Cognos DecisionStream

Show answer
Correct Option: D

______ facts that cannot be summed up for any of the dimensions present in the fact table. For Example, temparature,bill number...etc

technology databases

  1. Additive facts

  2. semi-additive facts

  3. Non-additive facts

  4. Fact less fact

Show answer
Correct Option: C

The dimension tables in a star schema data mart that adhere to a common structure, and therefore allow queries to be executed across star schemas is called _______. (Note: For example, the Calendar dimension)
technology databases

  1. Degenerated dimension

  2. Slowly changing dimensions

  3. Conformed dimensions

  4. Junk dimension

Show answer
Correct Option: C

Which one of the following is not a feature of a Data Warehouse

technology databases

  1. Time - Variant

  2. Non Volatile

  3. Integrated

  4. Process Oriented

Show answer
Correct Option: D

Data Warehouse's are highly normalized for better query perfomance
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Data Marts are designed by ETL Developers to break the data into chuncks so that data retrival is easy for Business Analysts
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Data Cleansing is mainly done at which phase of Data Warehouse Development
technology databases

  1. Extract

  2. Transform

  3. Load

  4. None of the Above

Show answer
Correct Option: B

The Facts in a Data Warehouse should always be numeric and nothing else
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which one of the following is not a dimension
technology databases

  1. Sales

  2. Audit

  3. Degenarate

  4. Person

Show answer
Correct Option: A