Explain what is a view as it relates to system modeling?
- 1 Answers
- 1076 Views
- I also Faced
- E-Mail Answers
Answer / Rukhsar Khatoon
A view in system modeling represents a virtual table that doesn't store data but is based on the result of an SQL query. Views allow users to access only specific subsets of data without modifying the underlying tables, improving security and simplifying complex queries.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why is dimensional normalization not required?
What is a functional dependency f said to be minimal?
Briefly state different between data ware house & data mart?
What is aggregate fact table?
What are the differences between star and snowflake schema?
what is Materialized Views?
What is operational data store (ods)?
Where the applications and where ware house management system is used?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What are Aggregate tables?
How can Oracle Materialized Views be used to speed up data warehouse queries?
What is freehand sql?
Teradata 
