Dalam SQL, fungsi COUNT() digunakan untuk...

Menghitung jumlah baris yang sesuai dengan kondisi

Mengambil nilai maksimum dari kolom

Mengambil nilai minimum dari kolom

Dalam perancangan basis data, ERD digunakan untuk...

Menggambarkan relasi antar entitas

Kunci kandidat adalah...

Atribut yang unik tetapi tidak dipilih sebagai primary key

Atribut yang selalu berisi NULL

Atribut dengan tipe data string

Atribut yang digunakan untuk foreign key

Atribut yang bersifat multivalued

Bagaimana cara membuat tabel 'pegawai' dengan kolom 'id' bertipe INT dan 'nama' bertipe VARCHAR(50)?

CREATE TABLE pegawai (id INT, nama VARCHAR(50));

CREATE TABLE pegawai (id INTEGER, nama TEXT(50));

CREATE pegawai (id INT, nama VARCHAR(50));

NEW TABLE pegawai (id INT, nama VARCHAR(50));

BUILD TABLE pegawai (id INT, nama VARCHAR(50));

Bagaimana perintah SQL untuk menambahkan kolom 'email' ke tabel 'pegawai'?

ALTER TABLE pegawai ADD email VARCHAR(100);

MODIFY TABLE pegawai email VARCHAR(100);

INSERT INTO pegawai email VARCHAR(100);

ALTER pegawai ADD COLUMN email VARCHAR(100);

Bagaimana cara menampilkan semua data dari tabel 'pegawai' yang memiliki nama 'Andi'?

SELECT * FROM pegawai WHERE nama = 'Andi';

SELECT nama = 'Andi' FROM pegawai;

SELECT * FROM pegawai HAVING nama = 'Andi';

SHOW * FROM pegawai WHERE nama = 'Andi';

DISPLAY ALL FROM pegawai WHERE nama = 'Andi';

Tabel `students` memiliki kolom `student_id`, `student_name`, `gpa`. Anda ingin menampilkan nama mahasiswa dengan GPA lebih besar dari 3.5. Perintah SQL yang tepat adalah:

SELECT student_name FROM students WHERE gpa > 3.5;

SELECT student_name FROM students WHERE gpa >= 3.5;

SELECT student_name FROM students WHERE gpa = 3.5;

SELECT student_name FROM students WHERE gpa BETWEEN 3.0 AND 4.0;

SELECT student_name FROM students WHERE gpa < 3.5;

Tabel `courses` memiliki kolom `course_id`, `course_name`. Tabel `students_courses` memiliki kolom `student_id`, `course_id`. Anda ingin mengetahui jumlah mahasiswa yang terdaftar di setiap mata kuliah. Perintah SQL yang tepat adalah:

SELECT c.course_name, COUNT(sc.student_id) FROM students_courses sc INNER JOIN courses c ON sc.course_id = c.course_id GROUP BY c.course_name;

SELECT c.course_name, COUNT(sc.student_id) FROM students_courses sc LEFT JOIN courses c ON sc.course_id = c.course_id GROUP BY c.course_name;

SELECT c.course_name, COUNT(sc.student_id) FROM students_courses sc INNER JOIN courses c ON sc.course_id = c.course_id GROUP BY c.course_name HAVING COUNT(sc.student_id) > 10;

SELECT course_name, COUNT(student_id) FROM students_courses GROUP BY course_name;

SELECT course_name, COUNT(student_id) FROM students_courses GROUP BY course_name HAVING COUNT(student_id) > 20;

Tabel `orders` memiliki kolom `order_id`, `order_date`, dan `total_amount`. Anda ingin menghitung total penjualan yang terjadi dalam rentang waktu tertentu. Perintah SQL yang tepat adalah:

SELECT SUM(total_amount) FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31';

SELECT COUNT(order_id) FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-06-30';

SELECT total_amount FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31';

SELECT SUM(total_amount) FROM orders WHERE order_date >= '2023-01-01';

SELECT COUNT(order_id) FROM orders WHERE order_date >= '2023-01-01';

Tabel `employees` memiliki kolom `emp_id`, `emp_name`, `salary`, dan `department_id`. Anda ingin mengetahui rata-rata gaji di setiap departemen. Perintah SQL yang tepat adalah:

SELECT department_id, AVG(salary) FROM employees GROUP BY department_id;

SELECT department_id, MAX(salary) FROM employees GROUP BY department_id;

SELECT department_id, MIN(salary) FROM employees GROUP BY department_id;

SELECT department_id, COUNT(emp_id) FROM employees GROUP BY department_id;

SELECT department_id, SUM(salary) FROM employees GROUP BY department_id;

Tabel `students` memiliki kolom `student_id`, `student_name`. Tabel `courses` memiliki kolom `course_id`, `course_name`. Anda ingin menampilkan daftar mahasiswa yang mengambil mata kuliah tertentu, misalnya 'Database'. Perintah SQL yang tepat adalah:

SELECT s.student_name FROM students s INNER JOIN students_courses sc ON s.student_id = sc.student_id INNER JOIN courses c ON sc.course_id = c.course_id WHERE c.course_name = 'Database';

SELECT s.student_name FROM students s INNER JOIN students_courses sc ON s.student_id = sc.student_id WHERE sc.course_id = 101;

SELECT s.student_name FROM students s LEFT JOIN students_courses sc ON s.student_id = sc.student_id WHERE sc.course_id = 101;

SELECT s.student_name FROM students WHERE student_id IN (SELECT student_id FROM students_courses WHERE course_id = 101);

SELECT s.student_name FROM students s LEFT JOIN courses c ON s.student_id = c.student_id WHERE c.course_name = 'Database';

Tabel `products` memiliki kolom `product_id`, `product_name`, `price`. Anda ingin mengubah harga produk dengan `product_id` tertentu menjadi Rp 500.000. Perintah SQL yang tepat adalah:

UPDATE products SET price = 500000 WHERE product_id = 101;

UPDATE products SET price = 600000 WHERE product_id = 102;

UPDATE products SET price = 400000 WHERE product_id = 105;

UPDATE products SET price = 550000 WHERE product_id = 104;

UPDATE products SET price = 450000 WHERE product_id = 103;

Tabel `employees` memiliki kolom `emp_id`, `emp_name`, `salary`, dan `department_id`. Anda ingin mengetahui karyawan yang memiliki gaji lebih tinggi daripada rata-rata gaji karyawan dalam departemen yang sama. Perintah SQL yang tepat adalah:

SELECT emp_name FROM employees WHERE salary > (SELECT AVG(salary) FROM employees WHERE department_id = employees.department_id);

SELECT emp_name FROM employees WHERE salary > (SELECT MIN(salary) FROM employees WHERE department_id = employees.department_id);

SELECT emp_name FROM employees WHERE salary > (SELECT MAX(salary) FROM employees WHERE department_id = employees.department_id);

SELECT emp_name FROM employees WHERE salary > 5000000;

SELECT emp_name FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);

Tabel `products` memiliki kolom `product_id`, `product_name`, `stock_quantity`, dan `price`. Anda ingin menampilkan produk dengan jumlah stok kurang dari 100. Perintah SQL yang tepat adalah:

SELECT product_name FROM products WHERE stock_quantity < 100;

SELECT product_name FROM products WHERE stock_quantity > 100;

SELECT product_name FROM products WHERE stock_quantity BETWEEN 50 AND 200;

SELECT product_name FROM products WHERE price > 200000;

SELECT product_name FROM products WHERE stock_quantity < 200;

Tabel `students` memiliki kolom `student_id`, `student_name`, `gpa`. Anda ingin menampilkan mahasiswa dengan GPA lebih besar dari 3.0. Perintah SQL yang tepat adalah:

SELECT student_name FROM students WHERE gpa >= 3.0;

SELECT student_name FROM students WHERE gpa > 3.0;

SELECT student_name FROM students WHERE gpa > 3.5;

SELECT student_name FROM students WHERE gpa < 3.0;

SELECT student_name FROM students WHERE gpa BETWEEN 3.0 AND 4.0;

Tabel `courses` memiliki kolom `course_id`, `course_name`. Tabel `students_courses` memiliki kolom `student_id`, `course_id`. Anda ingin menampilkan jumlah mahasiswa yang mengambil mata kuliah 'Database'. Perintah SQL yang tepat adalah:

SELECT c.course_name, COUNT(sc.student_id) FROM students_courses sc LEFT JOIN courses c ON sc.course_id = c.course_id WHERE c.course_name = 'Database';

SELECT c.course_name, COUNT(sc.student_id) FROM students_courses sc INNER JOIN courses c ON sc.course_id = c.course_id WHERE c.course_name = 'Database';

SELECT c.course_name, COUNT(sc.student_id) FROM students_courses sc INNER JOIN courses c ON sc.course_id = c.course_id WHERE c.course_name = 'Database' HAVING COUNT(sc.student_id) > 10;

SELECT COUNT(student_id) FROM students_courses WHERE course_id = (SELECT course_id FROM courses WHERE course_name = 'Database');

SELECT COUNT(student_id) FROM students_courses WHERE course_id = 101;

Tabel `orders` memiliki kolom `order_id`, `order_date`, dan `total_amount`. Anda ingin menampilkan pesanan yang memiliki total lebih dari Rp 1.000.000. Perintah SQL yang tepat adalah:

SELECT * FROM orders WHERE total_amount < 1000000;

SELECT * FROM orders WHERE total_amount > 1000000;

SELECT * FROM orders WHERE total_amount = 1000000;

SELECT * FROM orders WHERE total_amount >= 1000000;

SELECT * FROM orders WHERE total_amount <= 1000000;

Tabel `employees` memiliki kolom `emp_id`, `emp_name`, `salary`, dan `department_id`. Anda ingin mengetahui rata-rata gaji karyawan per departemen yang memiliki lebih dari 10 karyawan. Perintah SQL yang tepat adalah:

SELECT department_id, AVG(salary) FROM employees GROUP BY department_id HAVING COUNT(emp_id) > 10;

SELECT department_id, AVG(salary) FROM employees GROUP BY department_id;

SELECT department_id, AVG(salary) FROM employees WHERE department_id = 101 GROUP BY department_id;

SELECT department_id, AVG(salary) FROM employees GROUP BY department_id HAVING COUNT(emp_id) > 5;

SELECT department_id, AVG(salary) FROM employees GROUP BY department_id HAVING COUNT(emp_id) > 15;

Tabel `students` memiliki kolom `student_id`, `student_name`. Anda ingin menghapus mahasiswa dengan `student_id` yang sudah tidak aktif lagi. Perintah SQL yang tepat adalah:

DELETE FROM students WHERE student_id NOT IN (SELECT student_id FROM enrollments);

DELETE FROM students WHERE student_id IN (SELECT student_id FROM enrollments WHERE course_id = 101);

DELETE FROM students WHERE student_id NOT IN (SELECT student_id FROM enrollments WHERE course_id = 102);

DELETE FROM students WHERE student_id = 101;

DELETE FROM students WHERE student_id IN (SELECT student_id FROM enrollments WHERE course_id = 103);

Tabel `products` memiliki kolom `product_id`, `product_name`, `stock_quantity`, dan `price`. Anda ingin menambah stok produk dengan `product_id` tertentu sebanyak 50 unit. Perintah SQL yang tepat adalah:

UPDATE products SET stock_quantity = stock_quantity + 50 WHERE product_id = 103;

UPDATE products SET stock_quantity = stock_quantity - 50 WHERE product_id = 104;

UPDATE products SET stock_quantity = stock_quantity + 10 WHERE product_id = 101;

UPDATE products SET stock_quantity = stock_quantity + 100 WHERE product_id = 105;

UPDATE products SET stock_quantity = stock_quantity + 50 WHERE product_id = 106;

Tabel `employees` memiliki kolom `emp_id`, `emp_name`, `salary`, dan `department_id`. Anda ingin mencari karyawan dengan gaji tertinggi di setiap departemen. Perintah SQL yang tepat adalah:

SELECT emp_name FROM employees WHERE salary = (SELECT MAX(salary) FROM employees WHERE department_id = employees.department_id);

SELECT emp_name FROM employees WHERE salary = (SELECT MIN(salary) FROM employees WHERE department_id = employees.department_id);

SELECT emp_name FROM employees WHERE salary = (SELECT AVG(salary) FROM employees WHERE department_id = employees.department_id);

SELECT emp_name FROM employees WHERE salary = (SELECT MAX(salary) FROM employees);

UAS - Basis Data A (2025) Quiz

40 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Dalam model relasional, atribut yang menjadi kunci utama suatu tabel disebut...

Foreign Key

Primary Key

Candidate Key

Alternate Key

Composite Key

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Normalisasi bertujuan untuk...

Menghapus data duplikat

Mengurangi redundansi data

Mempercepat query

Menyederhanakan interface

Membuat tabel lebih besar

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Pernyataan yang tepat mengenai Third Normal Form (3NF) adalah...

Tidak boleh ada atribut yang tergantung transitif pada primary key

Semua atribut harus atomic

Tidak boleh ada partial dependency

Setiap tabel memiliki minimal satu foreign key

Hanya memiliki satu primary key

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Perintah SQL untuk menampilkan semua data dari tabel 'produk' adalah...

SELECT ALL FROM produk;

SELECT * FROM produk;

SHOW * FROM produk;

DISPLAY ALL produk;

SELECT produk;

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Manakah perintah SQL yang digunakan untuk mengubah struktur tabel?

ALTER TABLE

MODIFY TABLE

CHANGE TABLE

UPDATE TABLE

EDIT TABLE

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Apa hasil dari query: SELECT 10/2;

5

10

2

null

5.0

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Kunci yang digunakan untuk menghubungkan dua tabel disebut…

Foreign Key

Primary Key

Super Key

Candidate Key

Alternate Key

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

Apple

Others

Already have an account?

Similar Resources on Wayground

40 questions

BIOCHEMISTRY (CARBOHYDRATES)

Quiz

•

University

35 questions

Technerd 5.O

Quiz

•

University

40 questions

The HSMTMTS Trivia - August 2022

Quiz

•

KG - University

42 questions

LearnTube Data Structure and Algorithm Quiz 11/2/23

Quiz

•

University

40 questions

INSTRUMENT (BASIC) ชุดที่ 2

Quiz

•

University

40 questions

Bộ HC_TC số 4

Quiz

•

University

35 questions

Midterm Andragogy

Quiz

•

University

40 questions

Review For Exam 4

Quiz

•

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

$fractions$

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 Other

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

UAS - Basis Data A (2025)

Dalam model relasional, atribut yang menjadi kunci utama suatu tabel disebut...

Normalisasi bertujuan untuk...

Pernyataan yang tepat mengenai Third Normal Form (3NF) adalah...

Perintah SQL untuk menampilkan semua data dari tabel 'produk' adalah...

Manakah perintah SQL yang digunakan untuk mengubah struktur tabel?

Apa hasil dari query: SELECT 10/2;

Kunci yang digunakan untuk menghubungkan dua tabel disebut…

Apa fungsi dari klausa WHERE dalam SQL?

Dalam SQL, fungsi COUNT() digunakan untuk...

Tipe data untuk menyimpan angka desimal dengan presisi tinggi adalah...

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Other