Question: Consider the Employees table below: table [ [ EmployeelD , FirstName,LastName,Department,Salary ] , [ 1 , Alice,Smith,HR , 6 0 0 0 0 ]
Consider the Employees table below:
tableEmployeelDFirstName,LastName,Department,SalaryAlice,Smith,HRBob,Johnson,ITCarol,Williams,Finance,David,Brown,ITEve,Davis,HR
A nonclustered index on the LastName column was created.
Question:
Given the Employees table with a nonclustered index on LastName, which of the following statements are true? One or more choices is correct
a The data in the table is physically sorted based on the LastName values.
b Inserting a new employee will require updating the nonclustered index.
c Updating the FirstName of an employee will require updating the nonclustered index.
d A query that searches for an employee by LastName will be faster due to the nonclustered index.
e Deleting an employee record will require updating the nonclustered index.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
