Sql Interview Question and Answers

16. Define Joins?
  A Join combines columns and data from two or more tables (and in rare cases, of one table with itself).
 
Your Name Your Email-ID
Your Answer
17. What are the types of Joins?
 
  • Equi joins
  • Cartesian Joins
  • Outer Joins
  • Self Joins.
 
Your Name Your Email-ID
Your Answer

18. Define Equi Joins?
  A Equi Join is a join in which the join comparison operator is an equality. When two tables are joined together using equality or values in one or more columns, they make an Equi Join.
 
Your Name Your Email-ID
Your Answer
19. Define Cartesian Join?
  Joining two tables without a whereclause produces a Cartesian join which combines every row in one table with every row in another table.
 
Your Name Your Email-ID
Your Answer
20. What are three SQL keywords used to change or set someone's permissions?
  GRANT, DENY, and REVOKE
 
Your Name Your Email-ID
Your Answer