Buat Kuis Baru
Pertanyaan 1
Pertanyaan jawaban singkat
What SQL keyword is used to retrieve data from a database?
SELECT
Pekan Olahraga
Permainan Tim
SELECT and JOIN
Moh. Yahya
73
Izinkan jawaban yang salah
Sembunyikan jawaban
public kuis
Pertanyaan 2
Pertanyaan jawaban singkat
In SQL, which clause is used with SELECT to specify the table to query?
FROM
Pertanyaan 3
Pertanyaan jawaban singkat
What keyword is used with SELECT to sort the result set?
ORDER BY
Pertanyaan 4
Pertanyaan jawaban singkat
Which SQL clause filters records in a SELECT query?
WHERE
Pertanyaan 5
Pertanyaan jawaban singkat
What keyword allows you to remove duplicate rows in a SELECT statement?
DISTINCT
Pertanyaan 6
Pertanyaan jawaban singkat
In an SQL query, what symbol is used as a wildcard for a single character in a LIKE clause?
_
Pertanyaan 7
Pertanyaan jawaban singkat
Which function calculates the total number of rows returned by a SELECT query?
COUNT
Pertanyaan 8
Pertanyaan jawaban singkat
What clause is used with SELECT to group rows that have the same values in specified columns?
GROUP BY
Pertanyaan 9
Pertanyaan jawaban singkat
Which keyword is used in a SELECT query to specify conditions on grouped records?
HAVING
Pertanyaan 10
Pertanyaan jawaban singkat
What does the SQL keyword 'AS' do in a SELECT statement?
Alias
Pertanyaan 11
Pertanyaan jawaban singkat
What SQL clause is used to combine rows from two or more tables based on a related column between them?
JOIN
Pertanyaan 12
Pertanyaan jawaban singkat
Which type of JOIN returns all records when there is a match in either left or right table records?
FULL OUTER JOIN
Pertanyaan 13
Pertanyaan jawaban singkat
What JOIN type returns only the rows with matching values in both tables?
INNER JOIN
Pertanyaan 14
Pertanyaan jawaban singkat
Which JOIN returns all records from the left table and the matched records from the right table?
LEFT JOIN
Pertanyaan 15
Pertanyaan jawaban singkat
What does the term 'NULL' represent in SQL JOIN operations?
Missing Value
Pertanyaan 16
Pertanyaan jawaban singkat
Which SQL function can be used to replace NULL values in the result set of a JOIN?
COALESCE
Pertanyaan 17
Pertanyaan jawaban singkat
What kind of JOIN would you use to select all records from the right table and the matched records from the left table?
RIGHT JOIN
Pertanyaan 18
Pertanyaan jawaban singkat
In SQL, which keyword can be added to a JOIN to specify a condition beyond the matching columns?
ON
Pertanyaan 19
Pertanyaan jawaban singkat
What is the default JOIN type if no specific JOIN type is mentioned?
INNER JOIN
Pertanyaan 20
Pertanyaan jawaban singkat
Which JOIN type is the least commonly used and can be replaced by a different type of JOIN with a WHERE clause?
CROSS JOIN
Bagikan ke Google Classroom