Question: Consider the following SQL statement: CREATE TABLESPACE TS 3 . . . PCTFREE 2 5 . . . ; Which of the following statements are

Consider the following SQL statement:
CREATE TABLESPACE TS3
...
PCTFREE 25
... ;
Which of the following statements are TRUE concerning TS3?
Question 26Select one or more:
A.
The INSERT and UPDATE SQL statements will attempt to leave 25% of the space on each page free
B.
Db2 will attempt to keep 25% of the space on each page free at all times
C.
The LOAD and REORG utilities will attempt to leave 25% of the space on each page free
D.
The first record on every page will be loaded without restriction

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!