Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between table and veiw?
- 4 Answers
- 7104 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 many types of synonyms in Oracle?
Explain the use of compress option in exp command.
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
why dont we assign not null constraint as table level constraint.
How to define an anonymous block?
How to connect to a remote server?
Where are the settings stored for each instance in oracle?
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
How to drop a stored procedure in oracle?
What are operators in oracle?
What is the difference between sharding and partitioning?
What is clustered table in Oracle?
Oracle General 
