Perintah SQL untuk menghapus seluruh data dari tabel produk?

Kuis SQL Dasar

Flashcard
•
Chemistry
•
12th Grade
•
Hard
Rizka Agustina
Used 1+ times
FREE Resource
Student preview

15 questions
Show all answers
1.
FLASHCARD QUESTION
Front
Back
DELETE FROM produk;
2.
FLASHCARD QUESTION
Front
Perintah SQL untuk menampilkan semua kolom dari tabel pelanggan?
Back
SELECT * FROM pelanggan;
3.
FLASHCARD QUESTION
Front
Apa yang akan dilakukan perintah DELETE FROM pegawai WHERE id = 5;?
Back
Menghapus pegawai dengan ID 5
4.
FLASHCARD QUESTION
Front
Untuk menampilkan nama dan alamat dari tabel siswa, digunakan perintah:
Back
SELECT nama, alamat FROM siswa;
5.
FLASHCARD QUESTION
Front
Perintah DELETE FROM pelanggan WHERE kota = 'Bandung'; akan:
Back
Menghapus pelanggan yang tinggal di kota Bandung
6.
FLASHCARD QUESTION
Front
Perintah SELECT * FROM barang WHERE harga > 10000; digunakan untuk:
Back
Menampilkan semua barang dengan harga di atas 10000
7.
FLASHCARD QUESTION
Front
Untuk menghapus semua baris di tabel tanpa menghapus strukturnya, digunakan: DROP TABLE, TRUNCATE TABLE, DELETE TABLE, REMOVE ALL
Back
TRUNCATE TABLE
Create a free account and access millions of resources
Similar Resources on Quizizz
20 questions
BASIS DATA (Flashcards)

Flashcard
•
12th Grade
10 questions
Web 2.6 Flashcard

Flashcard
•
11th Grade
15 questions
SAT Vocab Words

Flashcard
•
12th Grade
10 questions
Soal ulangan sinonim dan antonim

Flashcard
•
12th Grade
10 questions
SEL

Flashcard
•
University
12 questions
Kuiz Ramadhan

Flashcard
•
KG - University
9 questions
Dictionary Flashcard

Flashcard
•
12th Grade
14 questions
MySQL Functions

Flashcard
•
12th Grade
Popular Resources on Quizizz
20 questions
math review

Quiz
•
4th Grade
20 questions
Math Review - Grade 6

Quiz
•
6th Grade
20 questions
Reading Comprehension

Quiz
•
5th Grade
20 questions
Types of Credit

Quiz
•
9th - 12th Grade
20 questions
Taxes

Quiz
•
9th - 12th Grade
10 questions
Human Body Systems and Functions

Interactive video
•
6th - 8th Grade
19 questions
Math Review

Quiz
•
3rd Grade
45 questions
7th Grade Math EOG Review

Quiz
•
7th Grade