Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between table and veiw?
- 4 Answers
- 7038 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 |
What would you do if a database crashes in production?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
what is candidate key & super key
what is difference between foreign key and reference key
How to omit columns with default values in insert statement in oracle?
How to find no of saturdays in a month using single sql ?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
Where do you use decode and case statements?
if you update view? where we store the data?
What is clusters ?
Explain an index?
Does oracle partitioning improve performance?
Oracle General 
