DB Administration interview questions – page 19

How to use mapping parameters and what is their use

What is standard parameter at database creation?

Differences between star and snowflake schemas?

Why are OLTP database designs not generally a good idea for a Data Warehouse?

What type of indexes?

What is Extractor?

How to store and retrieve the image from the database in sqlserver 2005.Plz specify the codes related to this...

What is the definitions for Datawarehose and Datamart?

What are aggregations?

What is the Difference between View and Stored Procedure?

What is the difference between rollup and scan?

What is the difference between a data warehouse and a data mart?

Difference between c++ class and oracle database design?

Can a Data Warehouse also be used for Transaction Database?

What does dependency analysis mean in Ab Initio?

How you implement trace of query when user run query what is syntax ?

What is the difference between LOOK UP File Stage and LookUP stage ?

Your query return 80 % data from table is it we use index or not why ?

What r the joiner caches?

What are Data Marts?

What is lock and latch?

I don't set user dump test parameter where trace file default store on linux platform.

Any inbuilt utility of oracle available which make database mirroring ?

How are the Dimension tables designed?

How can u recover the session in sequential batches?

Why is Data Modeling Important?

What is Virtual Data Warehousing?

What are datasets?

What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

What are the benefits of data warehousing?