Quiz: Nonclustered Index Internals (Disk Based, Rowstore Indexes) Quiz: Index Internals 🗂 We're talking about disk-based rowstore indexes! 1) Which of the following will be added to a nonclustered index, if it is not already present?*(Assume the table is NOT a heap)Select oneThe clustered index keyThe Primary KeyThe key of the first unique index which was created on the tableA row identifier (RID)2) If the table IS a heap, which of the following will be added to a nonclustered index, if it is not already present?*Select oneThe clustered index keyThe Primary KeyThe key of the first unique index which was created on the tableA row identifier (RID)3) If your nonclustered index is NOT unique, SQL Server will sneak extra information into which part of the index (if the columns aren't already present)?*Select oneThe keyThe includesThe filterIt won't do any sneaking4) If your nonclustered index IS unique, SQL Server will sneak extra information into which part of the index (if the columns aren't already present)?*Select oneThe keyThe includesThe filterIt won't do any sneaking5) When does SQL Server need to use a 'uniquifier'?*Select oneWhen the table's clustered index is not unique, and there are multiple rows with the same key valuesWhen the table's primary key is not unique, and there are multiple rows with the same key valuesWhen the table name is not uniqueWhen the table contains a column with the uniqueidentifier data type Share this:Click to share on Facebook (Opens in new window)Click to share on Twitter (Opens in new window)Click to email this to a friend (Opens in new window)Click to share on Reddit (Opens in new window)
