Explain the EXPLAIN statement?
Answer / s
EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.
Is This Answer Correct ? | 1 Yes | 1 No |
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
How to create db2 table in mainframe?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
What is a Resource Control Table(RCT)? Describe its characteristics.
What is a Cartesian product?
What is meant by isolation level?
What is isolation level?
What is cursor stability in db2?
What is the use of runstats in db2?
WHAT IS MEANT BY COMMIT COMMAND?
how to resolve -805. give clear explination for that
What is the physical storage length of the data types: date, time, timestamp in the db2 database?