Search Header Logo

Intro DB : Syntax SQL

Authored by ALI GUNAWAN

Instructional Technology

12th Grade

Used 2+ times

Intro DB : Syntax SQL
AI

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

Google

Continue with Google

Email

Continue with Email

Microsoft

Continue with Microsoft

or continue with

Facebook

Facebook

Apple

Apple

Others

Others

Already have an account?