Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between table and veiw?
- 4 Answers
- 7393 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rinku kharkia
table is physical presentation of database but view is
logicl presentation of database
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / udayah shankar dokku
Table: A table is defined as set of rows, a table
describes an entity.
View : view is a logical table ,which is defined as one or
more tables,a view is never stored in to database, when we
define view a view definition is stored in to dase
table,views are mainly used for security & information hiding
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / prasanna
Table will display the all columns,The table will be stored
in database. where as View is a virtual table that will not
stored in the database.The columns will be hiden while
giving the report to the users.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sanjay kumar
View is a virtual presentation of data of a one or more tables and view is strongly recommended about the security purpose but table has own space in database and present data as physically existence .
| Is This Answer Correct ? | 1 Yes | 0 No |
Differentiate between TRUNCATE and DELETE?
What is sharded cluster?
How to create an oracle database manually?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
What is a Shared SQL pool ?
Why is oracle so popular?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
How to save query output to a local file?
What is Library Cache in Oracle?
How to declare a local variable?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
What is a materialised view?
Oracle General 
