Kelompok1 - Basis Data XII RPL
Authored by anmlijr Wulan
Computers
12th Grade
Used 4+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
23 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Pernyataan yang tidak benar tentang fungsi agregasi adalah....
Dapat digunakan bersama statement WHERE
Selalu ditempatkan setelah statement WHERE
Dapat digunakan bersama statement HAVING
Dapat digunakan pada kelompok data
Memberikan hasil perhitungan tepat satu baris dan satu kolom
2.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Persamaan WHERE dan HAVING adalah
digunakan untuk menentukan persyaratan
sama-sama tidak dapat digunakan bersama dengan statement MAX
sama-sama tidak dapat digunakan bersama dengan statement ROUND
sama-sama tidak dapat digunakan bersama dengan statement DISTINCT
sama-sama tidak dapat digunakan bersamaan dengan statement GROUP BY
3.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Pernyataan berikut yang benar, yaitu...
GROUP BY ditempatkan setelah statement WHERE
GROUP BY tidak dapat digunakan bersama fungsi MIN dan HAVING
GROUP BY tidak dapat digunakan bersama fungsi MAX dan HAVING
GROUP BY tidak dapat digunakan bersama fungsi AVG dan HAVING
GROUP BY tidak dapat digunakan bersama fungsi COUNT dan WHERE
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Berdasarkan tabel tersebut, syntax untuk menampilkan jumlah gaji yang harus dibayar untuk pegawai pada Departemen 102 adalah
SELECT IdDep, SUM(Gaji) FROM Pegawai
SELECT IdDep, SUM(Gaji) FROM Pegawai WHERE IdDep = 102
SELECT SUM (Gaji) FROM Pegawai WHERE IdDep 102
SELECT IdDep, SUM(Gaji) FROM Pegawai WHERE IdDepartemen 102 GROUP BY IdDep
SELECT IdDep, SUM(Gaji) FROM Pegawai WHERE IdDepartemen 102 GROUP BY IdDep HAVING Gaji > 2450
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Berdasarkan tabel tersebut, syntax untuk menampilkan rata-rata gaji untuk masing- masing departemen adalah....
SELECT AVG(Gaji) FROM Pegawai
SELECT IdDep, AVG (Gaji) FROM Pegawai
SELECT IdDep, AVERAGE (Gaji) FROM Pegawai
SELECT IdDep, AVG (Gaji) FROM Pegawai GROUP BY IdDep
SELECT IdDep, AVG (Gaji) FROM Pegawai WHERE IdDepartemen 102 GROUP BY IdDep
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Berdasarkan tabel tersebut, syntax untuk menghitung jumlah departemen adalah....
SELECT COUNT(ID) FROM Pegawai
SELECT COUNT(IdDep) FROM Departemen
SELECT COUNT (Nama) FROM Pegawai
SELECT DISTINCT COUNT (IdDep) FROM Pegawai
SELECT COUNT (DISTINCT (IdDep)) FROM Pegawai
7.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Di antara syntax berikut, syntax yang tidak akan bekerja adalah....
SELECT AVG (Gaji) FROM Pegawai
SELECT MAX(Gaji) FROM Pegawai
SELECT IdDep, AVG (Gaji) FROM Pegawai
SELECT IdDep, SUM(Gaji) FROM Pegawai GROUP BY IdDep
SELECT IdDep, AVG(Gaji) FROM Pegawai GROUP BY IdDep HAVING AVG (Gaji) > 2000
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
ip address
Quiz
•
1st Grade - University
20 questions
UH1 Pengenalan Web Kelas XII
Quiz
•
12th Grade
20 questions
TIK KLS 9
Quiz
•
12th Grade
20 questions
CLASS XI - MYSQL QUIZ
Quiz
•
11th - 12th Grade
20 questions
LATIHAN
Quiz
•
12th Grade
20 questions
Routing
Quiz
•
12th Grade
20 questions
ULANGAN TIK KELAS 8
Quiz
•
12th Grade
20 questions
Cybersecurity
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
