What is the difference between base table and view?
- 7 Answers
- 31475 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 sql abend code -801,-802?
What is the maximum No of rows per page?
What are column-name qualifiers used?
What happens to a cursor after a commit?
can any body explain about plan and pakage in detail....
What is the SQL query to select, delete and get count of duplicate rows in DB2?
how can u understand the end of the table ?
What is null value in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
what is db2 restart?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
How do you Load a table ?? and what is Load replace ?
COBOL 
