Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Azure SQL Database For Modern Developers Building Applications In The Microsoft Cloud

Authors: Davide Mauri, Silvano Coriani, Anna Hoffma, Sanjay Mishra, Jovan Popovic

1st Edition

1484263693, 978-1484263693

More Books

Students also viewed these Databases questions

Question

What is the basis for Security Concerns in Cloud Computing?

Answered: 1 week ago

Question

Describe the three main Cloud Computing Environments.

Answered: 1 week ago