Answer Posted / prashanth kumar

Yes , it have multiple fields.Run below query and creating
primary key on p_Id and LastName.

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName)
)

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1083

---

Is it possible to have clustered index on separate drive from original table location?

1014

---

How is a full-text index updated?

1001

---

What is difference between drop truncate and delete?

1153

---

What do you understand by physical_only option in dbcc checkdb?

1020

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

1011

---

What is join query?

938

---

Explain the concepts and capabilities of sql server?

1014

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1940

---

What is master database? : SQL Server Architecture

1081

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

1030

---

Explain what is it unwise to create wide clustered index keys?

1023

---

What are triggers in ms sql server?

1226

---

Does union all remove duplicates?

1123

---

How you provide security to cube? : sql server analysis services, ssas

1008

---