NEW
Font size
S
M
L
XL
WorksheetsUH SQL Dasar Mengelola Tabel
Total questions: 10
Worksheet time: 19mins
Name
Class
Date
1.
Isikan lah sebuah record ke dalam tabel barang seperti tampilan berikut : KODE_BARANG NAMA_BARANG SATUAN_BARANG STOK_BARANG KPR-1 KULKAS BUAH 20
a)
insert into barang values('KPR-01','KULKAS','BUAH','20');
b)
insert into_barang values('KPR-01','KULKAS','BUAH','20');
c)
insert barang_values('KPR-01','KULKAS','BUAH','20');
d)
insert into barang values(KPR-01,KULKAS,BUAH,20);
e)
insert into barang values(KPR-01,KULKAS,BUAH,20)
2.
Salah satu contoh data manipulation language
a)
ALTER
b)
TABLE
c)
CHAT
d)
SELECT
e)
REPORT
3.
Ubah lah tabel barang pada kolom nama barang dari TELEVISI menjadi MONITOR
a)
SQL> update to barang set nama_barang='MONITOR' where nama_barang='TELEVISI';
b)
SQL> update from barang set nama_barang='MONITOR' where nama_barang='TELEVISI';
c)
SQL> update barang set nama_barang='MONITOR' where nama_barang='TELEVISI';
d)
SQL> update table barang set nama_barang='MONITOR' where nama_barang='TELEVISI';
e)
SQL>delete from barang set nama_barang='MONITOR' where nama_barang='TELEVISI';
4.
Hapuslah pada field MONITOR pada kolom nama_barang pada tabel barang
a)
SQL> delete from barang where NAMA_BARANG='MONITOR';
b)
SQL> delete from table barang where NAMA_BARANG='MONITOR';
c)
SQL>delete on barang where NAMA_BARANG='MONITOR';
d)
SQL>delete on table barang where NAMA_BARANG='MONITOR';
e)
SQL> delete from barang where NAMA_BARANG='MONITOR
5.
Cari kode_brg untuk semua barang yg berhasil dijual oleh lebih dari seorang salesman :
a)
Select kode_brg From Pengiriman Order By kode_brg Having Sum(*)>1
b)
Select kode_brg From Pengiriman Grup By kode_brg Having Sum(kode_sales)>1
c)
Select kode_brg From Pengiriman Order By kode_brg Having Count(*)>1
d)
Select kode_brg From Pengiriman Group By kode_brg Having Count(kode_sales)>1
e)
Select kode_brg From Pengiriman Group By kode_brg Having Count(kode_sales)>=1
6.
Cari nama salesman yg berlokasi di Jakarta dan status lebih besar dari 30
a)
Select Salesman From nama-sales Where kota=’Jakarta’ and status>30
b)
Select Salesman From nama-sales Where kota=’Jakarta’ or status>30
c)
Select nama_sales From Salesman Where kota=’Jakarta’ or status>30
d)
Select nama_sales From Salesman Where kota=’Jakarta’ and status>30
e)
Select Salesman From namasales Where kota=’Jakarta’ or status>30
7.
Ubah harga barang dengan kode P2 menjadi 1.5 kali dari harga lama :
a)
Update Barang Set harga=1.5*harga Where kode_brg=’P2’
b)
Replace Barang Set harga=1.5*harga Where kode_brg=’P2’
c)
Replace Barang Where kode_brg=’P2’ Set harga=1.5*harga
d)
Update Barang Where kode_brg=’P2’ Set harga=1.5*harga
e)
Insert Barang Where kode_brg=’P2’ Set harga=1.5*harga
8.
Tampilkan employee id,last name,salary dan salary di kalikan 10% dengan kolom alias “Gaji Baru”
SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" from table employees;
SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" from table employees;
a)
SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" to employees;
b)
SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" on employees;
c)
SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" from employees;
d)
SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" from employees;
e)
SQL> select employeeid,lastname,salary,salary*0.1 as "Gaji Baru" from employees;
9.
Hitung lah jumlah karyawan yang Tanggal masuk nya antara 20-09-1988 s/d 06-02-2000
a)
SQL> select to count(last_name) from employees where hire_date between '20-09-1988' and '06-02-2000';
b)
SQL> select to table count(last_name) from employees where hire_date between '20-09-1988' and '06-02-2000';
c)
SQL> select from count(last_name) from employees where hire_date between '20-09-1988' and '06-02-2000';
d)
SQL> select count(last_name) from employees where hire_date between '20-09-1988' and '06-02-2000';
e)
SQL> select count(last_name) from employees where hire_date between '20-09-1988' or '06-02-2000';
10.
Tampilkan last name,salary,dan panjang karakter dengan kolom alias “JML KARAKTER” berdasarkan huruf awal yang di input kan oleh user
a)
select last_name,salary,length(last_name) as "JML KARAKTER" from employees where last_name like '&_%';
b)
select table last_name,salary,length(last_name) as "JML KARAKTER" from employees where last_name like '&_%';
c)
select from last_name,salary,length(last_name) as "JML KARAKTER" from employees where last_name like '&_%';
d)
select on last_name,salary,length(last_name) as "JML KARAKTER" from employees where last_name like '&_%';
e)
select table last_name,length(last_name) as "JML KARAKTER" from employees where last_name like '&_%';
Reset
