Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Data types Default values Primary keys All of these Data types Default values Primary keys All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to eliminate a table from a database is: DELETE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the correct order of keywords for SQL SELECT statements? FROM, WHERE, SELECT SELECT, FROM, WHERE WHERE, FROM,SELECT SELECT,WHERE,FROM FROM, WHERE, SELECT SELECT, FROM, WHERE WHERE, FROM,SELECT SELECT,WHERE,FROM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the total rating of the sailors who have reserved boat "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 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS