
Intro DB : Syntax SQL
Authored by ALI GUNAWAN
Instructional Technology
12th Grade
Used 2+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
39 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Customers" adalah
INSERT INTO Customers (customer_id, customer_name, customer_address) VALUES (1, 'John Doe', '123 Main St')
INSERT INTO Customers (customer_name, customer_address) VALUES ('Jane Smith', '456 Oak Ave')
INSERT INTO Customers (customer_id, customer_name) VALUES (2, 'Jane Smith')
INSERT INTO Customers VALUES (3, 'Michael Johnson', '789 Elm Rd')
2.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Products" adalah:
INSERT INTO Products (product_id, product_name, product_price) VALUES (1, 'Product A', 10.99)
INSERT INTO Products (product_name, product_price) VALUES ('Product B', 24.95)
INSERT INTO Products (product_id, product_name) VALUES (2, 'Product B')
INSERT INTO Products VALUES (3, 'Product C', 8.49)
3.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Orders" adalah
INSERT INTO Orders (order_id, customer_id, order_date) VALUES (1, 1, '2023-07-01')
INSERT INTO Orders (customer_id, order_date) VALUES (2, '2023-07-02')
INSERT INTO Orders (order_id, order_date) VALUES (3, '2023-07-03')
INSERT INTO Orders VALUES (4, 3, '2023-07-04')
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Order_Items" adalah
INSERT INTO Order_Items (order_id, product_id, quantity, product_price) VALUES (2, 2, 3, 7.49)
INSERT INTO Order_Items (item_id, order_id, product_id, quantity, product_price) VALUES (1, 1, 1, 2, 15.99)
INSERT INTO Order_Items (item_id, quantity, product_price) VALUES (3, 3, 8.49)
INSERT INTO Order_Items VALUES (4, 4, 5, 1, 9.95, 0)
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Employees" adalah
INSERT INTO Employees (employee_id, employee_name, employee_position, department_id) VALUES (1, 'John Smith', 'Manager', 2)
INSERT INTO Employees (employee_name, employee_position) VALUES ('Jane Doe', 'Supervisor')
INSERT INTO Employees (employee_id, employee_name) VALUES (2, 'Jane Doe')
INSERT INTO Employees VALUES (3, 'Michael Johnson', 'Salesperson', 3)
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Departments" adalah
INSERT INTO Departments (department_name) VALUES ('Marketing')
INSERT INTO Departments (department_id, department_name) VALUES (1, 'Sales')
INSERT INTO Departments (department_id) VALUES (2)
INSERT INTO Departments VALUES (3, 'Finance')
7.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Perintah SQL INSERT yang benar untuk menambahkan data baru ke tabel "Sales" adalah
INSERT INTO Sales (sale_id, employee_id, order_id, sale_date) VALUES (1, 1, 1, '2023-07-05')
INSERT INTO Sales (employee_id, order_id, sale_date) VALUES (2, 2, '2023-07-06')
INSERT INTO Sales (sale_id, sale_date) VALUES (3, '2023-07-07')
INSERT INTO Sales VALUES (4, 3, 3, '2023-07-08')
Access all questions and much more by creating a free account
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
Already have an account?