Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between base table and view?
- 7 Answers
- 32852 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 |
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
How does DB2 use multiple table indexes?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
How many Buffer pools are there in DB2 and what are they?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
What is a cursor?
What is subquery ?
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
What is access path in db2?
What does runstats do in db2?
wht is d/f between union and joins ?
What is a DB2 access path?
COBOL 
