DB Administration interview questions – page 20

How to modify already created table?

What is SCD1 , SCD2 , SCD3?

What is the difference between stored procedures and stored functions in ORACLE

What are non-additive facts?

What is VLDB?

What are conformed dimensions?

What are the possible data marts in Retail sales.?

What are the methodologies of Data Warehousing.?

What are the various Reporting tools in the Market?

What is conformed fact?

What is a linked cube?

What is degenerate dimension table?

What is a general purpose scheduling tool?

What are the different architecture of data warehouse?

Name some of modeling tools available in the Market?

Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs.

What type of Indexing mechanism do we need to use for a typical data warehouse?

Is there any opening for DBA

How will you find out if your database is using recovery catalog or not?

Wht r the data types present in bo?n wht happens if we implement view in the designer n report

What is OLTP?

After creating tables dynamically in the Teardata, where is the GRANT table option usually done ? When tables are newly created, what is the default role and what the default privileges which get assigned ?

What is an optimization and performance tuning and how does it really work in practical projects. can i get any example to better understand?

What is the installation difference between SQL 2005 & SQL 2008 cluster?

What is log table? What is the use of log table?

How many codd's rules are satisfied by teradata database?

What is a mutating table error and how can you get around it?

What is the difference between data block/extent/segment?

Whats the difference between indexes, views, synonyms?

Does SDLC changes when you use Teradata instead of Oracle?