Answer Posted / dave ian
the number of UNIQUE values for a column or columns, which
are part of an index.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is check constraint. Explain with example.
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
List out the three types of page locks that can be held.
What is db2? Explain.
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is dbrm? When it will be created?
What is ibm db2 used for?
What is syscat in db2?
What is dclgen (declaration generator)?
Are view updateable?
What is access path in db2?
Mention the downsides of page level lock.
Which command is used to connect to a database in DB2 ? Give the Syntax.
Why do we need reorg in db2?