GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Placement Papers  >  Birlasoft  >  Technical

 Print  |  
Question:  Which is not the characteristic of a view ?


Answer: 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


February 02, 2008 00:28:00 #6
 gineous Oracle Expert  Member Since: January 2008    Total Comments: 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.

     

 

Back To Question