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

Write a query to create a database and a table?

0 Answers  

i made a table in sql server 2000 and in a column i want to add image path of a picture present in my hardisk... so using insert statement how will i insert the path of the image in the table??

1 Answers   WebTech,

What are the difference between and myisam and innodb?

0 Answers  

What is DML in MySQL?

1 Answers  

How do I edit a database in mysql workbench?

0 Answers  

How to analyze tables with 'mysqlcheck'?

0 Answers  

How To see all the tables from a database of mysql server.

0 Answers  

If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?

2 Answers  

How we can get distinct columns values in mysql?

0 Answers  

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

0 Answers  

How will show all records containing the name "sonia" and the phone number '9876543210'

0 Answers  

Is mysql a distributed database?

0 Answers  

For more MySQL Interview Questions Click Here
Categories