Introduction to SQL The result of every SQL query is a table. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green') Find the sailor IDs of all sailors who have reserved red boats but not green boats Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats None of These Find the sailor IDs of at least one sailor who have reserved red boats but not green boats Find the sailor IDs of all sailors who have reserved red boats but not green boats Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats None of These Find the sailor IDs of at least one sailor who have reserved red boats but not green boats ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: create database structures only. modify database data only. All of these query database data only. create database structures only. modify database data only. All of these query database data only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS