Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is a materialised view?

Answers were Sorted based on User's Feedback



What is a materialised view?..

Answer / velmurugan uk

Materialised view is a snopshot/Copy of data(where data can
come out of select query) which can be refresed over a
period of time.

Is This Answer Correct ?    5 Yes 0 No

What is a materialised view?..

Answer / rashid ansari

materialized view is database object.it just like nomal
view but u can maniputale into mateialized view.when u
fatch data from remotly,materialized view provide fater
fatching data from remote database.when user manipulate on
actual table then simply refersh to materlized view
automatically update materlized view.

Is This Answer Correct ?    2 Yes 0 No

What is a materialised view?..

Answer / deva

Its the data of the remote database. When we queried for
the data at the remote database/schema, the data/resuls set
is known as the materialized view.

Is This Answer Correct ?    1 Yes 1 No

What is a materialised view?..

Answer / riddhi

1) view don't store data whereas mview contains copy of data
2) performance of mview is better then view
3)view contains updated data whereas mview not contain up to date Data because there is an activity of data refresh in mview

Is This Answer Correct ?    0 Yes 0 No

What is a materialised view?..

Answer / amme singh

rashid ansari ans is right

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle General Interview Questions

what is difference between table and view? where to use views? thanks in advance!

1 Answers  


In which language oracle has been developed?

0 Answers  


what are the things that you consider while creating indexes on partitioning tables?

1 Answers  


In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

0 Answers  


How to assign values to variables?

0 Answers  


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

0 Answers   EDC,


What is a sub query? Describe its types?

0 Answers  


How to load data from external tables to regular tables?

0 Answers  


Explain oracle insert into command?

0 Answers  


how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  


How to shutdown your 10g xe server from command line?

0 Answers  


What is bulk collect in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)