Can you define an Index if the table size less than 10
PAGES?
Answer / s
You do not want to define an index on such a small table
because, its an overhead to maintain the index and
tablespace scan will only result in 1 I/O.
| Is This Answer Correct ? | 6 Yes | 2 No |
What does db2 blu stand for?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
How does coalesce work?
wht happens if we close cursor with cursor with hold option?
What is the format (internal layout) of ?TIMESTAMP??
What is an alias?
what is a trigger and types of triggers
What os does db2 run on?
What is meant by index cardinality?
When is the skeleton cursor table created?