Procedure and a trigger
Explain and compare a procedure and a trigger?
Expert
Triggers are controlled and stored in the DBMS. A trigger is performed automatically when a condition is met (or INSERT, UPDATE, or DELETE). A procedure is also stored in a DBMS. A procedure is not performed automatically.
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
Define the term data aggregation?
Another company used statistic in reports is the total number of orders placed by a shopper. Complete the following steps to create a function named NUM_PURCH_SF that accepts a shopper id and returns the total number of orders the shopper has placed. Use the function in a SELECT statement to display
Illustrates the way to assign an address to an element of a pointer array? Answer: We can assign a memory address to an element of an array of pointers by usin
Explain Triggers and Rules?
Describe the some drawbacks of a standard language like SQL?
Define the class?
What does it mean when we say that a relation is in Boyce-Codd Normal Form (BCNF)?
Illustrates the quickest sorting method to use?
What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?
18,76,764
1923950 Asked
3,689
Active Tutors
1416601
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!