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 to display top 50 rows?

0 Answers  

Why myisam is faster than innodb?

0 Answers  

What can you do with mysql?

0 Answers  

Is mysql distributed?

0 Answers  

What are the types of database engines available in mysql?

0 Answers  

Does mysql use tcp or udp?

0 Answers  

in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.

1 Answers  

What is action query?

0 Answers  

how to know the tables in database having foreign key?

2 Answers  

What is DML in MySQL?

1 Answers  

Is mysql free download?

0 Answers  

How do I optimize a selected query in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories