Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between base table and view?
- 7 Answers
- 32561 Views
- I also Faced
- E-Mail Answers
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 |
what is the responsibility of the construction superintendent
What is the SQL query to select, delete and get count of duplicate rows in DB2?
Where is the access path logic created by the DB2 Optimizer stored?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
What does DML stand for and what are some examples of it?
How to check table size in db2 sap?
How to handle null values in db2
What is universal database?
Why use RUNSTAT Utility?
what is static sql? what is dynamic sql? Give me details
What is deadlock in db2?
COBOL 
