What are Most Common types of Complex master-det

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

(Continued from previous question...)

279. What are Most Common types of Complex master-detail relationships?

There are three most common types of complex master-detail relationships: master with dependent details master with independent details detail with two masters

(Continued on next question...)

Other Job Interview Questions

• What is a deadlock?
• Index Clusters
• Schema
• How would you change all occurrences of a value using VI?
• What are the triggers available in the reports?
• What is a VIEW? How to get script for a view?
• Give the sequence of execution of the various report triggers?
• Where would you look for errors from the database engine?
• What are the different types of Record Groups?
• Shall we create procedures to fetch more than one record?
• More...