How many clustering indexes can be defined for a table?
Answer Posted / s
Only one clustering index can be defined.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Explain the contents that are a part of dclgen.
What is schema in db2?
What is the role of the data page in the db2 database?
Can one database have multiple instances?
What is an instance in db2?
How to find the maximum value in a column in the db2 database?
What parameters are used to control the free space in DB2?
What is meant by union and union all?
What is dbrm in db2 database?
What is the purpose of rollback and commit?
What is bind and rebind in db2?
When do you specify the isolation level?
Are views updateable?
Explain correlated sub-queries.