Answer / babji009

A view is a virtual table made up of data from base
tables and other views, but not stored separately.
Ex:
CREATE VIEW GOOD1_SUPPLIERS
AS SELECT S#, STATUS, CITY
FROM S
WHERE STATUS > 15;
SELECT * FROM GOOD1_SUPPLIERS;

---------+---------+---------+---------+-----------
SELECT * FROM GOOD1_SUPPLIERS;
---------+---------+---------+---------+-----------
S# STATUS CITY
---------+---------+---------+---------+---
S3 40 PARIS
S4 110 LONDON
S8 30 ATHENS
S7 20 U.S.A

Answer / om yadav

after a table is created and populated with data, it may
become necessary to prevent all users from accessing all
column of a table, for data security reasons.
To reduce redundant data to the minimum possible, allows the
creation of an object called VIEW.
Define:= A VIEW is mapped , to a select sentence. The SELECT
clause consists of a sub-set of the columnb of the table.
thus a view , which is mapped to a table, will in effect
have a sub-set of the actual column of the table from which
it is bulit.

This technique offers a simple, effective way of hiding
column of the table.

Can you define an Index if the table size less than 10 PAGES?

1 Answers   IBM,

---

What is dbrm? When it will be created?

0 Answers  

---

What is the use of value function?

0 Answers  

---

What information is held in SYSIBM.SYSCOPY?

1 Answers  

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

select 100 records from million records ?

2 Answers   Verizon,

---

What are the disadvantages of PAGE level lock?

3 Answers  

---

What is cascading rollback?

0 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,

---

What is the clustering index in the db2 database?

0 Answers  

---

What is a dbrm in db2?

0 Answers  

---