view is a logical table that can be created by one or more base table

What is a view? Why use it?

Question Posted / purushothr

Answer Posted / purushothr

view is a logical table that can be created by one or more
base table

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can we retrieve the total number of records in RPG & CLLE?

631

What is performance tuning db2?

1048

What is drop table?

999

Is the primary key a clustered index?

1127

What is a storage group (stogroup)?

1234

Can we insert update delete in view?

949

What is the difference between cursor and select statement?

1081

Mention the different locking levels that are available in db2.

1116

What is view db2?

1051

List out the buffer pools in db2

1060

What is reorg?

1132

Mention the various locks that are available in db2.

1024

What is node in db2?

1033

What is cursor in dbms?

1047

Why do we use cursor?

1084