ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question
what is the difference between simple view and complex view?
 Question Submitted By :: Zikku
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the difference between simple view and complex view?
Answer
# 1
A View is said to be simple view it should have a single 
select statement only.Where as a complex view migh contain 
select statement with joins, sub queries etc...
 
Is This Answer Correct ?    2 Yes 0 No
Ramu C
 
  Re: what is the difference between simple view and complex view?
Answer
# 2
A View is said to be simple View when it is created 
using a single table.
      A view is said to be comple view when it is created 
on two or more tables
 
Is This Answer Correct ?    1 Yes 1 No
Priya Reddy
 
 
 
  Re: what is the difference between simple view and complex view?
Answer
# 3
simple view refer the data from only single table. Complex 
view refer data from more than one table. For simple view 
we can use group function(avg,sum etc) but in complex view 
we can use group function.
 
Is This Answer Correct ?    1 Yes 2 No
Niranjan Dhungia
 
  Re: what is the difference between simple view and complex view?
Answer
# 4
sorry for previous ans i had some mistakes....

simple view refers data from only single table but complex 
view can refers data from more than one table. In simple 
view we can not use group function(eg.avg,sum...) but in 
complex view we can use group function.
 
Is This Answer Correct ?    2 Yes 1 No
Niranjan Dhungia
 
  Re: what is the difference between simple view and complex view?
Answer
# 5
A Simple view selects from one table. A Complex view 
selects from one or more tables. 
A Simple view does not contain functions but Complex views 
contain functions. 
You can perform DML through Simple views but you cannot 
always perform DML through Complex views.
 
Is This Answer Correct ?    0 Yes 0 No
Subbu
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
what is load balancing and what u have used to do this?(sql loader)  1
can any one help me with import/export options in oracle............  1
What is the use of Redo Log Information ?  2
What is meant by redo log buffer ?  2
Explain the relationship among Database, Tablespace and Data file?  1
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?  1
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?  1
What is an Index ?  2
How are Indexes Update ?  1
What is the function of Optimizer ?  1
What is a Temporary Segment ?  1
what is the syntax of update command? Semantic-Space1
What is cursor TCS2
What is schema?  9
What is Rollback Segment ?  1
What is autonomous transaction?  4
How you find out version of installed workflow?  1
Define the terms primary key foreign key and also the difference between primary and the unique key  1
when do u go for hash partitioning?  1
What is a Segment ?  1
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com