Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between base table and view?
- 7 Answers
- 32833 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 Skeleton cursor table (SKCT)?
What is coalesce in db2?
How can we read records for specific member in CL? AND rpg?
what is cursor stability?
What is iseries database?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is database reorganization?
What does the sqlcode of -818 pertain to?
how can we retrieve the 100 records of the file ?
wht steps we need will coding cobol and db2 pgm ?
What is dbrm in db2 database?
What is copy book?
COBOL 
