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)

Authored by Abdul Rahim

Other

University

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

40 questions

Show all answers

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

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Normalisasi bertujuan untuk...

Menghapus data duplikat

Mengurangi redundansi data

Mempercepat query

Menyederhanakan interface

Membuat tabel lebih besar

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

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;

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

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Apa hasil dari query: SELECT 10/2;

null

5.0

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

Números 0 - 1,000,000

Quiz

•

University

35 questions

Big Data & E-Science Long Quiz

Quiz

•

University

40 questions

ENGINEERING MANAGEMENT

Quiz

•

University

40 questions

【再】iTero基本操作/システム概要（My iTero)

Quiz

•

KG - University

35 questions

Postest Sispro

Quiz

•

University

40 questions

CONCENTRACION SIMULACRO 4.2

Quiz

•

University

45 questions

Piano Basics

Quiz

•

KG - University

40 questions

Economics: Chapters 4 & 5 Review

Quiz

•

KG - University

Popular Resources on Wayground

20 questions

STAAR Review Quiz #3

Quiz

•

8th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

6 questions

Marshmallow Farm Quiz

Quiz

•

2nd - 5th Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

20 questions

Inferences

Quiz

•

4th Grade

19 questions

Classifying Quadrilaterals

Quiz

•

3rd Grade

12 questions

What makes Nebraska's government unique?

Quiz

•

4th - 5th Grade

Discover more resources for Other

20 questions

Disney Trivia

Quiz

•

University

10 questions

GMAS ELA Review

Quiz

•

KG - University

9 questions

Week 9 Recitation

Quiz

•

University

26 questions

Customary Measurement

Quiz

•

KG - University

20 questions

Easter trivia

Quiz

•

12th Grade - Professi...

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