DB2 is a
A) data base/data communication system
B) data base
C) RDBMS
D) Programming language
Answers were Sorted based on User's Feedback
Answer / ankit
data base 2 is data base and data communication system
which help rdbms to specific operation on any database or
solve any queries.
Is This Answer Correct ? | 2 Yes | 0 No |
Explain various types of locks 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.
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is deadlock in db2?
What is db2 connect?
What is index cardinality?
What is a synonym ?
What do you need to do before you do EXPLAIN ?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Define buffer pool.
Can we update view in db2?