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 join is also called as an 'inner-join'? Non-Equijoin Self-Join None of these Equijoin Non-Equijoin Self-Join None of these Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat? None of These SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; None of These SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints 23 ab gh bc 23 ab gh bc ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS