Worksheetssubquery
Total questions: 26
Worksheet time: 1hrs 22mins
________ is a subquery.
Sub part of a query
Query within the query
Clause
None of the above
Which is/are part of subquery?
Inner query
Outer query
Both Inner query & Outer query
None of the above
Which of the following WHERE clauses statements is valid?
WHERE A2 IN (SELECT B2 ...
WHERE A2 EXISTS (SELECT B2 ...
WHERE EXISTS (SELECT B2 ...
WHERE A2 EXISTS IN (SELECT B2...
True or False? Subqueries in the SELECT clause can be correlated
True
False
Which is/are example of list operator in SQL?
Relation
IN
NOT IN
Both IN & NOT IN
Which is/are part of subquery?
Inner query
Outer query
Both Inner query & Outer query
None of the above
Which of the following keywords are equivalent?
IN, NOT IN
AND, OR
NULL, NOT NULL
ANY, SOME
Which keyword is depends on the existence of the result of the query?
EXISTS
NOT EXISTS
NOT NULL
WHERE
Subquery contains _________ number of query.
One
Two
Zero
Any Number
In subquery, =ANY works as given keyword.
IN
NOT IN
<>
!=
Which of the following operator are equivalent?
<>ANY, <>SOME
!=ANY, !=SOME
=IN,=NOT IN
Both <>ANY,<>SOME & !=ANY,!=SOME
Which keyword is used to join multiple strings into a single string?
Join
Concate
Concat
Concatenate
ANY and SOME are the modified version of _______ operator.
Logical
Comparison
Decision
Aggregate
Berikut merupakan operator pembanding yang biasanya digunakan pada single row subquery, kecuali ...
>
>=
=
>any
Berikut merupakan operator yang biasanya digunakan pada multiple row subquery ...
>
all
>exist
>=
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');
A. Main query and subquery can get data from different tables
B. Main query and subquery must get data from the same tables
C. Subqueries can contain GROUP BY and ORDER BY clauses
D. Subqueries can contain ORDER BY but not the GROUP BY clause
E. Only one column or expression can be compared between the main query and subqeury
F. Multiple columns or expressions can be compared between the main query and subquery
Which three statements are true about multiple-row subqueries?
They can contain a subquery within a subquery.
They can return multiple columns as well as rows.
They cannot contain a subquery within a subquery.
They can return only one column but multiple rows.
They can contain group functions and GROUP BY and HAVING clauses.
Beberapa kegunaan subquery dalam memanipulasi data, kecuali.....
Menerima data dari inline view
Meng-copy data dari satu tabel k3 tabel lain
Menghapus baris dari satu tabel berdasarkan baris dari tabel lain
Menampilkan data secara menyeluruh
Mengambil data dari tabel lain untuk kemudian di update ke tabel yang dituju
Ada berapa tipe subquery? Jelaskan satu per satu!
Jelaskan fungsi ANY dan SOME dalam subquery!
Tuliskan query untuk menampilkan judul buku dengan pengarang hanya satu orang!
Buatlah query untuk menampilkan judul buku, hargabuku dengan pengarang andi setiawan dan hargabuku diatas harga rata-rata
Tuliskan Query untuk mendapatkan data buku yang memiliki harga lebih besar dari buku yang jumlah halaman-nya lebih dari 400
Tulislah query untuk mencari buku dengan kategori Basis Data dengan menggunakan subquery!
Tulilah query untuk mencari buku dengan tanggal terbit diantara tahun 2009 dan 2010 dan kode pengarang = erd:
