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.
What is Relational Algebra?
How can you save the Business Objects document that may be accessed by all the users in the workgroup mode?
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
Why do we utilize a Multidimensional Array within data structure?
Illustrates the relationship between a queue and underlying array of data structure?
Describe the difference between differential backups and SQL Server 2000 complete?
Explain what is meant by the repository and what does it consists of?
Explain and compare OBE and SQL?
Describe briefly the term a subquery?
Explain the Filter transformation?
18,76,764
1932770 Asked
3,689
Active Tutors
1439614
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!