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 Switch (select or use) to a database.

0 Answers  

How do I setup mysql?

0 Answers  

how do i list constraints in my database by using sql server2000?

1 Answers  

What is mysql default database?

0 Answers  

Define REGEXP?

0 Answers  

Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

0 Answers  

Give string types available for column?

0 Answers  

How to find out the second largest element from mysql table

15 Answers  

How many values can the SET function of MySQL take?

2 Answers   Creative Informatics,

How to get the number of rows selected or affected by a sql statement?

0 Answers  

What is the difference between database and table?

0 Answers  

Can you tell the difference between ereg_replace() and eregi_replace()?

0 Answers  

For more MySQL Interview Questions Click Here
Categories