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://rebrand.ly/lex-telegram-236dee

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