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 >> MySQL
  2. Suggest New Category

What is the difference between a Table and a View?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is the difference between a Table and a View?..

Answer / guest

Table contains all the row. View doesn't contain any data
but rather an SQL statement that is executed every time the
View is accessed. It provided row level security for
accessing information.
The downside is lost performance as compared to a Table

Is This Answer Correct ?    14 Yes 3 No

What is the difference between a Table and a View?..

Answer / jagdish prajapati

Table is Physical Stored. but View is logical or virtual
Stored.

Is This Answer Correct ?    9 Yes 1 No

What is the difference between a Table and a View?..

Answer / shaik

-Table will have its own data,View doesnt have its own data.

-In Tables data stored Physically,In view its logiacally.

-we have tables of single type,but in views, Simply and
complex views.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do I install mysql on windows 7?

0 Answers  

How to find second highest salary from a table?

0 Answers  

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

0 Answers  

How many rows we can insert in a mysql table?

0 Answers  

How do I rename a table in mysql?

0 Answers  

What is blob in mysql?

0 Answers  

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

0 Answers  

What's the latest version of mysql?

0 Answers  

What is the difference between mysql and pdo?

0 Answers  

What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

0 Answers  

what is collation? how many types of installations in sql server?

3 Answers  

What are procedures in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories