MS SQL Server - 87 - Partitioning MCQ

87 – Partitioning MCQ

1 / 23

1. What is the primary purpose of table partitioning in SQL Server?

B. Enhancing data security

A. Simplifying data entry

C. Improving query performance and manageability

D. Enforcing data integrity

2 / 23

2. Which statement is true about partitioning in SQL Server?

D. It adds new rows to a table.

B. It merges multiple tables into one.

C. It rearranges data within a table.

A. It divides a table into multiple smaller tables.

3 / 23

3. What is a common use case for table partitioning in SQL Server?

B. Supporting data mining operations

A. Reducing query complexity

C. Managing access control

D. Archiving historical data

4 / 23

4. Which SQL Server feature is used to define and manage table partitions?

C. Filegroups

D. Schemas

A. Indexes

B. Triggers

5 / 23

5. In SQL Server, which partitioning function is commonly used to divide data into ranges based on a column’s values?

D. MERGE

A. RANGE

B. HASH

C. LIST

6 / 23

6. What is the purpose of the PARTITION BY clause in SQL Server?

D. Filtering data rows

C. Ordering result sets

A. Defining partitioning schemes

B. Specifying table constraints

7 / 23

7. In SQL Server, what does the ORDER BY clause do when used with the PARTITION BY clause in a query?

A. It sorts the entire result set.

C. It filters the result set.

D. It aggregates data.

B. It partitions the result set into groups.

8 / 23

8. What is the purpose of the ROWS BETWEEN clause in SQL Server window functions?

B. Filtering rows based on a condition

A. Specifying the order of rows in a result set

C. Defining the partitioning scheme

D. Specifying a window or frame of rows for a calculation

9 / 23

9. Which window function in SQL Server returns the rank of each row within a result set?

C. DENSE_RANK()

B. RANK()

D. NTILE()

A. ROW_NUMBER()

10 / 23

10. In SQL Server, what does the PARTITION BY clause do when used with window functions?

C. It determines the window or frame of rows for the calculation.

A. It specifies the data type of the window function result.

D. It filters rows based on a condition.

B. It defines the order of rows within each partition.

11 / 23

11. Which clause is used to specify the window or frame of rows for a calculation in SQL Server window functions?

A. GROUP BY

B. PARTITION BY

C. ROWS BETWEEN

D. ORDER BY

12 / 23

12. In SQL Server, which window function is used to calculate the cumulative distribution of a column’s values?

B. RANK()

C. DENSE_RANK()

D. NTILE()

A. ROW_NUMBER()

13 / 23

13. In SQL Server, what is the purpose of the OVER clause when used with window functions?

C. It defines the window or frame of rows for the calculation.

B. It determines the data type of the result.

D. It filters rows based on a condition.

A. It specifies the column for aggregation.

14 / 23

14. Which SQL Server window function returns the row number of each row within a result set?

A. ROW_NUMBER()

C. DENSE_RANK()

D. NTILE()

B. RANK()

15 / 23

15. What is the primary benefit of using window functions in SQL Server?

D. Better data encryption

C. Enhanced data security

B. Simplified data entry

A. Improved query performance

16 / 23

16. In SQL Server, what does the PARTITION BY clause do when used with window functions?

C. It determines the window or frame of rows for the calculation.

A. It defines the order of rows within each partition.

B. It specifies the data type of the window function result.

D. It filters rows based on a condition.

17 / 23

17. Which SQL Server window function assigns a unique number to each row within a result set?

D. NTILE()

C. DENSE_RANK()

A. ROW_NUMBER()

B. RANK()

18 / 23

18. In SQL Server, what is the purpose of the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause?

D. It groups rows by a specified column.

A. It specifies the sorting order of rows.

C. It filters rows based on a condition.

B. It defines a window that includes all preceding rows.

19 / 23

19. In SQL Server, what is the purpose of the ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING clause?

D. It groups rows by a specified column.

C. It filters rows based on a condition.

B. It defines a window that includes only the current row and its immediate neighbors.

A. It specifies the sorting order of rows.

20 / 23

20. Which SQL Server window function assigns a rank to each row within a result set but leaves gaps for tied values?

C. DENSE_RANK()

D. NTILE()

A. ROW_NUMBER()

B. RANK()

21 / 23

21. In SQL Server, what does the PARTITION BY clause do when used with window functions?

C. It determines the window or frame of rows for the calculation.

D. It filters rows based on a condition.

B. It defines the order of rows within each partition.

A. It specifies the sorting order of rows.

22 / 23

22. Which SQL Server window function divides the result set into roughly equal parts or percentiles?

C. DENSE_RANK()

A. ROW_NUMBER()

B. RANK()

D. NTILE()

23 / 23

23. In SQL Server, what is the purpose of the ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING clause?

C. It filters rows based on a condition.

D. It groups rows by a specified column.

A. It specifies the sorting order of rows.

B. It defines a window that includes the current row and all rows that follow.

Your score is

MS SQL Server – 87 – Partitioning MCQ