Home Library Explore SAT

Home Library Explore SAT

dbs Flashcards | StudBud

What is the purpose of the JOIN clause in SQL?

Which of the following is true about INNER JOIN?

dbs

7 terms·StudBud Administration·18 plays

Imported from external platform

Flashcards7 cardsFPractice quizPHost liveL

Questions 7

Answers

1
Which of the following is true about INNER JOIN?
Returns all rows from both tables
Returns duplicate rows from both tables
Returns rows that have no matching rows in the other table
Returns only matching rows from both tables
2
What is the purpose of the JOIN clause in SQL?
To combine rows from two or more tables based on a related column
To group rows with the same values
To perform mathematical operations
To filter rows in a table
3
Which of the following statements is true regarding table aliasing using AS?
AS can be used to perform arithmetic operations
AS can only be used for column names
AS is mandatory in all SQL queries
AS is used to rename columns or tables in the output
4
What does the DISTINCT keyword do in a SQL query?
Filters rows based on a condition
Removes duplicate rows from the result
Groups rows by a specific column
Joins tables based on a related column
5
In SQL, what does the IN operator do?
Filters rows based on a list of values
Sorts the results in ascending order
Performs a join between tables
Groups results by a specific column
6
Which SQL clause is used to filter rows in a query?
AS
WHERE
SELECT
JOIN
7
In SQL, which clause is commonly used to combine multiple conditions in a query?
GROUP BY
HAVING
AND
ORDER BY