Kuis SQL Dasar

Kuis SQL Dasar

12th Grade

20 Qs

quiz-placeholder

Similar activities

CTE ICT Pathway "SHOW  what you KNOW"

CTE ICT Pathway "SHOW what you KNOW"

6th - 12th Grade

15 Qs

EmTech

EmTech

11th - 12th Grade

20 Qs

Photoshop Certification [2, Panels]

Photoshop Certification [2, Panels]

9th - 12th Grade

20 Qs

Research Paper & Citations

Research Paper & Citations

9th - 12th Grade

15 Qs

Syllabus Quiz

Syllabus Quiz

9th - 12th Grade

20 Qs

IT QUIZ

IT QUIZ

12th Grade - University

20 Qs

Uji Kompetensi #1 Kelas XII Kompetensi Keahlian Rekayasa Per

Uji Kompetensi #1 Kelas XII Kompetensi Keahlian Rekayasa Per

12th Grade

20 Qs

Cookery

Cookery

12th Grade

15 Qs

Kuis SQL Dasar

Kuis SQL Dasar

Assessment

Quiz

Instructional Technology

12th Grade

Practice Problem

Medium

Created by

Iman Rohman

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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;

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?