Sistem Basis Data
Quiz Sistem Basis Data untuk semester 3 Regulwe Pagi
- 1.
Tamplikanlah seluruh field yang berada didalam tabel barang
- A.
Select barang;
- B.
Select * from barang;
- C.
select * barang;
- D.
select * barang
Correct Answer
B. Select * from barang; -
- 2.
Cara menghapus tabel barang
- A.
drop table * barang;
- B.
Drop table barang
- C.
Drop table barang;
- D.
Drop table_barang;
Correct Answer
A. drop table * barang; -
- 3.
Buat lah user baru pada table karyawan dengan user = oji dan password = fauzi
- A.
SQL create user oji identified by fauzi;
- B.
SQL> create user oji by fauzi;
- C.
SQL> create user oji identified by fauzi;
- D.
SQL> create user sofyan identified by sosa
Correct Answer
C. SQL> create user oji identified by fauzi; -
- 4.
Tampilkan last name dengan huruf capital dimana last name nya di awali dengan huruf ‘A’
- A.
SQL> select upper(last_name),salary from employees where last_name 'A%';
- B.
SQL> select upper(last_name),salary from employees where last_name like 'A%';
- C.
SQL> select upper(last_name),salary from employees where last_name like 'A';
- D.
SQL> select upper(last_name),salary from employees where last_name like 'A%;
Correct Answer
B. SQL> select upper(last_name),salary from employees where last_name like 'A%'; -
- 5.
Buatlah kolom NIP pada table karyawan sebagai index
- A.
SQL> create index karyawan nip idx on karyawan(nip);
- B.
SQL> create index karyawan_nip_idx on karyawan(nip)
- C.
SQL> create index karyawan_nip_idx on karyawan(nip);
- D.
SQL> create index karyawan_nip_idx karyawan(nip);
Correct Answer
C. SQL> create index karyawan_nip_idx on karyawan(nip); -
- 6.
Hapus hak akses delete dari user fauzi
- A.
Revoke delete on karyawan from fauzi;
- B.
Revoke delete on karyawan fauzi;
- C.
Revoke delete karyawan from fauzi;
- D.
Revoke delete on karyawan from fauzi
Correct Answer
A. Revoke delete on karyawan from fauzi; -
- 7.
Buatlah kolom NIP sebagai primary key pada table karyawan
- A.
SQL> alter table karyawan add constraint pk_nip primary key nip;
- B.
SQL> alter table karyawan add constraint pk_nip primary key (nip)
- C.
SQL> alter table karyawan add constraint pk_nip primary key (nip);
- D.
SQL> alter table karyawan add constraint pk nip primary key (nip);
Correct Answer
C. SQL> alter table karyawan add constraint pk_nip primary key (nip); -
- 8.
Buat lah barang dengan field kode_barang char(6),nama barang varchar2(25),satuan_barang varchar2(20) dan stok_barang number(4) primary key adalah kode barang :
- A.
Create table barang( kode_barang char(6), nama_barang varchar2(25), satuan_barang varchar2(20), stock_barang number(4), constraint pk_barang primary key(kode_barang) );
- B.
Create table barang( kode_barang char(6) nama_barang varchar2(25) satuan_barang varchar2(20) stock_barang number(4) constraint pk_barang primary key(kode_barang) );
- C.
Create table barang( kode_barang char(6), nama_barang varchar2(25), constraint pk_barang primary key(kode_barang) );
- D.
Create table barang( kode_barang char(6), nama_barang varchar2(25), satuan_barang varchar2(20), stock_barang number(4), constraint pk_barang primary key(kode_barang)
Correct Answer
A. Create table barang( kode_barang char(6), nama_barang varchar2(25), satuan_barang varchar2(20), stock_barang number(4), constraint pk_barang primary key(kode_barang) ); -
- 9.
Buatlah kolom email pada table pegawai sebagai kolom unique
- A.
SQL> alter table karyawan add constraint uq_email unique (email);
- B.
SQL> alter table karyawan add constraint uq_email unique (email)
- C.
SQL> alter table karyawan on constraint uq_email unique (email);
- D.
SQL> alter table karyawan on constraint uq_email unique (email);
Correct Answer
A. SQL> alter table karyawan add constraint uq_email unique (email); -
- 10.
Isikan lah sebuah recordke dalam tabel barang seperti tampilan berikut :KODE_BARANG NAMA_BARANG SATUAN_BARANG STOK_BARANGKPR-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);
Correct Answer
A. insert into barang values('KPR-01','KULKAS','BUAH','20'); -
- 11.
Perangkat Lunak (Software) yang digunakan untuk mengelola kumpulan atau koleksi data, dimana data tersebut diorganisasikan atau disusun ke dalam suatu model data disebut…
- A.
Field
- B.
Record
- C.
DBMS
- D.
Tabel
Correct Answer
C. DBMS -
- 12.
Microsoft Access,Database Oracle adalah salah satu program aplikasi DBMS apa singkatan dari DBMS tersebut…
- A.
Database Multiple System
- B.
Database Management System
- C.
Data Management System
- D.
Database Management Supply
Correct Answer
B. Database Management System -
- 13.
Data yang terletak didalam satu kolom disebut…
- A.
Field
- B.
Record
- C.
DBMS
- D.
Tabel
Correct Answer
B. Record -
- 14.
Data yang terletak di dalam satu baris dan mewakili satu objek disebut….
- A.
Field
- B.
Record
- C.
DBMS
- D.
Tabel
Correct Answer
D. Tabel -
- 15.
Data yang menggambarkan kumpulan karakteristik suatu entitas….
- A.
Field
- B.
Record
- C.
DBMS
- D.
Database
Correct Answer
B. Record -
- 16.
Perintah yang digunakan untuk memanipulasi data adalah…
- A.
Report
- B.
Query
- C.
Form
- D.
Tabel
Correct Answer
B. Query -
- 17.
Manakah dibawah ini yang bukan termasuk kedalam software pengolah data base….
- A.
Ms- Access
- B.
Ms- Word
- C.
My SQL
- D.
SQL Server
Correct Answer
B. Ms- Word -
- 18.
Tipe data apakah yang panjang maksimalnya 255 karakter dapat menerima huruf, angka, spasi, dan tanda baca….
- A.
Text
- B.
Memo
- C.
Number
- D.
Currency
Correct Answer
C. Number -
- 19.
Currency digunakan untuk tipe data…
- A.
Huruf, angka spasi dan tandabaca
- B.
Berisi gambar
- C.
Untuk alamat hyperlink
- D.
Angka dalam format mata uang
Correct Answer
D. Angka dalam format mata uang -
- 20.
Karakteristik dari suatu Entity yang menyediakan penjelasan detail tentang entity disebut
- A.
Data Field
- B.
Data Record
- C.
Attribut
- D.
Entity
Correct Answer
C. Attribut -
- 21.
Ciri dari Primary Key adalah ....
- A.
Bersifat unik
- B.
Bersifat umum
- C.
Memiliki kesamaan data dengan
- D.
Mudah dihapal
Correct Answer
A. Bersifat unik -
- 22.
Sql dipublikasikan oleh :
- A.
E.F Codd
- B.
D. Chamberlin
- C.
R.F Boyce
- D.
Euler
Correct Answer
C. R.F Boyce -
- 23.
Berikut ini adalah sasaran dari SQL, kecuali :
- A.
Menciptakan basis data dan struktur relasi
- B.
Harus portable
- C.
Membuat pemrograman terstruktur dengan grafis
- D.
Mengelompokan data yang komplek
Correct Answer
B. Harus portable -
- 24.
Salah satu contoh data manipulation language
- A.
ALTER
- B.
TABLE
- C.
CHAT
- D.
SELECT
Correct Answer
D. SELECT -
- 25.
Pengembangan MySQL dengan tool database UNIREG dibuat oleh…
- A.
E.F Codd
- B.
Michael Widenius
- C.
R.F Boyce
- D.
David
Correct Answer
A. E.F Codd -
- 26.
Isikan lah sebuah recordke dalam tabel barang seperti tampilan berikut :KODE_BARANG NAMA_BARANG SATUAN_BARANG STOK_BARANGKPR-1 KULKAS BUAH 20
- A.
SQL> insert into barang values('KPR-01','KULKAS','BUAH','20');
- B.
SQL> insert from barang values('KPR-01','KULKAS','BUAH','20');
- C.
SQL> insert into barang from values('KPR-01','KULKAS','BUAH','20')
- D.
SQL> insert into barang values('KPR-01','KULKAS','BUAH','20');
Correct Answer
A. SQL> insert into barang values('KPR-01','KULKAS','BUAH','20'); -
- 27.
Tambahkan sebuah record lagi sehingga hasil sebagai berikut KODE_BARANG NAMA_BARANG SATUAN_BARANG STOK_BARANGKPR-01 KULKAS BUAH 20KPR-02 TELEVISI BUAH 15
- A.
SQL> Insert to barang values(‘KPR-02’,’TELEVISI’,’BUAH’,’15’);
- B.
SQL> Insert in barang values(‘KPR-02’,’TELEVISI’,’BUAH’,’15’);
- C.
SQL> Insert into barang values(‘KPR-02’,’TELEVISI’,’BUAH’,’15’);
- D.
SQL> Insert into barang from values(‘KPR-02’,’TELEVISI’,’BUAH’,’15’);
Correct Answer
C. SQL> Insert into barang values(‘KPR-02’,’TELEVISI’,’BUAH’,’15’); -
- 28.
Tamplikanlah seluruh field yang berada didalam tabel barang
- A.
SQL> select * from barang;
- B.
SQL> select * from table barang;
- C.
SQL> select * from new barang;
- D.
SQL> select * from new barang;
Correct Answer
A. SQL> select * from barang; -
- 29.
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.
Update barang set nama_barang='MONITOR' where nama_barang='TELEVISI';
- D.
SQL> update table barang set nama_barang='MONITOR' where nama_barang='TELEVISI';
Correct Answer
C. Update barang set nama_barang='MONITOR' where nama_barang='TELEVISI'; -
- 30.
Tampilkan lah seluruh field yang berada di tabel barang
- A.
SQL> select * from table barang
- B.
SQL> select * from barang
- C.
SQL> select * on barang
- D.
SQL> select * to barang
Correct Answer
B. SQL> select * from barang -
- 31.
Tampilkan kode barang,nama barang dari tabel barang yang jumalh stok nya 20
- A.
SQL> SELECT ON KODE_BARANG,NAMA_BARANG FROM BARANG WHERE STOCK_BARANG=20;
- B.
SQL> SELECT KODE_BARANG,NAMA_BARANG FROM BARANG WHERE STOCK_BARANG=20;
- C.
SQL> SELECT TO KODE_BARANG,NAMA_BARANG FROM BARANG WHERE STOCK_BARANG=20;
- D.
SQL> SELECT FROM KODE_BARANG,NAMA_BARANG FROM BARANG WHERE STOCK_BARANG=20;
Correct Answer
B. SQL> SELECT KODE_BARANG,NAMA_BARANG FROM BARANG WHERE STOCK_BARANG=20; -
- 32.
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';
Correct Answer
D. SQL> select nama_barang,satuan_barang,stock_barang from barang Where kode_barang like 'kpr-02'; -
- 33.
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';
Correct Answer
A. SQL> delete from barang where NAMA_BARANG='MONITOR'; -
- 34.
Hapus Tabel Barang
- A.
Option 1
- B.
Option 2
- C.
Option 3
- D.
Option 4
Correct Answer
A. Option 1 -
- 35.
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;
Correct Answer
C. SQL> select last_name,salary from employees where salary>12000; -
- 36.
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;
Correct Answer
D. SQL> select employee_id,last_name,salary,salary*0.1 as "Gaji Baru" from employees; -
- 37.
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';
Correct Answer
A. SQL> select last_name,hire_date from employees where hire_date like '%93'; -
- 38.
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';
Correct Answer
B. SQL> select last_name,job_id from employees where hire_date between '28-09-1988' and '06-02-2000'; -
- 39.
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';
Correct Answer
D. SQL> select count(last_name) from employees where hire_date between '20-09-1988' and '06-02-2000'; -
- 40.
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;
Correct Answer
A. SQL> select avg(salary) as "RATA - RATA GAJI " from employees; -
- 41.
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;
Correct Answer
A. SQL> select last_name,to_char(hire_date,'dd month yyyy') as "HIRE DATE" from employees where department_id>100; -
- 42.
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 '&_%';
Correct Answer
A. Select last_name,salary,length(last_name) as "JML KARAKTER" from employees where last_name like '&_%'; -
- 43.
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%';
Correct Answer
B. SQL> select last_name,salary,salary*0.2 as "BONUS NAMA" from employees where last_name like 'H%'; -
- 44.
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;
Correct Answer
D. SQL > select last_name,salary from employees where salary>&salary order by last_name; -
- 45.
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%';
Correct Answer
C. SQL>select lower(last_name),salary from employees where last_name like 'A%'; -
- 46.
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%';
Correct Answer
B. SQL> select upper(last_name),salary from employees where last_name like 'A%'; -
- 47.
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%';
Correct Answer
A. SQL> select initcap(last_name),salary from employees where last_name like 'H%'; -
- 48.
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;
Correct Answer
B. Select max(salary) as "GAJI TERTINGGI",min(salary) as "GAJI TERENDAH" from employees; -
- 49.
Program desktop yang sering dipakai untuk membuat program koneksi database adalah...
- A.
Visual studio
- B.
MySQL Workbanch
- C.
Visual basic
- D.
Autocad
Correct Answer
B. MySQL Workbanch -
- 50.
Di dalam suatu basis data, seorang pemrogram aplikasi cukup hanya mengetahui :
- A.
Skema basis data.
- B.
Model data.
- C.
Subskema basis data.
- D.
Seluruh relasi yg ada.
Correct Answer
D. Seluruh relasi yg ada. -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Dec 10, 2017Quiz Edited by
ProProfs Editorial Team -
Dec 07, 2017Quiz Created by
Johanooy
Back to top