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
14 questions
Klausul JOIN dalam SQL

Flashcard
•
11th Grade
15 questions
SAT Vocab Words

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

Flashcard
•
12th Grade
10 questions
Introduction to MySQL

Flashcard
•
KG
10 questions
Dampak Kolonialisme Imperialisme

Flashcard
•
11th Grade
10 questions
IES RIBERA Relative pronouns

Flashcard
•
11th Grade
10 questions
Pengeluaran Makanan (Pemprosesan)

Flashcard
•
KG - University
8 questions
SQL-FLASHCARD

Flashcard
•
KG - University
Popular Resources on Quizizz
15 questions
Character Analysis

Quiz
•
4th Grade
17 questions
Chapter 12 - Doing the Right Thing

Quiz
•
9th - 12th Grade
10 questions
American Flag

Quiz
•
1st - 2nd Grade
20 questions
Reading Comprehension

Quiz
•
5th Grade
30 questions
Linear Inequalities

Quiz
•
9th - 12th Grade
20 questions
Types of Credit

Quiz
•
9th - 12th Grade
18 questions
Full S.T.E.A.M. Ahead Summer Academy Pre-Test 24-25

Quiz
•
5th Grade
14 questions
Misplaced and Dangling Modifiers

Quiz
•
6th - 8th Grade
Discover more resources for Chemistry
17 questions
Chapter 12 - Doing the Right Thing

Quiz
•
9th - 12th Grade
30 questions
Linear Inequalities

Quiz
•
9th - 12th Grade
20 questions
Types of Credit

Quiz
•
9th - 12th Grade
20 questions
Taxes

Quiz
•
9th - 12th Grade
17 questions
Parts of Speech

Quiz
•
7th - 12th Grade
20 questions
Chapter 3 - Making a Good Impression

Quiz
•
9th - 12th Grade
20 questions
Inequalities Graphing

Quiz
•
9th - 12th Grade
10 questions
Identifying equations

Quiz
•
KG - University