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 |
Post New Answer View All Answers
can all users have the privilage to use the sql statement select * (dml)?
What is db2 and what is the use of db2 optimizer?
Explain the benefits you can get from mainframe connect?
What is dbrm? What it contains? When it will be created?
What is with ur in db2?
What is a bind in db2?
What is the connection string to connect to the DB2 Database ?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Explain the function of data manager.
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is difference between isnull and coalesce?
Mention the different locking levels that are available in db2.
what is a corelated subquerry?
What is buffer pool?
What is the difference between cursor and select statement?