Answer Posted / s
Base table is created by using CREATE TABLE and the table
description is stored in Catalog table SYSTABLES. The
definition and data are persistant.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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.
What is performance tuning db2?
What is image copy in db2?
Can one database have multiple instances?
What is db2 catalog database?
What is dbrm? What it contains? When it will be created?
What is cascading rollback?
Explain how can you do the explain of a dynamic sql statement?
Define check constraint.
Explain in detail about buffer manager and its functionalities?
What parameters are used to control the free space in DB2?
Which isolation level provides maximum concurrency?
Which component is responsible for processing sql statements and selecting access paths?
What are types of indexes?
What db2 400?