Introduction to SQL Which of the following is a SQL aggregate function? LEN AVG LEFT JOIN LEN AVG LEFT JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK DELETE COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 1234 2345 6789 456789 1234 2345 6789 456789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To establish a range of values, < and > can be used. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? All of these Data types Default values Primary keys All of these Data types Default values Primary keys ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? EXISTS operator None of these LIKE operator BETWEEN operator EXISTS operator None of these LIKE operator BETWEEN operator ANSWER DOWNLOAD EXAMIANS APP