
Kuis SQL Dasar
Quiz
•
Instructional Technology
•
12th Grade
•
Practice Problem
•
Medium
Iman Rohman
Used 1+ times
FREE Resource
Enhance your content in a minute
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Query SQL yang benar untuk menambahkan data ke dalam tabel tb_anggota adalah …
INSERT INTO tb_anggota VALUES ();
ADD INTO tb_anggota VALUES ();
INSERT tb_anggota VALUES ();
APPEND INTO tb_anggota VALUES ();
ADD tb_anggota VALUES ();
2.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Sintaks yang tepat untuk menampilkan hanya data nama dari tabel tb_karyawan adalah …
SELECT FROM tb_karyawan nama;
SELECT nama FROM tb_karyawan;
SHOW nama FROM tb_karyawan;
GET nama FROM tb_karyawan;
DISPLAY nama FROM tb_karyawan;
3.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Query untuk menghapus tabel tb_produk dari database adalah …
DELETE tb_produk;
REMOVE tb_produk;
DROP TABLE tb_produk;
ERASE TABLE tb_produk;
TRUNCATE tb_produk;
4.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Sintaks yang benar untuk mengubah data di kolom harga menjadi 50000 pada tabel tb_barang adalah …
CHANGE tb_barang SET harga = 50000;
MODIFY tb_barang harga = 50000;
UPDATE tb_barang SET harga = 50000;
ALTER tb_barang harga = 50000;
REPLACE harga WITH 50000 IN tb_barang;
5.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Perintah SQL untuk mengurutkan data tb_mahasiswa berdasarkan nama secara ascending adalah …
ORDER tb_mahasiswa BY nama ASC;
SORT tb_mahasiswa BY nama;
SELECT * FROM tb_mahasiswa ORDER BY nama ASC;
ARRANGE * FROM tb_mahasiswa BY nama;
SELECT ALL FROM tb_mahasiswa SORT BY nama;
6.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Query untuk menampilkan data tb_pesanan yang memiliki status = 'selesai' adalah …
SELECT * FROM tb_pesanan WHERE status = 'selesai';
FIND * FROM tb_pesanan IF status = 'selesai';
SEARCH tb_pesanan FOR status = 'selesai';
GET ALL FROM tb_pesanan WHERE status = 'selesai';
LOOK tb_pesanan WHERE status = 'selesai';
7.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Untuk menambah kolom email pada tabel tb_pegawai, digunakan perintah …
ADD COLUMN email TO tb_pegawai;
INSERT email INTO tb_pegawai;
ALTER TABLE tb_pegawai ADD email VARCHAR(50);
MODIFY TABLE tb_pegawai ADD COLUMN email;
CREATE COLUMN email ON tb_pegawai;
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
20 questions
Core Power Tools
Quiz
•
9th - 12th Grade
15 questions
Car Companies of the world (1.1 update)
Quiz
•
KG - University
18 questions
Scroll Saw Quiz
Quiz
•
9th - 12th Grade
15 questions
PEOPLE MEDIA_SOCRATES
Quiz
•
7th Grade - University
20 questions
Inch Micrometer Practice
Quiz
•
12th Grade
15 questions
The Evolution of Traditional to New Media
Quiz
•
12th Grade
20 questions
Code Unit 2 The Internet 2020-21
Quiz
•
9th - 12th Grade
15 questions
Digital Citizenship
Quiz
•
5th - 12th Grade
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 Instructional Technology
28 questions
Ser vs estar
Quiz
•
9th - 12th Grade
34 questions
Geometric Terms
Quiz
•
9th - 12th Grade
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
16 questions
Proportional Relationships And Constant Of Proportionality
Quiz
•
7th - 12th Grade
10 questions
DNA Replication Concepts and Mechanisms
Interactive video
•
7th - 12th Grade
10 questions
Unit 2: LS.Bio.1.5-LS.Bio.2.2 Power Vocab
Quiz
•
9th - 12th Grade
20 questions
Food Chains and Food Webs
Quiz
•
7th - 12th Grade
15 questions
Identify Triangle Congruence Criteria
Quiz
•
9th - 12th Grade
