Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? COUNT MAX All of these SUM COUNT MAX All of these SUM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 6789 1234 2345 456789 6789 1234 2345 456789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Projection operation. Rename operation. Selection operation. Join operation. Projection operation. Rename operation. Selection operation. Join operation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Default values Primary keys Data types All of these Default values Primary keys Data types All of these ANSWER DOWNLOAD EXAMIANS APP