Technical - Which is not the characteristic of a view ?

GeekInterview.com > Placement Papers > Birlasoft > Technical

Go To First | Previous Question | Next Question

Technical | Question 4 of 26

Which is not the characteristic of a view ?

a) Consumes Disk space for data
b) Multiple tables
c) Multiple rows
d) Updateable

Answered by Ragini Rani on 2005-05-13 08:59:28: a view does not consume disk space for data

Total Answers and Comments: 6

Last Update: February 05, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: gineous

correct answer is

a) Consumes Disk space for data

BECAUSE VIEWS ARE THE VIRTUAL TABLES WHICH FORMED ON THE EXISTING TABLES OF DATABASE, SO IF WE DO ANY TYPE OF CHANGE IN STORED DATA THAN THIS CHANGE IS MADE UP ON ORIGNAL TABLE NOT IN VIEW,ON THE DISK NAME OF VIEW IS STORED ONLY SO IT COSUME SO LITTLE SPACE.

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

May 13, 2005 08:59:28

Ragini Rani

RE: Which is not the characteristic of a view ?

a view does not consume disk space for data

Is this answer useful? Yes | No

June 20, 2005 14:28:51

Sounak GHOSH

RE: Which is not the characteristic of a view ?

Though it is the right answer but the view definition does take up space in the disk .THough for few views it is less but for hundreds of stored views it does consume space

Is this answer useful? Yes | No

July 18, 2005 14:32:34

anand

RE: Which is not the characteristic of a view ?

[a}views are at the concuptal level so that is the main reason that they dont consume any memory.. as well as no updation is possible on it untill u r not authorised to do that [/B]

Is this answer useful? Yes | No

August 23, 2005 10:37:32

sandeep paliwal

RE: Which is not the characteristic of a view ?

views consumes a little bit space but it is too less to consider...... and all views are not updatable.....views which shows rows of multiple tables can not be updated

Is this answer useful? Yes | No

March 12, 2007 11:38:51

maurya

RE: Which is not the characteristic of a view ?

Ans is (D) not updateable

Is this answer useful? Yes | No

February 05, 2008 00:28:00

gineous

Member Since: January 2008 Contribution: 2

RE: Which is not the characteristic of a view ?

correct answer is

a) Consumes Disk space for data

BECAUSE VIEWS ARE THE VIRTUAL TABLES WHICH FORMED ON THE EXISTING TABLES OF DATABASE SO IF WE DO ANY TYPE OF CHANGE IN STORED DATA THAN THIS CHANGE IS MADE UP ON ORIGNAL TABLE NOT IN VIEW ON THE DISK NAME OF VIEW IS STORED ONLY SO IT COSUME SO LITTLE SPACE.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank