what is the datatype of the surrgate key ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

what is the datatype of the surrgate key ?

Datatype of the surrgate key is either inteeger or numaric or number

(Continued on next question...)

Other Job Interview Questions

• What is BUS Schema?
• What is the main differnce between schema in RDBMS and schemas in DataWarehouse....?
• Why fact table is in normal form?
• what is junk dimension? what is the difference between junk dimension and degenerated dimension?
• Why should you put your data warehouse on a different system than your OLTP system?
• Differences between star and snowflake schemas?
• What is ER Diagram?
• What is VLDB?
• What is data mining?
• What is the difference between Datawarehousing and BusinessIntelligence?
• More...