Triggers in DBMS
Name four applications which are employing for triggers in DBMS?
Expert
The main four applications which are employing for triggers in DBMS are as follows:
(i) Offering default values. (ii) Implementing data constraints.(iii) Updating the views.(iv) Implementing referential integrity.
Illustrates the term tkprof and how is this used?
Write down a short note on the difference between an ERD and EER.
Describe briefly the difference between pessimistic locking and optimistic locking?
Write out the disadvantages of using the Alias?
Describe briefly the term data warehouse?
Explain the Stored Procedure transformation?
Briefly describe the fundamental stages of Data Warehousing?
Describe the term HOLAP.
Give brief introduction of the term breakpoint in SSIS?
Give a brief differentiation between Dimensional Modeling and ER Modeling?
18,76,764
1939929 Asked
3,689
Active Tutors
1451720
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!