WorksheetsSKT5 : Bab 2 : SQL
Total questions: 65
Worksheet time: 33mins
Perkaataan apa yang hilang dari garisan di bawah?
SELECT * _______ CUSTOMER;
FROM
WHERE
SELECT
ORDER BY
Apakah maksud * ?
Memilih SEMUA medan dari jadual
Hanya memilih medan pertama dalam jadual
Memilih medan terakhir dalam jadual
Hanya menunjukkan baris pertama dalam jadual
Untuk mencari jumlah nilai dolar jualan, gunakan mana?
SUM
COUNT
MAX
MIN
AVG, COUNT, MAX, MIN dan SUM dikenali sebagai apa?
Fungsi agregat
Penapis wildcard
Subqueries
Medan yang dikira
Apakah susunan klausa yang betul?
SELECT, FROM, ORDER BY, WHERE
SELECT, FROM, WHERE, ORDER BY
SELECT, WHERE, FROM, ORDER BY
WHERE, FROM, SELECT, ORDER BY
Klausa mana yang membolehkan anda menyusun data?
ORDER BY
WHERE
FROM
HAVING
Nama jadual SQL adalah sensitif huruf (case sensitive)
Benar
Palsu
Gunakan klausa yang mana untuk menyaring/ menapis data ?
WHERE
ORDER BY
FROM
HAVING
SELECT MAX(price)
FROM PRODUCT
akan memulangkan berapa banyak baris?
1
0
2
Seperti banyak baris yang terdapat dalam jadual
Kenyataan SQL mana yang digunakan untuk mengemas kini data dalam pangkalan data?
MODIFY
SAVE AS
UPDATE
SAVE
Kenyataan SQL mana yang digunakan untuk memasukkan data baru dalam pangkalan data?
ADD NEW
ADD RECORD
INSERT NEW
INSERT INTO
Dengan SQL, bagaimana anda memilih semua lajur dari jadual yang dinamakan "Persons"?
SELECT [all] FROM Persons
SELECT *.Persons
SELECT * FROM Persons
SELECT Persons
Mana antara kod berikut yang manakah ditulis dengan betul?
SELECT * FROM movies WHERE imdb_rating is 1 AND ORDER by desc;
SELECT * FROM movies WHERE genre = ‘comedy’ AND ORDER BY ASC LIMIT 1:
SELECT * FROM movies WHERE genre = ‘horror’;
SELECT * FROM movies genre is horror, and rating is 2;
Apakah yang dimaksudkan oleh SQL?
Structured Query Language
Structured Question Language
Strong Question Language
Strong Query Language
Kenyataan SQL mana yang digunakan untuk mengeluarkan data dari pangkalan data?
OPEN
GET
EXTRACT
SELECT
Arahan SQL diatas adalah untuk
Mencipta jadual
Mengubah Struktur Jadual
Sisip/Tambah Medan
Pinda/Ubah Medan
Hapus Medan
Arahan SQL diatas adalah untuk
Mencipta jadual
Mengubah Struktur Jadual
Sisip/Tambah Medan
Pinda/Ubah Medan
Hapus Medan
Arahan SQL diatas adalah untuk
Mencipta jadual
Mengubah Struktur Jadual
Sisip/Tambah Medan
Pinda/Ubah Medan
Hapus Medan
Arahan SQL diatas adalah untuk
Mencipta jadual
Mengubah Struktur Jadual
Sisip/Tambah Medan
Pinda/Ubah Medan
Hapus Medan
Arahan SQL diatas adalah untuk
Sisip/tambah data
memadam data
mengemaskini data
membuat data sandaran
Arahan SQL diatas adalah untuk
Sisip/tambah data
memadam data
mengemaskini data
membuat data sandaran
Arahan SQL diatas adalah untuk
Sisip/tambah data
memadam data
mengemaskini data
membuat data sandaran
Arahan SQL diatas adalah untuk
Sisip/tambah data
memadam data
mengemaskini data
Papar data
Arahan SQL diatas adalah untuk
Sisip/tambah data
memadam data
Isih data
Papar data
Arahan SQL diatas adalah untuk
Sisip/tambah data
Susun data
Isih data
Papar data
Arahan SQL diatas adalah untuk
Kira Bilangan
Kira jumlah
Kira purata
Kira Beza
Arahan SQL diatas adalah untuk
Kira Bilangan
Kira jumlah
Kira purata
Kira Beza
Arahan SQL diatas adalah untuk
Kira Bilangan
Kira jumlah
Kira purata
Kira jumlah minima
Arahan SQL diatas adalah untuk
Kira Bilangan
Kira jumlah
Kira purata
Kira jumlah minima
Arahan SQL diatas adalah untuk
Kira Bilangan
Kira jumlah
Kira jumlah maksima
Kira jumlah minima
What does "SQL" stand for?
Structured Question Language
Structured Query Language
Simple Query Language
Simple Question Language
Which statement is used to extract data from a database?
Extract
Get
Open
Select
To remove a record from a table which SQL statement would you use?
Remove
Cancel
Delete
Eradicate
Which statement allows us to add a record to a table?
Add To
Update To
Add Into
Insert Into
Less than or equal to?
>=
=>
=<
<=
Which character returns all the data found in a table?
%
#
*
/
Which word is missing from the following SQL statement?
Select * table_name
With
Where
From
And
How do we select all rows for the "Designer" table?
SELECT * FROM Designer
SELECT [All] FROM Designer
SELECT Designer.*
SELECT FROM Designer
How would we script a SQL query to select "Description" from the Item table?
SELECT Item.Description
EXTRACT Description FROM Item
SELECT Item FROM Description
SELECT Description FROM Item
You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?
UPDATE Designer SET PhoneNo = '01224123456'
UPDATE Designer (PhoneNo) VALUES ('01224123456')
UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'
UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'
With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?
SELECT * FROM Items ORDER BY Price ASCENDING
SELECT * FROM Items ORDER BY Price ASC
SELECT * FROM Items BY Price LOWEST TO HIGHEST
SELECT * FROM Items ORDER BY Price DESC
How would you DELETE records from the Items table with a "Chair" Type?
DELETE 'Chair' FROM Items
DELETE Type FROM Items WHERE Type = 'Chair'
DELETE FROM Items WHERE Type = 'Chair'
DELETE ITEMS WHERE Type = 'Chair'
If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default
ASC
DESC
There is no default value
None of the mentioned
With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?
SELECT * FROM Persons WHERE FirstName=’a’
SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
SELECT * FROM Persons WHERE FirstName=’%a%’
With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?
SELECT * FROM Persons WHERE FirstName=’a’
SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
SELECT * FROM Persons WHERE FirstName=’%a%’
What does the ALTER TABLE clause do?
The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints
The SQL ALTER TABLE clause is used to insert data into database table
THE SQL ALTER TABLE deletes data from database table
The SQL ALTER TABLE clause is used to delete a database table
The UPDATE SQL clause can _____________
update only one row at a time
update more than one row at a time
delete more than one row at a time
delete only one row at a time
How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.
SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)
SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)
SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)
SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);
In what order does SQL process the instructions?
FROM - SELECT - WHERE - ORDER BY
WHERE - FROM - SELECT - ORDER BY
SELECT - FROM - WHERE - ORDER BY
SELECT - FROM - ORDER By - WHERE
A primary key can be NULL in the table? TRUE or FALSE
TRUE
FALSE
Which option is not the command of DML ?
insert
update
alter
delete
drop, truncate, create are the commands of DDL?
True
False
_____ is used to filter out the data by applying condition on grouped data.
where
from
having
order by
from the following option select the wrong one.
AND
OR
NOT
greater than equal to
Berikut adalah jadual BARANG dalam pangkalan data Syarikat HRZ Sdn. Bhd. Salin semula pernyataan SQL berikut ke dalam ruangan jawapan dan isi tempat kosong dengan jawapan yang sesuai
DELETE FROM …………X……………….
WHERE ………Y………..= ‘ BOLA HOKI’
X = BARANG
Y = NoBarang
Y= NamaBarang
X = Syarikat HRZ Sdn. Bhd.
Apakah kegunaan fungsi COUNT?
Mengira bilangan medan dalam jadual
Menghitung bilangan lajur dalam jadual.
Menghitung jumlah rekod tertentu daripada jadual.
Mengira jumlah atribut dalam sesuatu jadual.
Jadual 4 menunjukkan pangkalan data di sebuah stor sukan sekolah
Berdasarkan Jadual 4, tulis pernyataan SQL untuk mendapatkan jumlah produk yang dibekalkan oleh Jaya Enterprise
SELECT SUM(Kuantiti )
FROM PRODUK
WHERE Pembekal= ’Jaya Enterprise’;
SELECT*
FROM PRODUK
ORDER BY Item DESC
SELECT SUM(Harga )
FROM PRODUK
WHERE Pembekal= ’Jaya Enterprise’;
Jadual 4 menunjukkan pangkalan data di sebuah stor sukan sekolah.
Berdasarkan Jadual 4, tulis pernyataan SQL untuk
(a) menyenaraikan semua medan daripada jadual PRODUK mengikut urutan menurun dengan berpandukan item barang.
SELECT*
FROM PRODUK
ORDER BY Item DESC
SELECT SUM(Kuantiti )
FROM PRODUK
WHERE Pembekal= ’Jaya Enterprise’;
SELECT*
FROM PRODUK
ORDER BY Item ASC
What does the SQL GROUP BY clause do?
Sorts the result set in ascending order
Combines rows with the same values into summary rows
Filters rows based on a specified condition
Joins two or more tables
Arahan SQL, CREATE, ALTER dan DROP merupakan arahan dalam bahasa ______
Data Definition Language atau Bahasa Takrifan Data (DDL)
Data Manipulation Language atau Bahasa Pengolahan Data (DML)
Data Control Language atau Bahasa Kawalan Data (DCL)
Arahan SQL, SELECT, INSERT, UPDATE dan DELETE merupakan arahan dalam bahasa ______
Data Definition Language atau Bahasa Takrifan Data (DDL)
Data Manipulation Language atau Bahasa Pengolahan Data (DML)
Data Control Language atau Bahasa Kawalan Data (DCL)
Berikut menunjukkan pernyataan SQL untuk mengemaskini stok barangan. Jika stok kurang daripada 20 unit, sebanyak lima unit barang akan ditambah.
1. ____A_____ BARANG
2. ____B_____ Kuantiti = Kuantiti + 5
3. ____C_____ Kuantiti < 20
A. SELECT
B. FROM
C. WHERE
A. ALTER TABLE
B. ADD
C. WHERE
A. UPDATE
B. SET
C. WHERE
A. UPDATE
B. FROM
C. WHERE
What is the purpose of SQL?
To retrieve, delete, and manipulate data in relational databases
To express the logic of how something needs to be achieved
To define and control data access
To create and modify tables in a database
In an SQL query, which built-in function is used to total numeric columns?
AVG
COUNT
MAX
SUM
