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://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Important Links

Privacy Policy

Refund Policy

Terms & Conditions

About Us

Contact Us