Home » Interview Q & A

Category Archives: Interview Q & A

Q18. What is the difference between the Database and Datawarehouse?

June 21, 2013 7:55 am / Leave a comment

Please visit SQLVERSITY.COM for more details.

(more…)

Q17. What is the difference between COUNT(*) and COUNT(Column Name)?

June 21, 2013 7:45 am / 1 Comment on Q17. What is the difference between COUNT(*) and COUNT(Column Name)?

Please visit SQLVERSITY.COM for more details.

(more…)

Q16. What are the GRANT permissions we can give to different types of database objects?

June 13, 2013 3:13 pm / Leave a comment

Please visit SQLVERSITY.COM for more details.

(more…)

Q15. What is the difference between Clustered & Non Clustered Indexes?

June 12, 2013 4:06 pm / Leave a comment

Please visit SQLVERSITY.COM for more details.

(more…)

Q14. What are the System databases available in SQL Server?

June 10, 2013 3:38 pm / Leave a comment

Please visit SQLVERSITY.COM for more details.

(more…)

Q13. What is the basic difference between ROW_NUMBER, RANK and DENSE_RANK functions?

June 9, 2013 6:39 am / Leave a comment

Please visit SQLVERSITY.COM for more details.

(more…)

Q12. What is RAISERROR()? Where do you use this?

June 8, 2013 3:13 am / Leave a comment

Please visit SQLVERSITY.COM for more details.

(more…)

Q11. What is the difference between the basic datatypes Char and Varchar?

June 7, 2013 10:35 am / 1 Comment on Q11. What is the difference between the basic datatypes Char and Varchar?

Please visit SQLVERSITY.COM for more details.

(more…)

Q10. What is meant by the error ‘String or binary data would be truncated. The statement has been terminated’?

June 6, 2013 2:08 pm / Leave a comment

Please visit SQLVERSITY.COM for more details.

(more…)

Q9. How do you rename a table or column name?

June 5, 2013 3:41 pm / Leave a comment

Please visit SQLVERSITY.COM for more details.

(more…)

Post navigation

← Older posts