SQL: Fungsi Agregat
Authored by NASHIMAH Moe
Computers
5th Grade
Used 14+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Simbol yang manakah mengembalikan semua data yang terdapat dalam jadual?
%
#
*
/
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SQL ialah
Structured Question Language
Simple Question Language
Structured Query Language
Simple Query Language
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perkataan manakah yang tertinggal dalam sintaks arahan SQL ini?
SELECT SUM (nama_medan) nama_jadual;
With
From
Where
And
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Susunan manakah yang betul?
Select, From, Order By, Where
Select, From, Where, Order by
Select, Where, From, Order by
Where, From, Select, Order by
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Arahan SQL manakah yang digunakan untuk mengembalikan nilai terendah daripada medan tertentu dalam jadual?
SELECT SUM (nama_medan)
FROM nama_jadual;
SELECT COUNT (nama_medan)
FROM nama_jadual;
SELECT MAX (nama_medan)
FROM nama_jadual;
SELECT MIN (nama_medan)
FROM nama_jadual;
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Arahan SQL manakah mengembalikan nilai medan tertentu?
SELECT SUM (nama_medan)
FROM nama_jadual;
SELECT COUNT (nama_medan)
FROM nama_jadual;
SELECT AVG (nama_medan)
FROM nama_jadual;
SELECT MAX (nama_medan)
FROM nama_jadual;
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Arahan SQL manakah mengembalikan jumlah bilangan rekod?
SELECT SUM (nama_medan)
FROM nama_jadual;
SELECT COUNT (nama_medan)
FROM nama_jadual;
SELECT AVG (nama_medan)
FROM nama_jadual;
SELECT MAX (nama_medan)
FROM nama_jadual;
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?
