What is the difference between base table and view?
Answers were Sorted based on User's Feedback
Answer / ashok
base table has physical existence, whereas views r virtual
tables
Is This Answer Correct ? | 38 Yes | 2 No |
Answer / bhushan
Base table is the Physical table and views are the virtual
tables where its physical existence will not be there.
Is This Answer Correct ? | 21 Yes | 2 No |
Answer / sunanda
Views:
1. This is one type of relation which is not a part of the
physical
database.
2. It has no direct or physical relation with the database.
3. Views can be used to provide security mechanism.
4. Modification through a view (e.g. insert update delete)
generally
not permitted
Base Relation:
1. A base relation is a relation that is not a derived relation.
2. While it can manipulate the conceptual or physical
relations stored
in the data.
3. It does not provide security.
4. Modification may be done with a base relation.
We can assign the view a name & relate it the query
expression as
Create View <View Name> as <Query Expression>
Let EMPLOYEE be the relation. We create the table EMPLOYEE
as follows:-
Create table EMPLOYEE
(Emp_No integer of null
Name char (20)
Skill chars (20)
Sal_Rate decimal (10 2)
DOB date
Address char (100) )
For a very personal or confidential matter every user is not
permitted to see the Sal_Rate of an EMPLOYEE. For such users
DBA can
create a view for example EMP_VIEW defined as:-
Create view EMP_VIEW as
(Select Emp_No Name Skill DOB Address
From EMPLOYEE)
Is This Answer Correct ? | 13 Yes | 2 No |
Answer / ankit
base tables have physical table which does havefacility to
select any condition and save but view is part of a base
table but diffrence is in view we can select columns and
rows using conditions in view creating
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / priya
using views complex queries can be solved easily
as it provides multiple table join facility
Is This Answer Correct ? | 2 Yes | 0 No |
How many databases are there?
Explain in detail about buffer manager and its functionalities?
Can you access the DB2 Directory table using SQL?
List out the three types of page locks that can be held.
What is the advantage in De-normalizing tables in DB2?
What is UNION,UNION ALL?
How to view db2 table structure?
What is lock escalation in db2?
What is buffrpool? Where we use it ?
What is a thread?
Name the lockable units in DB2?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error