Introduction to SQL Which of the following join is also called as an 'inner-join'? Self-Join Equijoin None of these Non-Equijoin Self-Join Equijoin None of these Non-Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: parenthesis -- (...) . CAPITAL LETTERS. braces -- {...}. brackets -- [...]. parenthesis -- (...) . CAPITAL LETTERS. braces -- {...}. brackets -- [...]. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds colors of boats reserved by "Dustin"? SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid; SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid; SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS