Introduction to SQL The SQL WHERE clause: limits the column data that are returned. Both A and B are correct. Neither A nor B are correct. limits the row data are returned. limits the column data that are returned. Both A and B are correct. Neither A nor B are correct. limits the row data are returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? SELECT Username, Password FROM Users SELECT Username AND Password FROM Users None of these SELECT Username, Password WHERE Username = 'user1' SELECT Username, Password FROM Users SELECT Username AND Password FROM Users None of these SELECT Username, Password WHERE Username = 'user1' ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? LEFT LEN AVG JOIN LEFT LEN AVG JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . QUERY READ SELECT None of these QUERY READ SELECT None of these 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 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 c) SELECT COUNT(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 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 c) SELECT COUNT(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 Which of the following command makes the updates performed by the transaction permanent in the database? COMMIT TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK DELETE ANSWER DOWNLOAD EXAMIANS APP