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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started