9. What is an INNER JOIN used for? 10. What is the difference between a Right JO
ID: 3716211 • Letter: 9
Question
9. What is an INNER JOIN used for?
10. What is the difference between a Right JOIN and a LEFT JOIN?
11. What is a table alias?
12. What is the LIKE statement used for in SQL?
13. What is Demorgan’s Law?
14. What built in functions can be used with the Group By statement?
15. What is the SQL statement HAVING used for?
16. Be able to normalize a table to 4th normal form?
17. Be able to write SQL statements that will provide information from a DB using specific dates and time.
18. Be able to do an INNER and OUTER JOIN sql statements.
19. Be able to provide information about a customers that did not purchase a particular item
20. Give SQL statements for creating a Table
21. Be able to write stored procedures
22. What is an N-Ary association?
Explanation / Answer
9)
The INNER JOIN selects all rows from both participating tables as long as there is a match between the columns.
10)
LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table.
RIGHT JOIN: returns all rows from the right table, even if there are no matches in the left table.
11)
You can rename a table or a column temporarily by giving another name known as Alias. The use of table aliases is to rename a table in a specific SQL statement
12)
The SQL LIKE clause is used to compare a value to similar values using wildcard operators
13)
The complement of the union of two sets is the intersection of their complements and the complement of the intersection of two sets is the union of their complements.These are called De Morgan's laws
(A ^ B)' = A' V B'
As per chegg policy we have limited to answer 4 questions at once please ask remaining as another
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.