Introduction to SQL Count function in SQL returns the number of groups. distinct values. columns. values. groups. distinct values. columns. values. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; is illegal prints 045.926 prints 50 prints garbage is illegal prints 045.926 prints 50 prints garbage 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 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 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 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 c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? JOIN LEFT AVG LEN JOIN LEFT AVG LEN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Join operation. Selection operation. Projection operation. Rename operation. Join operation. Selection operation. Projection operation. Rename operation. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS