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 Redundant Array of Inexpensive Disks and what are various types of RAID configurations?
Explain the Filter transformation?
What is meant by the fact table?
Describe briefly perform recovery?
Explain the term version Control?
What types of tables derived from the ERD?
Write a brief note on a distributed database?
Why do normalized tables need more complex SQL when SQL statements are employed in application programs?
State the types of users in the Business Objects?
Explain different domain which is there in BO?
18,76,764
1929273 Asked
3,689
Active Tutors
1430338
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!