Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

could u plz explain about joins and views?

Question Posted / sarathraj

Answers were Sorted based on User's Feedback



could u plz explain about joins and views?..

Answer / vimal

VIEWS
View is a virtual table
If we want to access specific column from specific table we
can go for views
JOINS
Sometimes we have to select data from two or more tables to
make our result complete we have to perform join

Is This Answer Correct ?    3 Yes 0 No

could u plz explain about joins and views?..

Answer / mohsin mohammed abdul

basically we use joins to query a sql with 1 or more tables.
1) self join.. join within the same table using aliases
2) equi join.. join between the 2 tables with commom columns
3) outer join.. and it is divided into 2 catagories left
outer join and right outer join.

View :- its a logical representation of one or more tables.
View doesn't have the data of its own. But still you can
perform DML on a view ..the changes will be done in the
underlying base tables..

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,

What are .mdf files?

0 Answers  

What are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,

How many categories of functions based their return modes?

0 Answers  

What is truncate table?

0 Answers  

What is the command used to check locks in microsoft sql server?

0 Answers  

Explain transaction server auto commit?

0 Answers  

What is RAID? What are the different types of RAID configurations?

0 Answers   Flextronics,

What is the standby server?

0 Answers  

What are the different types of replication? How are they used?

3 Answers  

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

Explain collation?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories