ULANGAN BASIS DATA SUBQUERY & BAB II XII RPL
Authored by Puspita Anjali
Education
1st Grade
Used 5+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
SELECT name, title FROM employee WHERE dept_id = ( SELECT dept_id FROM employee WHERE name = 'Biri' );
berikut merupakan subquery ...
SELECT name, title FROM employee WHERE dept_id = ( SELECT dept_id FROM employee WHERE name = 'Biri' );
SELECT name, title FROM employee WHERE dept_id
SELECT dept_id FROM employee WHERE name = 'Biri'
2.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Berikut merupakan operator pembanding yang biasanya digunakan pada single row subquery, kecuali ...
>
>=
=
>any
3.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
Berikut merupakan operator yang biasanya digunakan pada multiple row subquery ...
>
all
>exist
>=
4.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
syntax yang tepat untuk menampilkan stok pada tabel tb_buku yang tidak paling sedikit ...
select stok from tb_buku where stok > any (select stok from tb_buku);
select stok from tb_buku where stok < any (select stok from tb_buku);
select stok from tb_buku where stok > (select stok from tb_buku);
select stok where stok > any (select stok from tb_buku);
5.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
select salary FROM employee where salary < (select salary from employee where dept_id = '01');
Jika subquery menghasilkan lebih dari satu baris data, maka syntax perlu diperbaiki menjadi ...
select salary FROM employee where salary <all (select salary from employee where dept_id = '01');
select salary FROM employee where salary > (select salary from employee where dept_id = '01');
select salary FROM employee where salary <exist (select salary from employee where dept_id = '01');
6.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
sistem yang meminta layanan/data kepada server disebut ...
client
server
workstation
komputer
7.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
perintah yang digunakan untuk membuat user baru dalam MYSQL ...
CREATE nama_user;
CREATE USER nama_user;
CREATE TABLE USER;
CREATE USER;
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 Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
