Name the triggers which support SQL Server 2000
Name the triggers which support SQL Server 2000?
Expert
SQL Server 2000 supports AFTER and INSTEAD OF triggers only. The BEFORE triggers cannot be supported by any SQL server. A table might have one or more AFTER triggers for update, insert and delete actions; AFTER triggers might not be assigned to views. A view or table might have at most one INSTEAD OF trigger for each and every triggering action of update, insert or delete.
What do you understand by the term denormalization and why would someone consider doing so?
What do you understand by the termed dependency graph in DBMS?
State the different advantages of the data warehousing?
Explain the loops?
Illustrates the term data sparsity and how this effect upon aggregation?
Describe briefly the difference between a Java applet and a Java servlet?
Explain the term precision in Data Structures? Answer: Precision considers as to the accuracy of the decimal portion of a value. It is the number of digits permitted
Give a brief introduction of the term real time data-warehousing?
Explain what is Designer?
Specify the different application areas of the data mining.
18,76,764
1950621 Asked
3,689
Active Tutors
1430479
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!