What do you understand by the term SQL view
What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?
Expert
A SQL view is a virtual table built from other views or tables. Views are employed to:
(i) Hide rows or columns.(ii) Represent the results of computed columns, (iii) Hide difficult SQL syntax.(iv) Layer built-in functions.(v) Offer a level of indirection among application programs and tables. (vi) Assign various setups of processing permissions to tables.(vii) Assign various setups of triggers to the similar table.
Give a brief introduction of the term active data warehousing?
Explain the four kinds of indexes?
Specify the various components of the Report Net?
Explain some of the data mining tools.
Briefly describe the new features of SQL Server 2005 Analysis Services (or SSAS)?
Specify the different application areas of the data mining.
What are the properties of Isoquants?
Write a short note on the difference between a dynamic and materialized view?
Illustrate stored procedures, and how do they are distinct from triggers?
define types of transaction failures and also what is meant by catastrophic failure?
18,76,764
1948173 Asked
3,689
Active Tutors
1437391
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!