Introduction to SQL Which one of the following sorts rows in SQL? ALIGN BY ORDER BY GROUP BY SORT BY ALIGN BY ORDER BY GROUP BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which of the following is not a data definition language commands? RENAME REVOKE UPDATE GRANT RENAME REVOKE UPDATE GRANT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? SELECT Username AND Password FROM Users None of these SELECT Username, Password FROM Users SELECT Username, Password WHERE Username = 'user1' SELECT Username AND Password FROM Users None of these SELECT Username, Password FROM Users SELECT Username, Password WHERE Username = 'user1' 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 AND r.bid = 103; SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid 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 AND r.bid = 103; SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid 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
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . SELECT None of these READ QUERY SELECT None of these READ QUERY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? Column Alias Dates Strings All of these Column Alias Dates Strings All of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS