Answer Posted / anil kumar

Here's the procedure:

Create a table with no primary key defined.
Create clustered index on the primary key columns.
Alter the table to define the primary key.

Table creation:

create table CDSWEB.Anil (officeid integer not null,
empid integer not null,
age integer ,sex varchar(5),
name varchar(20));

Index creation:
create index CDSWEB.AN001 on CDSWEB.Anil(officeid,empid)
CLUSTER;

Primary key defined:

alter table CDSWEB.ANIL
add primary key (officeid,empid);

What are the different index configurations a table can have?

899

---

What is outer join in sql server joins?

1045

---

What is a virtual table in sql?

943

---

What is normalization? What number of normalization shapes are there?

1054

---

Can you explain what is indexed view? How to create it?

851

---

Is sql server 2016 free?

885

---

What do you mean by an execution plan?

1051

---

what is a deadlock? : Sql server database administration

981

---

How many partitions a clustered index has by default in sql server 2012?

1050

---

Do you know what is similarity and difference between truncate and delete in sql?

959

---

Explain what role entity and relationship play in an ER diagram.

1017

---

explain different types of constraints? : Sql server database administration

914

---

How to provide values to user defined function parameters?

968

---

What is the server name for sql management studio?

948

---

What is tcl in sql server?

1076

---