Explore BrainMass
Share

Structured Query Language (SQL) in Practice

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

1. Briefly explain the use of views.

2. Explain the paradigm mismatch between SQL and programs.

3. Name four applications for triggers.

4. Discuss stored procedures.

5. What are the advantages of using stored procedures?

© BrainMass Inc. brainmass.com March 21, 2019, 12:54 pm ad1c9bdddf
https://brainmass.com/computer-science/sql/structured-query-language-sql-practice-83372

Solution Preview

1. Briefly explain the use of views.

Views are used to hide columns or rows, show the results of computed columns, hide complicated SQL syntax. Views also provide a level of indirection between application programs and tables. Views can also be used to assign different sets of processing permissions to tables and to assign ...

Solution Summary

Structured Query Language (SQL) in Practice is modeled.

$2.19