
Quiz 2 Basis Data
Authored by Putu Ciptayani
Computers
University
Used 5+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
22 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Gunakan database northwind, manakah perintah SQL yang tidak tepat untuk menampilkan data product dan kategorinya?
SELECT ProductID,ProductName,CategoryID,CategoryName
FROM products NATURAL JOIN categories;
SELECT ProductID,ProductName,CategoryName
FROM products INNER JOIN categories USING(CategoryID);
SELECT ProductID,ProductName,CategoryName
FROM products INNER JOIN categories ON products.CategoryID=categories.CategoryID;
SELECT ProductID,ProductName,CategoryName
FROM products JOIN categories;
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Mekanisme yang dapat digunakan untuk mengubah sintaks pembuatan view adalah:
Menggunakan SQL UPDATE
Menggunakan SQL ALTER
Menggunakan SQL DROP kemudian CREATE
Menggunakan SQL DELETE kemudian CREATE
3.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Manakah dari view berikut yang bersifat updatable?
CREATE ALGORITHM=MERGE VIEW v_soal
AS SELECT SupplierID,CompanyName,Region FROM suppliers;
CREATE VIEW v_soal
AS SELECT Region, COUNT(SupplierID) AS jumlah FROM suppliers GROUP BY Region;
CREATE ALGORITHM=TEMPTABLE VIEW v_soal
AS SELECT SupplierID,City, Country FROM suppliers;
CREATE VIEW v_soal
AS SELECT DISTINCT Region FROM suppliers;
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Diketahui sintaks pembuatan view seperti berikut:
CREATE VIEW v_soal
AS SELECT ProductID,ProductName,SupplierID,CategoryID,UnitPrice,UnitsInStock FROM products
WHERE SupplierID=7 WITH CHECK OPTION;
Pilih pernyataan yang benar mengenai v_soal
v_soal tidak dapat menambahkan data baru ke dalam tabel products
Jika WITH CHECK OPTION dihilangkan, maka v_soal dapat menghapus semua data dari tabel products
Jika WITH CHECK OPTION dihilangkan, v_soal tidak akan bisa menghapus products dari supplierID 7
WITH CHECK OPTION membuat v_soal hanya bisa melakukan insert data product dengan supplierID 7
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Perintah SQL manakah yang akan menampilkan data produk yang harganya di atas rata-rata harga produk lainnya?
SELECT * FROM products HAVING AVG(UnitPrice) < UnitPrice;
SELECT * FROM products WHERE UnitPrice > AVG(UnitPrice);
SELECT * FROM products WHERE UnitPrice > (SELECT AVG(UnitPrice) FROM products);
SELECT *, AVG(ProductID) AS rata FROM products HAVING UnitPrice > rata;
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
SQL manakah yang akan menampilkan data produk yang tidak pernah terjual (tidak laku)
SELECT * FROM products WHERE productID NOT IN (SELECT ProductID FROM `order details`);
SELECT * FROM products WHERE productID IN (SELECT ProductID FROM `order details`);
SELECT * FROM products NATURAL JOIN `order details` WHERE ProductID IS NULL;
SELECT * FROM products NATURAL JOIN `order details` WHERE ProductID IS NOT NULL;
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SQL manakah yang akan menampilkan data order yang dilakukan oleh customer dari PT ABC
SELECT * FROM orders WHERE CustomerID IN (SELECT CustomerID FROM customers WHERE CompanyName = 'PT ABC')
SELECT * FROM orders WHERE CustomerID = (SELECT CustomerID FROM customers WHERE CompanyName = 'PT ABC')
SELECT orders.* FROM orders NATURAL JOIN customers WHERE CompanyName = 'PT ABC'
Semua benar
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?
Similar Resources on Wayground
20 questions
Sử dụng Word (51 - 70)
Quiz
•
University
20 questions
basisdata1
Quiz
•
University
20 questions
9a eSafety
Quiz
•
6th Grade - University
20 questions
CSS Pseudo dan CSS Grid System
Quiz
•
University
18 questions
SQL Quiz
Quiz
•
University
20 questions
POST TEST WEB STATIC
Quiz
•
University - Professi...
17 questions
Bases de données et SQL
Quiz
•
University
20 questions
Google SketchUp Tool
Quiz
•
KG - University
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
5 questions
What is Presidents' Day?
Interactive video
•
10th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
20 questions
Mardi Gras History
Quiz
•
6th Grade - University
10 questions
The Roaring 20's Crash Course US History
Interactive video
•
11th Grade - University
17 questions
Review9_TEACHER
Quiz
•
University