Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. NATURAL JOIN OUTER JOIN EQUIJOIN NON-EQUIJOIN NATURAL JOIN OUTER JOIN EQUIJOIN NON-EQUIJOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. True False True False 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? 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 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; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands is used to retrieve data? SELECT DELETE JOIN INSERT SELECT DELETE JOIN INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? SUM, AVG, MIN, MAX, NAME COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, MULT SUM, AVG, MIN, MAX, NAME COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, MULT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? EXISTS operator LIKE operator None of these BETWEEN operator EXISTS operator LIKE operator None of these BETWEEN operator ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS