23 The customer table is currently fragmented into 3 dbspaces (dbspace1, dbspace

Question

23 The customer table is currently fragmented into 3 dbspaces (dbspace1, dbspace2, and dbspace3), using round robin as its fragmentation strategy. The following SQL statement is executed:

ALTER FRAGMENT ON TABLE customer
ADD FRAGMENT dbspace4;
What happens to the rows that are currently stored in the three original dbspaces, and to new rows that are added to the table? *This question is required.
a. The existing rows remain in their current locations; new rows will be added to dbspace4
b. The existing rows remain in their current locations; new rows will be added using the round robin method to just the first three dbspaces
c. The existing rows remain in their current locations; new rows will be added using the round robin method to all four dbspaces
d. The existing rows will be distributed round robin among the four dbspaces; new rows will be added using the round robin method to all four dbspaces
25. How can you enable logging on a non-logging database? *This question is required.
a. With an ALTER DATABASE statement
b. With an ONMODE command
c. With an ONTAPE command
d. You cannot enable logging on a non-logged database
26. A DBA can specify the ENABLED or DISABLED mode for which database objects? (Choose all that apply) *This question is required.
a. Triggers on tables
b. Triggers on views
c. Unique Indexes
d. Duplicate Indexes
27. A table is fragmented by expression. Which of the following statements describes the placement of rows in the table? *This question is required.
a. When a row is inserted into the table, each expression will be evaluated in order. The row will be placed in the first fragment where the expression evaluates to TRUE, and the rest of the expressions will be skipped. If no expression evaluates to TRUE, the row will be placed in the fragment specified by the REMAINDER clause, if one is included; otherwise, the insert will fail
b. When a row is inserted into the table, each expression will be evaluated in order. The row will be placed in the fragments where the expression evaluates to TRUE. If no expression evaluates to TRUE, the row will be placed in the fragment specified by the REMAINDER clause, if one is included; otherwise, the insert will fail
c. When a row is inserted into the table, each expression will be evaluated in order. The row will be placed in the last fragment where the expression evaluates to TRUE. If no expression evaluates to TRUE, the row will be placed in the fragment specified by the REMAINDER clause, if one is included; otherwise, the insert will fail
d. When a row is inserted into the table, each expression will be evaluated in order. The row will be placed on a page in the first fragment where the expression evaluates to TRUE, with any bytes that do not fit on that page being written to the REMAINDER fragment, if one is included; otherwise, the insert will fail

Explanation / Answer

Hi,
This question has multiple questions which are indepdent of each other, answering the first one as per chegg policy, please post others as separate questions
23. When a new fragment is added via alter fragment command and add clause, all the existing data is distributed round robin among the four dbspaces; new rows will be added using the round robin method to all four dbspaces
Think of it as, number of slots available increase with the same strategy of filling slots, which makes rooms to reshuffle and distribute all the records with the increased numbner of slots

Thumbs up if this was helpful , otherwise let me know in comments

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.