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 drill mode?
What are the types of prompt?
Elucidate Where to keep informatica rejected data? How to remove the informatica rejected data?
What is meant by the fact table?
Another company used statistic in reports is the total number of orders placed by a shopper. Complete the following steps to create a function named NUM_PURCH_SF that accepts a shopper id and returns the total number of orders the shopper has placed. Use the function in a SELECT statement to display
Write down the brief note on the differentiations between Normalizer and Normalizer transformation?
In Sybase illustrates the term Table Partitioning?
State difference between Passive and Active transformation?
Provide the formula for the Pearson’s r.
Give brief introduction of the term ‘Service Broker components’?
18,76,764
1926774 Asked
3,689
Active Tutors
1460332
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!