SELECT and JOIN

Question 1

What SQL keyword is used to retrieve data from a database?

Accepted Answer

SELECT

Question 2

In SQL, which clause is used with SELECT to specify the table to query?

Accepted Answer

FROM

Question 3

What keyword is used with SELECT to sort the result set?

Accepted Answer

ORDER BY

Question 4

Which SQL clause filters records in a SELECT query?

Accepted Answer

WHERE

Question 5

What keyword allows you to remove duplicate rows in a SELECT statement?

Accepted Answer

DISTINCT

Question 6

In an SQL query, what symbol is used as a wildcard for a single character in a LIKE clause?

Accepted Answer

_

Question 7

Which function calculates the total number of rows returned by a SELECT query?

Accepted Answer

COUNT

Question 8

What clause is used with SELECT to group rows that have the same values in specified columns?

Accepted Answer

GROUP BY

Question 9

Which keyword is used in a SELECT query to specify conditions on grouped records?

Accepted Answer

HAVING

Question 10

What does the SQL keyword 'AS' do in a SELECT statement?

Accepted Answer

Alias

Question 11

What SQL clause is used to combine rows from two or more tables based on a related column between them?

Accepted Answer

JOIN

Question 12

Which type of JOIN returns all records when there is a match in either left or right table records?

Accepted Answer

FULL OUTER JOIN

Question 13

What JOIN type returns only the rows with matching values in both tables?

Accepted Answer

INNER JOIN

Question 14

Which JOIN returns all records from the left table and the matched records from the right table?

Accepted Answer

LEFT JOIN

Question 15

What does the term 'NULL' represent in SQL JOIN operations?

Accepted Answer

Missing Value

Question 16

Which SQL function can be used to replace NULL values in the result set of a JOIN?

Accepted Answer

COALESCE

Question 17

What kind of JOIN would you use to select all records from the right table and the matched records from the left table?

Accepted Answer

RIGHT JOIN

Question 18

In SQL, which keyword can be added to a JOIN to specify a condition beyond the matching columns?

Accepted Answer

ON

Question 19

What is the default JOIN type if no specific JOIN type is mentioned?

Accepted Answer

INNER JOIN

Question 20

Which JOIN type is the least commonly used and can be replaced by a different type of JOIN with a WHERE clause?

Accepted Answer

CROSS JOIN

SELECT and JOIN

problème 1

réponse courte

What SQL keyword is used to retrieve data from a database?

problème 2

réponse courte

In SQL, which clause is used with SELECT to specify the table to query?

problème 3

réponse courte

What keyword is used with SELECT to sort the result set?

problème 4

réponse courte

Which SQL clause filters records in a SELECT query?

problème 5

réponse courte

What keyword allows you to remove duplicate rows in a SELECT statement?

problème 6

réponse courte

In an SQL query, what symbol is used as a wildcard for a single character in a LIKE clause?

problème 7

réponse courte

Which function calculates the total number of rows returned by a SELECT query?

problème 8

réponse courte

What clause is used with SELECT to group rows that have the same values in specified columns?

problème 9

réponse courte

Which keyword is used in a SELECT query to specify conditions on grouped records?

problème 10

réponse courte

What does the SQL keyword 'AS' do in a SELECT statement?

problème 11

réponse courte

What SQL clause is used to combine rows from two or more tables based on a related column between them?

problème 12

réponse courte

Which type of JOIN returns all records when there is a match in either left or right table records?

problème 13

réponse courte

What JOIN type returns only the rows with matching values in both tables?

problème 14

réponse courte

Which JOIN returns all records from the left table and the matched records from the right table?

problème 15

réponse courte

What does the term 'NULL' represent in SQL JOIN operations?

problème 16

réponse courte

Which SQL function can be used to replace NULL values in the result set of a JOIN?

problème 17

réponse courte

What kind of JOIN would you use to select all records from the right table and the matched records from the left table?

problème 18

réponse courte

In SQL, which keyword can be added to a JOIN to specify a condition beyond the matching columns?

problème 19

réponse courte

What is the default JOIN type if no specific JOIN type is mentioned?

problème 20

réponse courte

Which JOIN type is the least commonly used and can be replaced by a different type of JOIN with a WHERE clause?