SOLVED: What would happen when the below SQL script gets executed?CREATE TABLE Emp ( ...

What would happen when the below SQL script gets executed?

CREATE TABLE Emp
(
      EmpId INT PRIMARY KEY,
      EmpName VARCHAR(30)
)

Emp table is created with clustered index on EmpId Column

Emp table is created with non-clustered index on EmpId column

Emp table is created with no index

Emp table is created with clustered and non-clustered index on EmpId column

Verified Answer

Correct Option - a

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

What would happen when the below SQL script gets executed?CREATE TABLE Emp ( EmpId INT PRIMARY KEY, EmpName VARCHAR(30) )

Important Links

What would happen when the below SQL script gets executed?
CREATE TABLE Emp ( EmpId INT PRIMARY KEY, EmpName VARCHAR(30) )