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.
Specify various tools in the Business Objects 5.1?
Elucidate briefly the term metadata reporter?
Explain the difference between heterogeneous and homogeneous distributed database?
Define the term environment variables?
Explain the linked universes?
Demonstrate some of the techniques which can be employed to tune operational performance?
Elucidate Where to keep informatica rejected data? How to remove the informatica rejected data?
Name the methods that are available in storing sequential files?
State the use of data stage jobs?
What is Data Manipulation Language?
18,76,764
1945388 Asked
3,689
Active Tutors
1425526
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!