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

This question is related to BirlaSoft Interview

Interview Candidate
Aug 23rd, 2005
6
7527

Showing Answers 1 - 6 of 6 Answers

Ragini Rani

May 13th, 2005

a view does not consume disk space for data

Sounak GHOSH

Jun 20th, 2005

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

anand

Jul 18th, 2005

[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]

sandeep paliwal

Aug 23rd, 2005

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

maurya

Mar 12th, 2007

Ans is (D), not updateable

gineous
Profile Answers by gineous

Feb 5th, 2008

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.