What is the difference between a package and a plan?
Answer Posted / krishna priya
plan contains multiple DBRMs.but packag contains single
DBRMs as well as when package will excuated include the
list of plans
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What is a Foreign Key?
Define db2 and its databases?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is buffer pool in the db2 database?
What is the difference between db2 and oracle?
What is the maximum number of columns in a db2 table?
What is explain plan in db2?
What is dbrm? When it will be created?
How many types of page locks can be held in db2?
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 in brief how does db2 determine what lock-size to use?
What is the difference between dbm cfg and db cfg file in db2 ?
Are view updateable?
What is the role of union all and union