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?
Answers were Sorted based on User's Feedback
2)Truncate is a DDL command, which has autocommit hence
cant be rolled back where as delete is DML with user commit
& roll back option. Truncate is faster then delete since it
wont store any data to backup tablespace. before delting.
Is This Answer Correct ? | 8 Yes | 0 No |
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 |
What is the normal procedure followed by a java client to access the db?
where a Database Procedure is stored ?
Which is better saving files in database or in file system?
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
State three differences between Dbms and Rdbms?
What is a trigger?
What are the objectives of rdbms?
Is it possible to modify a Datatype of a column when column contains values?
What is default value database?
Explain the advantages of rdbms?
What is dbms introduction?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?