Logo
search
menuicon
thubnail
Pekan Olahraga
Permainan Tim

SELECT and JOIN

Moh. Yahya
75
Pertanyaan yang ditambahkan (20/ 20)
Izinkan jawaban yang salah
Sembunyikan jawaban
public kuis

Pertanyaan 1

Pertanyaan jawaban singkat

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

  • SELECT

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