NEW
Font size
S
M
L
XL
WorksheetsIntro DB : Syntax SQL
Total questions: 39
Worksheet time: 1hrs 18mins
Name
Class
Date
1.
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Customers" adalah
a)
INSERT INTO Customers (customer_id, customer_name, customer_address) VALUES (1, 'John Doe', '123 Main St')
b)
INSERT INTO Customers (customer_name, customer_address) VALUES ('Jane Smith', '456 Oak Ave')
c)
INSERT INTO Customers (customer_id, customer_name) VALUES (2, 'Jane Smith')
d)
INSERT INTO Customers VALUES (3, 'Michael Johnson', '789 Elm Rd')
2.
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Products" adalah:
a)
INSERT INTO Products (product_id, product_name, product_price) VALUES (1, 'Product A', 10.99)
b)
INSERT INTO Products (product_name, product_price) VALUES ('Product B', 24.95)
c)
INSERT INTO Products (product_id, product_name) VALUES (2, 'Product B')
d)
INSERT INTO Products VALUES (3, 'Product C', 8.49)
3.
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Orders" adalah
a)
INSERT INTO Orders (order_id, customer_id, order_date) VALUES (1, 1, '2023-07-01')
b)
INSERT INTO Orders (customer_id, order_date) VALUES (2, '2023-07-02')
c)
INSERT INTO Orders (order_id, order_date) VALUES (3, '2023-07-03')
d)
INSERT INTO Orders VALUES (4, 3, '2023-07-04')
4.
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Order_Items" adalah
a)
INSERT INTO Order_Items (order_id, product_id, quantity, product_price) VALUES (2, 2, 3, 7.49)
b)
INSERT INTO Order_Items (item_id, order_id, product_id, quantity, product_price) VALUES (1, 1, 1, 2, 15.99)
c)
INSERT INTO Order_Items (item_id, quantity, product_price) VALUES (3, 3, 8.49)
d)
INSERT INTO Order_Items VALUES (4, 4, 5, 1, 9.95, 0)
5.
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Employees" adalah
a)
INSERT INTO Employees (employee_id, employee_name, employee_position, department_id) VALUES (1, 'John Smith', 'Manager', 2)
b)
INSERT INTO Employees (employee_name, employee_position) VALUES ('Jane Doe', 'Supervisor')
c)
INSERT INTO Employees (employee_id, employee_name) VALUES (2, 'Jane Doe')
d)
INSERT INTO Employees VALUES (3, 'Michael Johnson', 'Salesperson', 3)
6.
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Departments" adalah
a)
INSERT INTO Departments (department_name) VALUES ('Marketing')
b)
INSERT INTO Departments (department_id, department_name) VALUES (1, 'Sales')
c)
INSERT INTO Departments (department_id) VALUES (2)
d)
INSERT INTO Departments VALUES (3, 'Finance')
7.
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Sales" adalah
a)
INSERT INTO Sales (sale_id, employee_id, order_id, sale_date) VALUES (1, 1, 1, '2023-07-05')
b)
INSERT INTO Sales (employee_id, order_id, sale_date) VALUES (2, 2, '2023-07-06')
c)
INSERT INTO Sales (sale_id, sale_date) VALUES (3, '2023-07-07')
d)
INSERT INTO Sales VALUES (4, 3, 3, '2023-07-08')
8.
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Suppliers" adalah
a)
INSERT INTO Suppliers (supplier_id, supplier_name) VALUES (2, 'DEF Suppliers')
b)
INSERT INTO Suppliers (supplier_name, supplier_address) VALUES ('XYZ Company', '456 Supplier Ave')
c)
INSERT INTO Suppliers (supplier_id, supplier_name, supplier_address) VALUES (1, 'ABC Suppliers', '123 Supplier St')
d)
INSERT INTO Suppliers VALUES (3, 'GHI Corporation', '789 Supplier Rd')
9.
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Stocks" adalah
a)
INSERT INTO Stocks (stock_id, product_id, quantity) VALUES (1, 1, 100)
b)
INSERT INTO Stocks (product_id, quantity) VALUES (2, 75)
c)
INSERT INTO Stocks (stock_id, quantity) VALUES (3, 50)
d)
INSERT INTO Stocks VALUES (4, 3, 200)
10.
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Promotions" adalah
a)
INSERT INTO Promotions (promotion_id, product_id, start_date, end_date, Disc) VALUES (1, 1, '2023-07-10', '2023-07-20', 0.1)
b)
INSERT INTO Promotions (product_id, start_date, end_date, Disc) VALUES (2, '2023-07-15', '2023-07-25', 0.15)
c)
INSERT INTO Promotions (promotion_id, start_date, end_date) VALUES (3, '2023-07-18', '2023-07-28')
d)
INSERT INTO Promotions VALUES (4, 3, '2023-07-20', '2023-07-30', 0.05)
11.
Perintah SQL DELETE yang benar untuk menghapus pelanggan beserta pesanan yang terkait berdasarkan tabel "Customers" dan "Orders" adalah
a)
DELETE FROM Customers WHERE customer_id = 1
b)
DELETE FROM Orders WHERE customer_id = 1
c)
DELETE Customers, Orders FROM Customers INNER JOIN Orders ON Customers.customer_id = Orders.customer_id WHERE Customers.customer_id = 1
d)
DELETE FROM Customers INNER JOIN Orders ON Customers.customer_id = Orders.customer_id WHERE Customers.customer_id = 1
12.
Perintah SQL DELETE yang benar untuk menghapus produk beserta item pesanan yang harganya lebih dari 100 berdasarkan tabel "Products" dan "Order_Items" adalah
a)
DELETE FROM Products WHERE product_price > 100
b)
DELETE FROM Order_Items WHERE product_price > 100
c)
DELETE Products, Order_Items FROM Products INNER JOIN Order_Items ON Products.product_id = Order_Items.product_id WHERE Products.product_price > 100
d)
DELETE Products FROM Products INNER JOIN Order_Items ON Products.product_id = Order_Items.product_id WHERE Products.product_price > 100
13.
Perintah SQL DELETE yang benar untuk menghapus pelanggan dan pesanan yang tanggalnya lebih dari 1 Januari 2022 berdasarkan tabel "Customers" dan "Orders" adalah
a)
DELETE FROM Customers WHERE customer_id IN (SELECT customer_id FROM Orders WHERE order_date > '2022-01-01')
b)
DELETE FROM Orders WHERE customer_id IN (SELECT customer_id FROM Customers WHERE order_date > '2022-01-01')
c)
DELETE Customers, Orders FROM Customers INNER JOIN Orders ON Customers.customer_id = Orders.customer_id WHERE Orders.order_date > '2022-01-01'
d)
DELETE FROM Customers INNER JOIN Orders ON Customers.customer_id = Orders.customer_id WHERE Orders.order_date > '2022-01-01'
14.
Perintah SQL DELETE yang benar untuk menghapus produk beserta item pesanan yang diskonnya lebih dari 0.1 berdasarkan tabel "Products" dan "Order_Items" adalah
a)
DELETE FROM Products WHERE product_id IN (SELECT product_id FROM Order_Items WHERE Disc > 0.1)
b)
DELETE FROM Order_Items WHERE product_id IN (SELECT product_id FROM Products WHERE Disc > 0.1)
c)
DELETE Products, Order_Items FROM Products INNER JOIN Order_Items ON Products.product_id = Order_Items.product_id WHERE Order_Items.Disc > 0.1
d)
DELETE FROM Products INNER JOIN Order_Items ON Products.product_id = Order_Items.product_id WHERE Order_Items.Disc > 0.1
15.
Perintah SQL DELETE yang benar untuk menghapus pelanggan dan pesanan yang tidak ada pada tabel "Orders" berdasarkan tabel "Customers" adalah
a)
DELETE FROM Customers WHERE customer_id NOT IN (SELECT customer_id FROM Orders)
b)
DELETE FROM Orders WHERE customer_id NOT IN (SELECT customer_id FROM Customers)
c)
DELETE Customers, Orders FROM Customers INNER JOIN Orders ON Customers.customer_id = Orders.customer_id WHERE Customers.customer_id NOT IN (SELECT customer_id FROM Orders)
d)
DELETE FROM Customers INNER JOIN Orders ON Customers.customer_id = Orders.customer_id WHERE Customers.customer_id NOT IN (SELECT customer_id FROM Orders)
16.
Perintah SQL DELETE yang benar untuk menghapus produk beserta item pesanan yang tidak ada pada tabel "Order_Items" berdasarkan tabel "Products" adalah
a)
DELETE FROM Products WHERE product_id NOT IN (SELECT product_id FROM Order_Items)
b)
DELETE FROM Order_Items WHERE product_id NOT IN (SELECT product_id FROM Products)
c)
DELETE Products, Order_Items FROM Products INNER JOIN Order_Items ON Products.product_id = Order_Items.product_id WHERE Products.product_id NOT IN (SELECT product_id FROM Order_Items)
d)
DELETE FROM Products INNER JOIN Order_Items ON Products.product_id = Order_Items.product_id WHERE Products.product_id NOT IN (SELECT product_id FROM Order_Items)
17.
Perintah SQL DELETE yang benar untuk menghapus karyawan yang posisinya bukan "Manager" atau "Supervisor" berdasarkan tabel "Employees" adalah
a)
DELETE FROM Employees WHERE employee_position IN ('Manager', 'Supervisor')
b)
DELETE FROM Employees WHERE employee_position NOT IN ('Manager', 'Supervisor')
c)
DELETE Employees, Departments FROM Employees INNER JOIN Departments ON Employees.department_id = Departments.department_id WHERE Employees.employee_position NOT IN ('Manager', 'Supervisor')
d)
DELETE FROM Employees INNER JOIN Departments ON Employees.department_id = Departments.department_id WHERE Employees.employee_position NOT IN ('Manager', 'Supervisor')
18.
Perintah SQL DELETE yang benar untuk menghapus pelanggan dan pesanan yang tanggalnya sebelum 1 Januari 2022 berdasarkan tabel "Customers" dan "Orders" adalah
a)
DELETE FROM Customers WHERE customer_id IN (SELECT customer_id FROM Orders WHERE order_date < '2022-01-01')
b)
DELETE FROM Orders WHERE customer_id IN (SELECT customer_id FROM Customers WHERE order_date < '2022-01-01')
c)
DELETE Customers, Orders FROM Customers INNER JOIN Orders ON Customers.customer_id = Orders.customer_id WHERE Orders.order_date < '2022-01-01'
d)
DELETE FROM Customers INNER JOIN Orders ON Customers.customer_id = Orders.customer_id WHERE Orders.order_date < '2022-01-01'
19.
Perintah SQL DELETE yang benar untuk menghapus produk beserta item pesanan yang diskonnya tidak ada dalam tabel "Promotions" berdasarkan tabel "Products" dan "Order_Items" adalah
a)
DELETE FROM Products WHERE product_id NOT IN (SELECT product_id FROM Promotions)
b)
DELETE FROM Order_Items WHERE product_id NOT IN (SELECT product_id FROM Promotions)
c)
DELETE Products, Order_Items FROM Products INNER JOIN Order_Items ON Products.product_id = Order_Items.product_id WHERE Order_Items.product_id NOT IN (SELECT product_id FROM Promotions)
d)
DELETE Products FROM Products INNER JOIN Order_Items ON Products.product_id = Order_Items.product_id WHERE Order_Items.product_id NOT IN (SELECT product_id FROM Promotions)
20.
Perintah SQL DELETE yang benar untuk menghapus produk beserta item pesanan yang ada dalam tabel "Stocks" berdasarkan tabel "Products" dan "Order_Items" adalah
a)
DELETE FROM Products WHERE product_id IN (SELECT product_id FROM Stocks)
b)
DELETE FROM Order_Items WHERE product_id IN (SELECT product_id FROM Stocks)
c)
DELETE Products, Order_Items FROM Products INNER JOIN Order_Items ON Products.product_id = Order_Items.product_id WHERE Products.product_id IN (SELECT product_id FROM Stocks)
d)
DELETE Products FROM Products INNER JOIN Order_Items ON Products.product_id = Order_Items.product_id WHERE Products.product_id IN (SELECT product_id FROM Stocks)
21.
Perintah SQL DELETE yang benar untuk menghapus produk yang harganya lebih dari 1000 dan ada dalam tabel "Promotions" berdasarkan tabel "Products" adalah
a)
DELETE FROM Products WHERE product_id IN (SELECT product_id FROM Promotions) AND product_price > 1000
b)
DELETE FROM Products WHERE product_id IN (SELECT product_id FROM Promotions) AND product_price < 1000
c)
DELETE FROM Products WHERE product_id NOT IN (SELECT product_id FROM Promotions) AND product_price > 1000
d)
DELETE FROM Products WHERE product_id NOT IN (SELECT product_id FROM Promotions) AND product_price < 1000
22.
Perintah SQL DELETE yang benar untuk menghapus produk yang harganya kurang dari 500 atau tidak ada dalam tabel "Promotions" berdasarkan tabel "Products" adalah
a)
DELETE FROM Products WHERE product_id IN (SELECT product_id FROM Promotions) OR product_price < 500
b)
DELETE FROM Products WHERE product_id IN (SELECT product_id FROM Promotions) OR product_price > 500
c)
DELETE FROM Products WHERE product_id NOT IN (SELECT product_id FROM Promotions) OR product_price < 500
d)
DELETE FROM Products WHERE product_id NOT IN (SELECT product_id FROM Promotions) OR product_price > 500
23.
Perintah SQL DELETE yang benar untuk menghapus pelanggan dan pesanan yang tanggalnya tidak sebelum 1 Januari 2022 berdasarkan tabel "Customers" dan "Orders" adalah
a)
DELETE FROM Customers WHERE customer_id NOT IN (SELECT customer_id FROM Orders WHERE order_date < '2022-01-01')
b)
DELETE FROM Orders WHERE customer_id NOT IN (SELECT customer_id FROM Customers WHERE order_date < '2022-01-01')
c)
DELETE Customers, Orders FROM Customers INNER JOIN Orders ON Customers.customer_id = Orders.customer_id WHERE Orders.order_date NOT IN (SELECT order_date FROM Orders WHERE order_date < '2022-01-01')
d)
DELETE FROM Customers INNER JOIN Orders ON Customers.customer_id = Orders.customer_id WHERE Orders.order_date NOT IN (SELECT order_date FROM Orders WHERE order_date < '2022-01-01')
24.
Perintah SQL DELETE yang benar untuk menghapus produk beserta item pesanan yang harganya tidak ada dalam tabel "Promotions" berdasarkan tabel "Products" dan "Order_Items" adalah
a)
DELETE FROM Products WHERE product_id IN (SELECT product_id FROM Promotions) AND product_price NOT IN (SELECT product_price FROM Promotions)
b)
DELETE FROM Order_Items WHERE product_id IN (SELECT product_id FROM Products WHERE product_price NOT IN (SELECT product_price FROM Promotions))
c)
DELETE Products, Order_Items FROM Products INNER JOIN Order_Items ON Products.product_id = Order_Items.product_id WHERE Products.product_price NOT IN (SELECT Products.product_price FROM Promotions)
d)
DELETE FROM Products INNER JOIN Order_Items ON Products.product_id = Order_Items.product_id WHERE Products.product_price NOT IN (SELECT product_price FROM Promotions)
25.
Perintah SQL DELETE yang benar untuk menghapus pelanggan dan pesanan yang ada dalam tabel "Orders" dan tidak ada dalam tabel "Customers" berdasarkan tabel "Customers" dan "Orders" adalah
a)
DELETE FROM Customers WHERE customer_id NOT IN (SELECT customer_id FROM Orders) AND customer_id IN (SELECT customer_id FROM Customers)
b)
DELETE FROM Orders WHERE customer_id NOT IN (SELECT customer_id FROM Customers) AND customer_id IN (SELECT customer_id FROM Orders)
c)
DELETE Customers, Orders FROM Customers INNER JOIN Orders ON Customers.customer_id = Orders.customer_id WHERE Customers.customer_id NOT IN (SELECT customer_id FROM Orders) AND Orders.customer_id IN (SELECT customer_id FROM Customers)
d)
DELETE FROM Customers INNER JOIN Orders ON Customers.customer_id = Orders.customer_id WHERE Customers.customer_id NOT IN (SELECT customer_id FROM Orders) AND Orders.customer_id IN (SELECT customer_id FROM Customers)
26.
Perintah SQL UPDATE yang benar untuk mengubah harga produk menjadi 150000 untuk produk dengan product_id = 101 berdasarkan tabel "Products" adalah
a)
UPDATE Products SET product_price = 150000 WHERE product_id = 101
b)
UPDATE Products SET product_price = 150000 WHERE product_id = '101'
c)
UPDATE Products SET product_price = '150000' WHERE product_id = 101
d)
UPDATE Products SET product_price = '150000' WHERE product_id = '101'
27.
Perintah SQL UPDATE yang benar untuk mengubah alamat pelanggan dengan customer_id = 202 menjadi "Jalan Merdeka No. 10" berdasarkan tabel "Customers" adalah
a)
UPDATE Customers SET customer_address = 'Jalan Merdeka No. 10' WHERE customer_id = 202
b)
UPDATE Customers SET customer_address = 'Jalan Merdeka No. 10' WHERE customer_id = '202'
c)
UPDATE Customers SET customer_address = "Jalan Merdeka No. 10" WHERE customer_id = 202
d)
UPDATE Customers SET customer_address = "Jalan Merdeka No. 10" WHERE customer_id = '202'
28.
Perintah SQL UPDATE yang benar untuk mengubah tanggal pesanan dengan order_id = 301 menjadi "2023-07-15" berdasarkan tabel "Orders" adalah
a)
UPDATE Orders SET order_date = '2023-07-15' WHERE order_id = 301
b)
UPDATE Orders SET order_date = '2023-07-15' WHERE order_id = '301'
c)
UPDATE Orders SET order_date = "2023-07-15" WHERE order_id = 301
d)
UPDATE Orders SET order_date = "2023-07-15" WHERE order_id = '301'
29.
Perintah SQL UPDATE yang benar untuk mengubah posisi pegawai dengan employee_id = 401 menjadi "Manager" berdasarkan tabel "Employees" adalah
a)
UPDATE Employees SET employee_position = 'Manager' WHERE employee_id = 401
b)
UPDATE Employees SET employee_position = 'Manager' WHERE employee_id = '401'
c)
UPDATE Employees SET employee_position = "Manager" WHERE employee_id = 401
d)
UPDATE Employees SET employee_position = "Manager" WHERE employee_id = '401'
30.
Perintah SQL UPDATE yang benar untuk mengubah harga produk menjadi 200000 untuk produk dengan product_id = 201 dan item pesanan dengan item_id = 501 berdasarkan tabel "Products" dan "Order_Items" adalah
a)
UPDATE Products Inner Join order_items ON Products.product_id = Products.product_id SET order_items.product_price = 200000 WHERE Products.product_id = 201 AND item_id = 501
b)
UPDATE Products SET product_price = 200000 WHERE product_id = '201' AND item_id = '501'
c)
UPDATE Products SET product_price = '200000' WHERE product_id = 201 AND item_id = 501
d)
UPDATE Products SET product_price = '200000' WHERE product_id = '201' AND item_id = '501'
31.
Perintah SQL UPDATE yang benar untuk mengubah alamat pelanggan menjadi "Jalan Merdeka No. 5" dan tanggal pesanan menjadi "2023-07-20" untuk pesanan yang customer_id = 202 berdasarkan tabel "Customers" dan "Orders" adalah:
a)
UPDATE Customers, Orders SET customer_address = 'Jalan Merdeka No. 5', order_date = '2023-07-20' WHERE customer_id = 202
b)
UPDATE Customers SET customer_address = 'Jalan Merdeka No. 5', Orders SET order_date = '2023-07-20' WHERE customer_id = 202
c)
UPDATE Customers SET customer_address = 'Jalan Merdeka No. 5' AND Orders SET order_date = '2023-07-20' WHERE customer_id = 202
d)
UPDATE Customers Inner Join orders ON Customers.customer_id = orders.customer_id SET customer_address = 'Jalan Merdeka No. 5' , order_date = '2023-07-20' WHERE Customers.customer_id = 202
32.
Perintah SQL UPDATE yang benar untuk mengubah posisi pegawai menjadi "Supervisor" untuk pegawai dengan employee_id = 402 berdasarkan tabel "Employees" adalah
a)
UPDATE Employees SET employee_position = 'Supervisor' WHERE employee_id = 402
b)
UPDATE Employees SET employee_position = 'Supervisor' WHERE employee_id = '402'
c)
UPDATE Employees SET employee_position = "Supervisor" WHERE employee_id = 402
d)
UPDATE Employees SET employee_position = "Supervisor" WHERE employee_id = '402'
33.
Perintah SQL UPDATE yang benar untuk mengubah jumlah stok menjadi 50 untuk produk dengan product_id = 301 berdasarkan tabel "Stocks" adalah
a)
UPDATE Stocks SET quantity = 50 WHERE product_id = 301
b)
UPDATE Stocks SET quantity = 50 WHERE product_id = '301'
c)
UPDATE Stocks SET quantity = '50' WHERE product_id = 301
d)
UPDATE Stocks SET quantity = '50' WHERE product_id = '301'
34.
Perintah SQL UPDATE yang benar untuk mengubah posisi pegawai menjadi "Manager" untuk pegawai yang bekerja di departemen dengan department_name = "HR" berdasarkan tabel "Employees" dan "Departments" adalah
a)
UPDATE Employees SET employee_position = 'Manager' WHERE department_id = (SELECT department_id FROM Departments WHERE department_name = 'HR')
b)
UPDATE Employees SET employee_position = 'Manager' WHERE department_id = (SELECT department_id FROM Employees WHERE department_name = 'HR')
c)
UPDATE Employees SET employee_position = 'Manager' WHERE department_id IN (SELECT department_id FROM Departments WHERE department_name = 'HR')
d)
UPDATE Employees SET employee_position = 'Manager' WHERE department_id IN (SELECT department_id FROM Employees WHERE department_name = 'HR')
35.
Perintah SQL UPDATE yang benar untuk mengubah tanggal pesanan menjadi "2023-07-21" untuk pesanan dengan order_id = 302 dan order_id = 303 berdasarkan tabel "Orders" adalah
a)
UPDATE Orders SET order_date = '2023-07-21' WHERE order_id = 302 OR order_id = 303
b)
UPDATE Orders SET order_date = '2023-07-21' WHERE order_id IN (302, 303)
c)
UPDATE Orders SET order_date = '2023-07-21' WHERE order_id = '302' OR order_id = '303'
d)
UPDATE Orders SET order_date = '2023-07-21' WHERE order_id IN ('302', '303')
36.
Perintah SQL UPDATE yang benar untuk mengubah harga produk menjadi 250000 untuk produk yang memiliki promosi (product_id ada di tabel "Promotions") dan harga awalnya lebih rendah dari 250000 berdasarkan tabel "Products" dan "Promotions" adalah
a)
UPDATE Products SET product_price = 250000 WHERE product_id IN (SELECT product_id FROM Promotions) AND product_price < 250000
b)
UPDATE Products SET product_price = 250000 WHERE product_id IN (SELECT product_id FROM Products WHERE product_price < 250000)
c)
UPDATE Products SET product_price = 250000 WHERE product_id IN (SELECT product_id FROM Promotions) AND product_price NOT IN (SELECT product_price FROM Promotions)
d)
UPDATE Products SET product_price = 250000 WHERE product_id IN (SELECT product_id FROM Products WHERE product_price < 250000) AND product_id IN (SELECT product_id FROM Promotions)
37.
Perintah SQL UPDATE yang benar untuk mengubah jumlah item menjadi 3 dan harga produk menjadi 50000 untuk produk dengan product_id = 401 dan order_id = 501 berdasarkan tabel "Order_Items" dan "Products" adalah
a)
UPDATE Order_Items, Products SET quantity = 3, product_price = 50000 WHERE product_id = 401 AND order_id = 501
b)
UPDATE Order_Items SET quantity = 3 WHERE product_id = 401 AND order_id = 501; UPDATE Products SET product_price = 50000 WHERE product_id = 401
c)
UPDATE Order_Items Inner Join Products ON Order_Items.product_id = products.product_id SET quantity = 3, Order_Items.product_price = 50000 WHERE Order_Items.product_id = 401 AND order_id = 501
d)
UPDATE Order_Items, Products SET quantity = 3, product_price = 50000 WHERE product_id = 401 AND order_id = 501 AND product_id = 401 AND order_id = 501
38.
Perintah SQL UPDATE yang benar untuk mengubah harga produk menjadi 120000 untuk produk dengan product_id = 301, 302, 303 berdasarkan tabel "Products" adalah
a)
UPDATE Products SET product_price = 120000 WHERE product_id IN (301, 302, 303)
b)
UPDATE Products SET product_price = 120000 WHERE product_id = 301, 302, 303
c)
UPDATE Products SET product_price = 120000 WHERE product_id BETWEEN 301 AND 303
d)
UPDATE Products SET product_price = 120000 WHERE product_id = '301, 302, 303'
39.
Perintah SQL UPDATE yang benar untuk mengubah alamat pelanggan menjadi "Jalan Ahmad Yani No. 30" untuk pesanan dengan customer_id = 203 berdasarkan tabel "Customers" dan "Orders" adalah
a)
UPDATE Customers SET customer_address = 'Jalan Ahmad Yani No. 30' WHERE customer_id IN (SELECT customer_id FROM Orders WHERE customer_id = 203)
b)
UPDATE Customers SET customer_address = 'Jalan Ahmad Yani No. 30' WHERE customer_id = 203 AND order_id IN (SELECT order_id FROM Orders)
c)
UPDATE Customers SET customer_address = 'Jalan Ahmad Yani No. 30' WHERE customer_id IN (SELECT customer_id FROM Orders WHERE order_id = 203)
d)
UPDATE Customers SET customer_address = 'Jalan Ahmad Yani No. 30' WHERE customer_id IN (SELECT customer_id FROM Orders) AND customer_id = 203
Reset
