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.
List out the factors included while selecting the data mining system.
Is it possible that two tasks be assigned to the similar Partition in Sybase?
Explain how do you produce the Sequence number within the Data stage?
Define the term filter?
What is meant by star schema?
Explain about the Buffer Manager in relational database management system.
Explain the uses of stored procedure?
Define the term OCI?
What is Redundant Array of Inexpensive Disks and what are various types of RAID configurations?
Illustrates the way to save space while inserting rows monotonically?
18,76,764
1949787 Asked
3,689
Active Tutors
1450320
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!