Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between table and veiw?
- 4 Answers
- 7399 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 |
How to connect the oracle server as sysdba?
what is the use of rank function?
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Is primary key = unique key,not null? If yes,please explain IF No,please explain
7. Repeat query (7) but also display all clients who have never ordered anything.
What is an oracle function?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
How can we delete duplicate rows in a table?
how may join possible between (requisition with purchase order)
What is a dead lock in oracle?
What is the maximum limit on the number of columns in a table?
Oracle General 
