|
INTERVIEW QUESTIONS
ORACLE
DETAILS
Question: What are materialized views?
Answer: These are schema objects that are used to summarize, compute, replicate, and distribute data. They can be used in various environments for computation such as data warehousing, decision support, and distributed or mobile computing and it also provides local access to data rather than accessing from remote sites. In data warehouses, MVs are used to compute and store aggregated data.
|
|
|
Category |
Oracle Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7435 users |
Added on |
5/11/2016 |
Views |
69722 |
Rate it! |
|
|
Question:
What are materialized views?
Answer:
These are schema objects that are used to summarize, compute, replicate, and distribute data. They can be used in various environments for computation such as data warehousing, decision support, and distributed or mobile computing and it also provides local access to data rather than accessing from remote sites. In data warehouses, MVs are used to compute and store aggregated data. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What is an oracle schema?
|
View Answer
|
|
What are the computing components of oracle grid?
|
View Answer
|
|
What is difference between Cartesian Join and Cross Join ?
|
View Answer
|
|
What are the different Oracle Database objects?
|
View Answer
|
|
Difference between varchar and varchar2 data types ?
|
View Answer
|
|
What is difference between Cartesian Join and Cross Join?
|
View Answer
|
|
What are the various constraints used in Oracle ?
|
View Answer
|
|
What are the attributes of Cursor?
|
View Answer
|
|
What are temporal data types in Oracle ?
|
View Answer
|
|
What is a sub query and what are the different types of subqueries?
|
View Answer
|
|
What is the use of Aggregate functions in Oracle?
|
View Answer
|
|
What is USING Clause and give example?
|
View Answer
|
|
What is BLOB datatype?
|
View Answer
|
|
With SQL, how can you return the number of records in the ‘Persons’ table? a) SELECT COLUMNS (*) FROM Persons b) SELECT COLUMNS () FROM Persons c) SELECT COUNTS () FROM Persons d) SELECT COUNTS (*) FROM Persons
|
View Answer
|
|
What is difference between using cursor variable(Ref cursor) and collections(like record with associative array)
|
View Answer
|
|
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each?
|
View Answer
|
|
Explain the difference between a data block, an extent and a segment?
|
View Answer
|
|
What is the function of redo log?
|
View Answer
|
|
What is a redo log?
|
View Answer
|
|
What are the characteristics of data files?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Oracle Interview Questions & Answers - Exam Mode /
Learning Mode
|