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.
Explain the way to audit the SQL sent to the server.
Write down the differentiation between view and materialized view?
What is meant by the Drill Through?
Describe briefly the alternative terminology which is employed in the relational model?
Under what conditions should indexes are employed?
Explain terms Data Cache in Sybase. Answer: It is the memory area where data which is required for the current queries running is bought by Disk upon to memory for
Determine the concept of Relation Schema and a Relation?
State the difference between the class and universe?
Explain the term DataStage and Informatica?
When must you seem de-normalization?
18,76,764
1931878 Asked
3,689
Active Tutors
1429302
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!