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)

Which component is responsible for processing sql statements and selecting access paths?

1074

---

What is db2 plan table?

995

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1137

---

What are the two types of logging in the db2 database? Explain them.

1019

---

What is difference between isnull and coalesce?

1010

---

How do I delete a table in db2?

1010

---

What is a db2 table?

958

---

What are the benefits of using the db2 database?

1156

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2868

---

How to retrieve rows from a db2 table in embedded sql?

1328

---

What is the use of db2?

1009

---

Can we update view in db2?

946

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2181

---

What is db2 purescale?

945

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1976

---