Database Administration - Do a view contain data

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 11 of 231

Do a view contain data

Total Answers and Comments: 4

Last Update: July 11, 2007

Sponsored Links

Best Rated Answer

—

Submitted by: onkar

The answer depends on the type of view. in case of normal view, the ans is NO it only contains query based on a base table but in case of materialized view, YES it does contain data and for the updated data in the base table , it needs to be refreshed.

Above answer was rated as good by the following members:
amitkw

June 18, 2005 00:30:54

soccer_champ

RE: Do a view contain data

A view does not contain any data of its own but is like a window through which data from other tables can be viewed and changed.

Is this answer useful? Yes | No

August 24, 2005 02:09:11

Shrikant Pande

RE: Do a view contain data

NO : Because view is for view one or more tables data like query.

Is this answer useful? Yes | No

October 03, 2005 06:22:18

onkar

RE: Do a view contain data

The answer depends on the type of view. in case of normal view the ans is NO it only contains query based on a base table but in case of materialized view YES it does contain data and for the updated data in the base table it needs to be refreshed.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

July 11, 2007 03:34:07

vbrahmaiah

Member Since: July 2007 Contribution: 1

RE: Do a view contain data

No it does not contain own data

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank