Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . QUERY None of these SELECT READ QUERY None of these SELECT READ 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
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints bc gh 23 ab bc gh 23 ab ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Rename operation. Projection operation. Join operation. Selection operation. Rename operation. Projection operation. Join operation. Selection operation. 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
EXAMIANS