Give the two types of tables involved in produci

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

(Continued from previous question...)

14. Give the two types of tables involved in producing a star schema and the type of data they hold.

Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

(Continued on next question...)

Other Job Interview Questions

• What use of command line parameter cmd file?
• What is Parallel Server?
• If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
• How would you go about generating an EXPLAIN plan?
• What is snapshots?
• What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode?
• What are the ways to monitor the performance of the report?
• How do you add a data file to a tablespace?
• Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
• What is the difference between OLE Server & OLE Container?
• More...