What is the difference between Primary key and
unique index?
Answer Posted / ankit
IN PRIMARY KEY WE DO NOT ATTACH UNIQUE INDEX BUT IN UNIQUE
INDEX WE CAN ATTACH PRIMARY KEY
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is rct?
Explain what are the various isolation levels possible?
When reorg is used?
What is page size in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Can there be more than one cursor open for any program?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is runstats utility in db2?
Where do you specify them?
What is a dbrm in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Which isolation level provides highest data integrity?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
what is a corelated subquerry?
Explain the function of data manager.