Answer Posted / 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)

What is bind and rebind in db2?

1135

---

What is the difference between dbm cfg and db cfg file in db2 ?

1531

---

What is view db2?

1068

---

What is the use of predicate?

1040

---

What is dpf in db2?

1104

---

What is the clustering index in the db2 database?

1001

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2388

---

What is a db2 tablespace?

1061

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3152

---

How do I delete a table in db2?

1064

---

How do I create a view in db2?

1022

---

What is catalog database in db2?

1162

---

Which isolation level provides maximum concurrency?

1150

---

What is meant by union and union all?

1008

---

Define db2 and its databases?

1055

---