Latest Answer : Rollup summarises the group of data records based on key eg you want the income of a particular city from a set of records , you can use the rollup component.example dml is customer ,city name and amount (here the key ...

Describe where you would use each of the following index types in relation to query type and/or data set: Hashed, Sorted, Bitmapped (Ranked), Clustered

In a process which reads 15,000 rows from one table and either updates or inserts them into another table and given the scenario where the process may abnormally terminate, describe how you track progress within the data to ensure the process could be restarted without repeating any processing.

In the scenario outlined in #18 and given that the output table(s) will be accessed by concurrent readers describe how your SQL code would be structured to minimize lock contention.

When using multiple DML statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why.

Describe which database structural and physical elements you would review when optimizing query performance.

Describe which system/process elements you would review when trouble-shooting general server slowness.

Describe typical activities or elements of investigation you would employ when trouble shooting complaints of localized process slowness.

Describe the elements you would review to ensure multiple scheduled "batch" jobs do not "collide" with each other.

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data.