GeekInterview.com
Series: Subject: Topic:
Question: 99 of 385

difference between simple view and complex view?

Asked by: sharada y | Member Since May-2007 | Asked on: May 29th, 2007

View all questions by sharada y

Showing Answers 1 - 2 of 2 Answers
rajakumar_na

Answered On : Nov 17th, 2007

View all answers by rajakumar_na

FeatureSimple ViewsComplex ViewsNumber of tablesOneOne or moreContain functionsNoYesContain groups of dataNoYesDML operations through a viewYesNot alwaysRegards,Rajakumar.N

  
Login to rate this answer.
Bahadar Ayaz

Answered On : Jul 20th, 2011

Here are few differences between simple and complex views.

1. A Simple view selects from one table. A Complex view selects from one or more tables.
2. A Simple view does not contain functions but Complex views contain functions.
3. You can perform DML through Simple views but you cannot always perform DML through Complex views.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.