Non-clustered index. Important thing to note: By default a 
clustered index gets created on the primary key, unless 
specified otherwise.

If we simple say CREATE INDEX then non clustered index will 
be created.At the same time if we say CREATE NON CLUSTERED 
INDEX then also non clustered index will be created.

Eg.
CREATE TABLE Emp(
 			 eid		 INT
      			,ename	 VARCHAR(20))

CREATE INDEX in_emp_eid 
ON Emp(eid)
By executing above code we create non clustered index.

Eg.
CREATE TABLE Emp(
 			 eid		 INT
      			,ename	 VARCHAR(20))

CREATE NONCLUSTERED INDEX in_emp_eid 
ON Emp(eid)

By using this code also we create non clustered index only.