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 COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, MULT SUM, AVG, MIN, MAX, NAME COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 6789 2345 456789 1234 6789 2345 456789 1234 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: Both A and B are correct. limits the column data that are returned. limits the row data are returned. Neither A nor B are correct. Both A and B are correct. limits the column data that are returned. limits the row data are returned. Neither A nor B are correct. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? None of these Self-Join Non-Equijoin Equijoin None of these Self-Join Non-Equijoin Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the correct order of keywords for SQL SELECT statements? SELECT,WHERE,FROM FROM, WHERE, SELECT SELECT, FROM, WHERE WHERE, FROM,SELECT SELECT,WHERE,FROM FROM, WHERE, SELECT SELECT, FROM, WHERE WHERE, FROM,SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which of the following is not a data definition language commands? GRANT REVOKE RENAME UPDATE GRANT REVOKE RENAME UPDATE ANSWER DOWNLOAD EXAMIANS APP