Sql Interview Question and Answers

21. Define data model?
  Underlying the structure of the database is called as data model.
 
Your Name Your Email-ID
Your Answer
22. What is an Entity?
  It is a 'thing' in the real world with an independent existence.
 
Your Name Your Email-ID
Your Answer

23. What is BCP? When does it used?
  BulkCopy is a tool used to copy huge amount of data from tables and views. BCP does not copy the structures same as source to destination.
 
Your Name Your Email-ID
Your Answer
24. Explain the use of the by GROUP BY and the HAVING clause?
  The GROUP BY partitions the selected rows on the distinct values of the column on which the group by has been done.
The HAVING selects groups which match the criteria specified.
 
Santhi,says May 10, 2014
The SQL HAVING Clause is used in combination with the GROUP BY Clause to restrict the groups of returned rows to only those whose the condition is TRUE.
Your Name Your Email-ID
Your Answer
25. What are the advantages of Database?
 
  • Redundancy can be reduced
  • Inconsistence can be avoided
  • The data can be shared
  • Standards can be enforced
  • Security can be enforced
  • Integrity can be maintained
 
Your Name Your Email-ID
Your Answer
123456789101112131415


16171819202122232425 Page 5 of 25