41.Say True or False. Give explanation if False. INSERT statement does not allow copying rows from one table to another. False. INSERT statement allows to add rows to a table Continue Reading »
Home / Posts Tagged "SQL Interview questions and Answers"
31.What do you understand by a subquery? When is it used? A subquery is a SELECT statement embedded in a clause of another SELECT statement. It is used when the Continue Reading »
21.What is the difference between cross joins and natural joins? The cross join produces the cross product or Cartesian product of two tables. The natural join is based on all Continue Reading »
11.What is the default ordering of data using the ORDER BY clause? How could it be changed? The default sorting order is ascending. It can be changed using the DESC Continue Reading »
1.What is the difference between SQL and MySQL or SQL Server? SQL or Structured Query Language is a language; language that communicates with a relational database thus providing ways of Continue Reading »