Cse 154 Exam Cheat Sheet - Sql

FAQ

Q: What is SQL?A: SQL stands for Structured Query Language and is a programming language used for managing and manipulating databases.

Q: What can SQL be used for?A: SQL can be used to create, retrieve, update, and delete data from a database.

Q: What are the basic components of a SQL statement?A: The basic components of a SQL statement are SELECT, FROM, WHERE, and optional clauses such as ORDER BY and GROUP BY.

Q: What is the SELECT statement used for?A: The SELECT statement is used to retrieve data from a database.

Q: What is the FROM clause used for?A: The FROM clause is used to specify the table or tables from which to retrieve data.

Q: What is the ORDER BY clause used for?A: The ORDER BY clause is used to specify the order in which the data should be sorted.

Q: What is the GROUP BY clause used for?A: The GROUP BY clause is used to group rows based on specified columns.

Q: What are the different types of joins in SQL?A: The different types of joins in SQL are INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.

Q: What is the difference between INNER JOIN and OUTER JOIN?A: INNER JOIN returns only the matching rows between two tables, while OUTER JOIN returns all the rows from one table and the matching rows from the other table.