Interested to Buy Any Domain ? << Click Here >> for more details...
1)what is the difference between view and materilized view?
2)what is the difference between delete and truncate?
3)what is the difference between migration and upgration?
4)what is the difference between RMAN HOT BACKUP and normal
hot backup?
- 2 Answers
- 6136 Views
- 3i Infotech, I also Faced
- E-Mail Answers
Answer Posted / praveen hattikal
1)views , Materialized view or summary tables are subset of
a table filtering out uninteresting rows and columns.The
difference is that views are logical where as MV's are
actual tables.Views pulls real time data when ever queried
but data in MV is rfereshed based on users need.also when
you query a materialized view, you are querying a table,
which may also be indexed. In addition, because all the
joins have been resolved at materialized view refresh time,
you pay the price of the join once (or as often as you
refresh your materialized view), rather than each time you
select from the materialized view .Materialized views are
most often used in data warehousing / business intelligence
applications where querying large fact tables with
thousands of millions of rows would result in query
response times that resulted in an unusable.
2)
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Do we consider null values the same as that of blank space or zero?
Does google have a database like access?
1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?
What is an advantage of a database?
Compare a hierarchical and network database model?
Define phantom deadlock.
What are collection pools? What are the advantages?
What is trigger in dbms?
What is the role of database server in database management system?
What is the sql 'in' clause?
What is atomicity in dbms?
What is the maximum line size that dbms_output can handle?
Define RDBMS.
What is tuple and attribute?
What do you mean by aggregate and scalar functions in dbms?
