SOLVED: Consider a Customer table created as shown belowCREATE TABLE Customer ( Cus ...

Consider a Customer table created as shown below

CREATE TABLE Customer
(
     CustomerId INT CONSTRAINT pk_CustomerId PRIMARY KEY
     CustomerName VARCHAR(250) NOT NULL,
)
GO

What would be the output when the below query gets executed

Query 1: CREATE INDEX idx1 ON Customer(CustomerId)

Query 2: CREATE INDEX idx2 ON Customer(CustomerName)

Query 1 will throw an error as the CustomerId column already has an index

Query 2 will throw an error as we can’t create an index on CustomerName column

Both queries get executed successfully and non-clustered indexes created on CustomerId and CustomerName columns

Both queries get executed successfully and no indexes are created

Verified Answer

Correct Option - c

To get all Infosys Certified MS SQL Server Developer Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee