Answer Posted / suraj

-- YES.

drop table Employees
create table Employees(
EmpID int Primary Key NonClustered,
[Name] varchar(20),
SSNo varchar(20) )

CREATE CLUSTERED INDEX ci_EMPLOYEES_SS ON EMPLOYEES (Name)

insert Employees values (101,'John','123-45-6789')
insert Employees values (102,'Mike','123-45-6789')


select * from Employees

-- We have to specifically define NonClustered in the
Primary Key column because Clustered Index is created by
default in Primary Key.
-- And, We are able to define Clustered Index in
another column because every table is eligible to have one
clustered index.
-- Clustered Index has to be created after table
creation.
-- From above example, EmpID doesn't take duplicates,
because it is primary key. But, SSNo takes duplicates.

Mention a few common trace flags used with sql server?

880

---

Is sql server a database?

924

---

What action plan is preferred if sql server is not responding?

1035

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1127

---

How to write a query with a full outer join in ms sql server?

999

---

What is service broker? : sql server database administration

940

---

Does server sql treat char as a variable-length or fixed-length column?

951

---

List out the difference between union and union all in sql server?

919

---

explain extended properties

927

---

How to achieve Paging of records in SQL SERVER?

1032

---

What is normalization of database? What are its benefits?

961

---

How to link tables in sql server?

890

---

What are the different index configurations a table can have?

898

---

is there a column to which a default can't be bound? : Sql server database administration

967

---

How to locate and take substrings with charindex() and substring() functions?

943

---