2.1.3 ARAHAN SQL
Authored by NOR Moe
Computers
1st - 12th Grade
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Namakan arahan SQL untuk
mencipta jadual
CREATE TABLE
ALTER TABLE,ADD
ALTER TABLE,MODIFY
ALTER TABLE,DROP
ALTER TABLE,CHANGE
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Namakan arahan SQL untuk
Mengubah Struktur Jadual
CREATE TABLE
ALTER TABLE
ALTER TABLE,MODIFY
ALTER TABLE,DROP
ALTER TABLE,CHANGE
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Namakan arahan SQL untuk
Sisip/Tambah Medan
CREATE TABLE
ALTER TABLE
ALTER TABLE,ADD
ALTER TABLE,DROP
ALTER TABLE,CHANGE
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Namakan arahan SQL untuk
Pinda/Ubah Medan
CREATE TABLE
ALTER TABLE
ALTER TABLE,ADD
ALTER TABLE,DROP
ALTER TABLE,CHANGE
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Namakan arahan SQL untuk
Hapus Medan
CREATE TABLE
ALTER TABLE
ALTER TABLE,ADD
ALTER TABLE,DROP
ALTER TABLE,CHANGE
6.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
Betulkan kesalahan penyataan SQL berikut:
CREATE TABLE BARANG (
NoBarang VARCHAR (6) PRIMARY KEY,
Nama VARCHAR ( ) NOT NULL,
Kuantiti INT (3)
)
(a)
7.
FILL IN THE BLANKS QUESTION
1 min • 1 pt
Format:
ALTER TABLE nama_jadual
ADD nama_medan jenis data (saiz);
Tuliskan pernyataan SQL untuk menambah medan alamat dengan jenis data varchar bersaiz 15 ke dalam jadual barang
(a)
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 Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
