SQL Quiz

Which join type results in a Cartesian product?

• FULL OUTER JOIN

• RIGHT JOIN

• CROSS JOIN

• LEFT JOIN

Which of the following operators is used to combine the result sets of two or more SELECT queries, removing duplicates?

• ЕХСЕРТ

• INTERSECT

• UNION

• JOIN

Which type of join includes all rows from the left table and only the matching rows from the right table?

• LEFT JOIN

• FULL JOIN

• RIGHT JOIN

• INNER JOIN

What is the syntax to rename a column in a SELECT statement using an alias?

• SELECT alias_name FROM column_name

• RENAME column_name TO alias_name

• SELECT column_name AS alias_name

• WITH column_name AS alias_name

Which SQL function returns the sum of values in a column?

• SUM()

• COUNT)

• AVG()

• MIN()

What is the purpose of using aliases in SQL?

• To filter data

• To delete records from tables

• To provide temporary names for columns or tables for easier reference

• To create new columns in a result set

What is the correct syntax for using the UNION keyword in SQL?

• SELECT * FROM tableA EXCEPT SELECT * FROM tableB;

• SELECT * FROM tableA UNION SELECT * FROM tableB;

• SELECT * FROM tableA JOIN tableB;

• SELECT * FROM tableA UNION ALL SELECT * FROM tableB;

How can you rename a table while writing a query using SQL?

• Use the RENAME keyword

• Use the AS keyword

• Use the SET clause

• Use the WITH clause

What is the purpose of the HAVING clause in SQL?

• To limit the number of rows returned

• To sort the results

• To join multiple tables

• To filter group results returned by the GROUP BY clause

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

• SELECT * FROM Persons WHERE FirstName='a';

• SELECT * FROM Persons WHERE FirstName LIKE 'a%';

• SELECT * FROM Persons WHERE FirstName LIKE '%a';

• SELECT * FROM Persons WHERE FirstName=%a%';