Q.Embedded SQL.
Q.How index help in performance.
Q.Highest selling product name
Q.SQL default instance name
Q.SQL.port
Q.cross join out put using inner join
Q.isolation levels
Q.Performance tuning
Q.can you drop clustered index from a table
query to drop index
Q. what if we delete row from table having reference to primary key of other table. will it allow.
Q.can we delete a row of primary key table whose other table referring.
Q.how non clustered is related to cluster what is does at back end to search records.
how would nonclustered search record.
Q.Difference between temptable and table variable.
Q.function to separate string with comma. put data into row by splitting that string having comma separated value.
Q. col has A,B,C,D,E,F print Ab,AC,Ad,Ae,Af,bb,bc,bd,be & on... ( ans use self cross join)
Q. Table with DOB,DOL,DOH print no. of cake to be order for oct month.