Contoh Soal pilihan ganda oracle beserta jawaban, jawabannya yang di bold
1.Tampilkan
nama barang,satuan barang dan stok barang dari tabel barang, dimana kode barang
adalah KPR-02
A. SQL> select on
nama_barang,satuan_barang,stock_barang from barang
Where kode_barang like 'kpr-02';
B. SQL> select from
nama_barang,satuan_barang,stock_barang from barang
Where kode_barang like 'kpr-02';
C. SQL> select table
nama_barang,satuan_barang,stock_barang from barang
Where kode_barang like 'kpr-02';
D. SQL>
select nama_barang,satuan_barang,stock_barang from barang
Where kode_barang like 'kpr-02';
2. 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';
3.Hapus
Tabel Barang
A. SQL> drop from table barang;
B. SQL> drop to table barang;
C. SQL> drop
table barang;
D. SQL> drop on table barang;
4. Tampilkan last name,salary
dari tabel employees yang salary nya lebih besar dari 12000
A. SQL> select last_name,salary to employees where salary>12000;
B. SQL> select last_name,salary on employees where
salary>12000;
C. SQL>
select last_name,salary from employees where salary>12000;
D. SQL> select last_name,salary employees where
salary>12000;
5.Tampilkan employee id,last name
dan salary untuk karyawan yang mempunyai employee id lebih dari 100 dan salary
nya ditambah 3000 dan urut kan berdasarkan salary nya
A. SQL>
select employee_id,last_name,salary+3000 from employees where employee_id>100;
B. SQL> select on employee_id,last_name,salary+3000
from employees where employee_id>100;
C. SQL> select from
employee_id,last_name,salary+3000 from employees where employee_id>100;
D. SQL> select table
employee_id,last_name,salary+3000 from employees where employee_id>100;
6. 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;
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;
7. Tampilkan last name dan hire
date khusus untuk pegawai yang hire date nya 1993
A. SQL> select
last_name,hire_date from employees where hire_date like '%93';
B. SQL> select on last_name,hire_date from
employees where hire_date like '%93';
C. SQL> select from last_name,hire_date from
employees where hire_date like '%93';
D. SQL> select table last_name,hire_date from
employees where hire_date like '%93';
8. Tampilkan
last name,job id karyawan yang hire date nya antara 20-09-1988 s/d 06-02-2000
A. SQL> select table from last_name,job_id from employees where hire_date
between '28-09-1988' and '06-02-2000';
B. SQL>
select last_name,job_id from employees where hire_date between '28-09-1988' and
'06-02-2000';
C. SQL> select last_name,job_id from table
employees where hire_date between '28-09-1988' and '06-02-2000';
D. SQL> select last_name,job_id to employees where hire_date between
'28-09-1988' and '06-02-2000';
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';
10. Tampilkan
rata –rata gaji dari semua karyawan dengan kolom alias “RATA – RATA GAJI”
A. SQL>
select avg(salary) as "RATA - RATA GAJI " from employees;
B. SQL> select table avg(salary) as "RATA -
RATA GAJI " from employees;
C. SQL> select on avg(salary) as "RATA - RATA
GAJI " from employees;
D. SQL> select from table avg(salary) as "RATA
- RATA GAJI " from employees;
11. Tampilkan
last name karyawan dan tanggal masuk nya dengan mengkonversikan kedalam bentuk
karakter. Khusus untuk karyawan yang department id nya lebih besar dari 100
A. SQL> select
last_name,to_char(hire_date,'dd month yyyy') as "HIRE DATE" from
employees where department_id>100;
B. SQL> select table
last_name,to_char(hire_date,'dd month yyyy') as "HIRE DATE" from
employees where department_id>100;
C. SQL> select from last_name,to_char(hire_date,'dd
month yyyy') as "HIRE DATE" from employees where
department_id>100;
D. SQL> select last_name,to_char(hire_date,'dd
month yyyy') as "HIRE DATE" where employees where
department_id>100;
12. 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 '&_%';
13. Tampilkan last
name,salary,salary di tambah 20% dengan kolom bonus nama untuk karyawan yang
namanya berawan huruf H
A. SQL> select table from
last_name,salary,salary*0.2 as "BONUS NAMA" from employees where
last_name like 'H%';
B. SQL>
select last_name,salary,salary*0.2 as "BONUS NAMA" from employees
where last_name like 'H%';
C. SQL> select table on last_name,salary,salary*0.2
as "BONUS NAMA" from employees where last_name like 'H%';
D. SQL> select on last_name,salary,salary*0.2 as
"BONUS NAMA" from employees where last_name like 'H%';
14.Tampilkan
last_name,salary untuk karyawan yang jumlah salary nya lebih besar dari data
yang di input kan oleh user dan urutkan berdasarkan last_name
A. SQL > select from table last_name,salary from
employees where salary>&salary order by last_name;
B. SQL > select on last_name,salary from employees
where salary>&salary order by last_name;
C. SQL > select from last_name,salary from
employees where salary>&salary order by last_name;
D. SQL >
select last_name,salary from employees where salary>&salary order by
last_name;
15. Tampilkan
last_name dengan huruf kecil ,salary dari tabel employees dimana last name nya
di awali dengan huruf ‘A’
A. SQL>select table from lower(last_name),salary from employees where
last_name like 'A%';
B. SQL>select from table lower(last_name),salary
from employees where last_name like 'A%';
C.
SQL>select lower(last_name),salary from employees where last_name like 'A%';
D. SQL>select from lower(last_name),salary from
employees where last_name like 'A%';
16. Tampilkan
last name dengan huruf capital dimana last name nya di awali dengan huruf ‘A’
A. SQL> select drop upper(last_name),salary from
employees where last_name like 'A%';
B. SQL>
select upper(last_name),salary from employees where last_name like 'A%';
C. SQL> select by upper(last_name),salary from
employees where last_name like 'A%';
D. SQL> select on upper(last_name),salary from
employees where last_name like 'A%';
17. Tampilkan
last name dengan awalan huruf capital dan selebihnya huruf kecil khusu untuk
karyawan yang last name nya diawali dengan huruf ‘H’
A. SQL>
select initcap(last_name),salary from employees where last_name like 'H%';
B. SQL> select by initcap(last_name),salary from
employees where last_name like 'H%';
C. SQL> select from table initcap(last_name),salary
from employees where last_name like 'H%';
D. SQL> select on initcap(last_name),salary from
employees where last_name like 'H%';
18. Tampilkan salary tertinggi
dengan kolom alias “GAJI TERTINGGI” dan untuk yang terendah dengan kolom alias
“GAJI TERENDAH”
A. Select value max(salary) as "GAJI
TERTINGGI",min(salary) as "GAJI TERENDAH" from employees;
B. select
max(salary) as "GAJI TERTINGGI",min(salary) as "GAJI TERENDAH"
from employees;
C. select to max(salary) as "GAJI
TERTINGGI",min(salary) as "GAJI TERENDAH" from employees;
D. select on max(salary) as "GAJI
TERTINGGI",min(salary) as "GAJI TERENDAH" from employees;
19. Program
desktop yang sering dipakai untuk membuat program koneksi database adalah...
a. Visual
studio
b. MySQL Workbanch
c. Visual
basic
d. Autocad
20. Di
dalam suatu basis data, seorang pemrogram aplikasi cukup hanya mengetahui :
a. Skema basis data. c. Subskema basis data.
b. Model data. d. Seluruh relasi yg ada.
21. Tool
yang digunakan untuk mengoneksikan database di dalam menu VB 6.0 adalah...
a. Adodc b. Datagrid c.
SQL
Conector d. Toolbox
22. Program
enterprise yang dibuat untuk mengaplikasikan basis data oracle adalah...
a. Ms.powerpoint b.
Corel
draw c.
Ms.Visual Basic d.
Ulead10.0
23. Dibawah
ini yang disebut program aplikasi database web server adalah....
a. Apache b.Winamp d. Localhost e.phpMyadmin
24. Bagaimanakah
cara menyimpan program dari Visual Basic....
a. Save b.
Save as + form c.
Save
all d.
Save as
25. Berapakah
jumlah ukuran memori pada tipe data currency ….
a. 1 b. 2 c. 4 d. 8
26. Berapakah
jumlah ukuran memori pada tipe data string…
a) 1
b) 3
c) 4
d) 8
27. Dibawah
ini langkah-langkah yang benar dalam penyimpanan semua project dalam Visual
Basic dengan 1 Form dalah …
a) As à SaveàFile
b) Form1 à SaveàFile
c) Form1àProjectàSaveàFile
d) Project
As à SaveàFile
28. Toolbox
yang dipakai untuk memasukan database adalah...
a) Adodc
b) Label
c) Commandbutton
d) Datagrid
29. Toolbox
yang dipakai untuk mendata atau isian database adalah....
a) Adodc
b) Label
c) Textbox
d) Datagrid
30.Di
dalam sebuah system basis data dalam lingkungan universitas, maka data mengenai
indeks prestasi mahasiswa merupakan :
a. Data operasional. c.
Data dictionary.
b. Data input. d.
Data output.
