[Database/Hackerrank] Index Architecture Types

Index Architecture Types

How many index architecture type classifications are there in MS SQL Server?

=> 2. 2

 

Indexes - 2

Which of the following statement is true about row locators in non-clustered indexes in MS SQL Server?

=> 3. If the table has a clustered index, or the index is on an indexed view, the row locator is the clustered index key for the row.

 

Indexes - 3

Consider the following two designs to store the data using clustered indexes in MS SQL Server:

• In the first design, the fill factor is 20% and the total number of free rows per page are A.
• In the second design, the fill factor is 40% and the total number of free rows per page are B.

Which the followings describes the relation between A and B:

=> 1. A = 1.33B

The answer is A=1.33B. The space filled is 20% and remaining space is 80% The space filled is 40% and remaining space is 60% 80%=1.33(60%).

 

Indexes - 4

The correct syntax for creating composite indexes in MS SQL Sever is:

=> 3. <p>CREATE INDEX index_name</p> <p>ON table_name(column1, column2);</p>

복합 인덱스를 생성하는 구문