15 câu Trắc nghiệm Tin học 11 Kết nối tri thức Thực hành truy xuất dữ liệu qua liên kết các bảng có đáp án

A. SELECT * FROM bannhac WHERE idNhacsi = nhacsi.idNhacsi

B. SELECT bannhac.tenBannhac, nhacsi.tenNhacsi FROM bannhac INNER JOIN nhacsi ON bannhac.idNhacsi = nhacsi.idNhacsi

C. SELECT tenBannhac, tenNhacsi FROM bannhac WHERE bannhac.idNhacsi = nhacsi.idNhacsi

D. SELECT tenBannhac, idNhacsi FROM bannhac WHERE idNhacsi = (SELECT idNhacsi FROM nhacsi)

A. SELECT * FROM bannhac WHERE tenNhacsi = 'Đỗ Nhuận'

B. SELECT tenBannhac, tenNhacsi FROM bannhac WHERE tenNhacsi = 'Đỗ Nhuận'

C. SELECT bannhac.tenBannhac, nhacsi.tenNhacsi FROM bannhac INNER JOIN nhacsi ON bannhac.idNhacsi = nhacsi.idNhacsi WHERE nhacsi.tenNhacsi = 'Đỗ Nhuận'

D. SELECT * FROM nhacsi WHERE tenNhacsi = 'Đỗ Nhuận'

A. SELECT tenBannhac, tenCasi FROM bannhac INNER JOIN banthuam ON bannhac.idBannhac = banthuam.idBannhac INNER JOIN casi ON banthuam.idCasi = casi.idCasi

B. SELECT * FROM bannhac, banthuam, casi

C. SELECT tenBannhac, tenCasi FROM bannhac, banthuam, casi WHERE bannhac.idBannhac = banthuam.idBannhac AND banthuam.idCasi = casi.idCasi

D. SELECT tenBannhac, tenCasi FROM banthuam WHERE bannhac.idBannhac = casi.idCasi

A. SELECT tenBannhac, tenTheloai FROM bannhac INNER JOIN nhacsi ON bannhac.idNhacsi = nhacsi.idNhacsi WHERE nhacsi.tenNhacsi = 'Văn Cao'

B. SELECT bannhac.tenBannhac, bannhac.tenTheloai FROM bannhac INNER JOIN nhacsi ON bannhac.idNhacsi = nhacsi.idNhacsi

C. SELECT bannhac.tenBannhac, nhacsi.tenNhacsi, theloai.tenTheloai FROM bannhac, nhacsi, theloai WHERE nhacsi.tenNhacsi = 'Văn Cao'

D. SELECT * FROM bannhac, nhacsi WHERE tenNhacsi = 'Văn Cao'

A. SELECT * FROM banthuam

B. SELECT tenBannhac, tenNhacsi, tenCasi FROM banthuam

C. SELECT banthuam.idBanthuam, bannhac.tenBannhac, nhacsi.tenNhacsi, casi.tenCasi FROM banthuam INNER JOIN bannhac ON banthuam.idBannhac = bannhac.idBannhac INNER JOIN nhacsi ON bannhac.idNhacsi = nhacsi.idNhacsi INNER JOIN casi ON banthuam.idCasi = casi.idCasi

D. SELECT tenBannhac, tenNhacsi, tenCasi FROM banthuam WHERE idBanthuam = bannhac.idBannhac

A. SELECT * FROM banthuam WHERE tenCasi = 'Lê Dung' AND tenTheloai = 'Nhạc trữ tình'

B. SELECT tenBannhac, tenTheloai, tenCasi FROM banthuam WHERE tenCasi = 'Lê Dung' AND tenTheloai = 'Nhạc trữ tình'

C. SELECT banthuam.idBanthuam, bannhac.tenBannhac, theloai.tenTheloai, casi.tenCasi FROM banthuam INNER JOIN bannhac ON banthuam.idBannhac = bannhac.idBannhac INNER JOIN theloai ON bannhac.idTheloai = theloai.idTheloai INNER JOIN casi ON banthuam.idCasi = casi.idCasi WHERE casi.tenCasi = 'Lê Dung' AND theloai.tenTheloai = 'Nhạc trữ tình'

D. SELECT * FROM banthuam WHERE idCasi = (SELECT idCasi FROM casi WHERE tenCasi = 'Lê Dung')

A. SELECT tenBannhac FROM bannhac

B. SELECT bannhac.tenBannhac FROM bannhac LEFT JOIN nhacsi ON bannhac.idNhacsi = nhacsi.idNhacsi WHERE nhacsi.idNhacsi IS NULL

C. SELECT * FROM bannhac

D. SELECT bannhac.tenBannhac FROM bannhac WHERE idNhacsi = NULL

A. SELECT * FROM bannhac WHERE tenTheloai = 'Nhạc đỏ'

B. SELECT bannhac.tenBannhac, nhacsi.tenNhacsi FROM bannhac INNER JOIN nhacsi ON bannhac.idNhacsi = nhacsi.idNhacsi WHERE bannhac.idTheloai = (SELECT idTheloai FROM theloai WHERE tenTheloai = 'Nhạc đỏ')

C. SELECT * FROM bannhac INNER JOIN theloai ON bannhac.idTheloai = theloai.idTheloai

D. SELECT tenBannhac, tenNhacsi FROM bannhac WHERE tenTheloai = 'Nhạc đỏ'

A. SELECT * FROM banthuam WHERE idCasi IS NULL

B. SELECT banthuam.idBanthuam FROM banthuam WHERE idCasi IS NOT EXISTS

C. SELECT banthuam.idBanthuam, bannhac.tenBannhac FROM banthuam LEFT JOIN casi ON banthuam.idCasi = casi.idCasi WHERE casi.idCasi IS NULL

D. SELECT * FROM banthuam WHERE idBanthuam NOT IN (SELECT idBanthuam FROM casi)

A. SELECT bannhac.tenBannhac, theloai.tenTheloai FROM bannhac

B. SELECT bannhac.tenBannhac, theloai.tenTheloai FROM bannhac INNER JOIN theloai ON bannhac.idTheloai = theloai.idTheloai

C. SELECT bannhac.tenBannhac, theloai.tenTheloai FROM bannhac LEFT JOIN theloai ON bannhac.idTheloai = theloai.idTheloai

D. SELECT bannhac.tenBannhac FROM bannhac WHERE theloai.idTheloai IS NULL