Introduction to SQL How to select all data from student table starting the name from letter 'r'? SELECT * FROM student WHERE name LIKE '%r%'; SELECT * FROM student WHERE name LIKE 'r%'; SELECT * FROM student WHERE name LIKE '%r'; SELECT * FROM student WHERE name LIKE '_r%'; SELECT * FROM student WHERE name LIKE '%r%'; SELECT * FROM student WHERE name LIKE 'r%'; SELECT * FROM student WHERE name LIKE '%r'; SELECT * FROM student WHERE name LIKE '_r%'; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? ADD APPEND UPDATE INSERT ADD APPEND UPDATE INSERT 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 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 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; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? SUM, AVG, MIN, MAX, MULT SUM, AVG, MIN, MAX, NAME SUM, AVG, MULT, DIV, MIN COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, MULT SUM, AVG, MIN, MAX, NAME SUM, AVG, MULT, DIV, MIN COUNT, SUM, AVG, MAX, MIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? REMOVE ALTER COLLAPSE DELETE REMOVE ALTER COLLAPSE DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints bc 23 gh ab bc 23 gh ab ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS