Introduction to SQL Which of the following join is also called as an 'inner-join'? None of these Equijoin Non-Equijoin Self-Join None of these Equijoin Non-Equijoin Self-Join ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the total rating of the sailors who have reserved boat "103"? SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103; SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A view is which of the following? A base table that cannot be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that cannot be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the names of the countries whose condition is sunny. SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny'); SELECT country FROM location WHERE condition = 'sunny'; SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny'); SELECT country FROM location WHERE condition = 'sunny'; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat? SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints 10 0 9 5 10 0 9 5 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS