
Quiz Basis Data #3 - SQL Dasar
Quiz
•
Computers
•
University
•
Practice Problem
•
Hard
Yan Sofyan
FREE Resource
Enhance your content in a minute
24 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa fungsi perintah `SELECT` dalam SQL?
Memilih kolom yang ingin ditampilkan
Menghapus data dari tabel
Menyimpan data ke dalam file
Mengganti struktur tabel
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa tujuan dari klausa `FROM` dalam perintah SQL?
Menentukan tabel sumber data
Mengurutkan hasil query
Menghapus tabel
Mengelompokkan hasil query
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perintah SQL berikut: SELECT nama, alamat FROM pelanggan; akan menghasilkan:
Menampilkan semua data dalam tabel pelanggan
Menampilkan kolom `nama` dan `alamat` dari tabel pelanggan
Menghapus kolom `alamat` dari tabel pelanggan
Mengubah nama kolom
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Apa fungsi dari klausa `WHERE` dalam SQL?
Mengurutkan data
Menentukan kondisi filter baris
Menggabungkan dua tabel
Mengganti nama kolom
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perintah berikut: SELECT * FROM produk WHERE harga > 10000; akan menampilkan:
Semua produk tanpa filter
Produk dengan harga di bawah 10000
Produk dengan harga di atas 10000
Produk berdasarkan urutan harga
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Manakah pernyataan yang benar tentang `ORDER BY` dalam SQL?
Digunakan untuk menyaring data
Digunakan untuk mengurutkan hasil query
Digunakan untuk menambahkan kolom
Digunakan untuk menjumlahkan data
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bagaimana cara menampilkan data pelanggan berdasarkan urutan nama naik?
`SELECT * FROM pelanggan ORDER BY nama ASC;`
`SELECT * FROM pelanggan ORDER nama DESC;`
`SELECT nama ASC FROM pelanggan;`
`SELECT pelanggan ORDER nama;`
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
20 questions
PENGENALAN KEPADA TEKNOLOGI KOMPUTER/ PENGENALAN KEPADA TEKN
Quiz
•
University
20 questions
Komputer dan Masyarakat
Quiz
•
University
20 questions
Testing dan Implementasi UTS
Quiz
•
KG - University
20 questions
ADMINISTRASI SISTEM JARINGAN
Quiz
•
University
20 questions
PTS HTML Dasar
Quiz
•
11th Grade - University
20 questions
Kuis Pelatihan API Kutim By GIZ
Quiz
•
University - Professi...
20 questions
LOOKUP
Quiz
•
9th Grade - University
20 questions
Responsi PL 2021/2022
Quiz
•
University
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade
Discover more resources for Computers
20 questions
Definite and Indefinite Articles in Spanish (Avancemos)
Quiz
•
8th Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
9 questions
Principles of the United States Constitution
Interactive video
•
University
18 questions
Realidades 2 2A reflexivos
Quiz
•
7th Grade - University
10 questions
Dichotomous Key
Quiz
•
KG - University
25 questions
Integer Operations
Quiz
•
KG - University
7 questions
What Is Narrative Writing?
Interactive video
•
4th Grade - University
20 questions
SER vs ESTAR
Quiz
•
7th Grade - University
