Which of the following is not true for a segmented table space?

When is the access path determined for dynamic SQL?

If a user accidentally drops a table and commits work, which of the following recovers the dropped table?

How many clustering indexes can be defined for a table?

Which is true when joining a table with DB2 Relational Connect function?

What does the term IMAGECOPY mean?

Given the code: EXEC SQL DECLARE cursor1 CURSOR FOR SELECT name, age, b_date FROM person; EXEC SQL OPEN cursor1; Under which of the following situations will the above cursor be implicitly closed?

Why is a primary key needed on a table?

Is the autorestart parameter configurable on-line?

Parameter that would specify the maximum size of a memory segment?

When is it best to tune your system?