Question: Identify the two tables below and state whether left the PK as a clustered index (PK Clustered), b) had no clustered index in the table
Identify the two tables below and state whether left the PK as a clustered index ("PK Clustered"), b) had no clustered index in the table ("No Clustered Index"), or c) Made another non-PK clustered index ("Other Clustered Index"). For each table, briefly justify your decision
DMQEmployee Application Verifies ApplicationlD FirstName LastName DepartmentID obTitle PhoneNumber Email SteetAddress City State EmployeelD SSN LicenseTypelD SubmitionDate DecisionDate DMQEmployee Application Verifies ApplicationlD FirstName LastName DepartmentID obTitle PhoneNumber Email SteetAddress City State EmployeelD SSN LicenseTypelD SubmitionDate DecisionDate
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
