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 do you understand by the term snapshot replication in DBMS?
Explain the mapping of ERD to DFD?
Why recursive relationships are not good? How do you solve them?
Describe the some drawbacks of a standard language like SQL?
How can we handled are recursive relationships in a database design? Describe briefly?
What is meant by the Data warehouse?
Explain the command line functions which export and import the DS jobs?
What are sequences, and what are the possible problems when employing them to make surrogate keys?
Briefly describe the differentiation between data warehouse and OLAP?
18,76,764
1921753 Asked
3,689
Active Tutors
1432390
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!