Introduction to SQL Which of the following group functions ignore NULL values? All of these COUNT SUM MAX All of these COUNT SUM MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: DROP FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DROP FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL query and modification commands make up a(n) ________ . HTML DDL DML XML HTML DDL DML XML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the correct order of keywords for SQL SELECT statements? SELECT,WHERE,FROM SELECT, FROM, WHERE WHERE, FROM,SELECT FROM, WHERE, SELECT SELECT,WHERE,FROM SELECT, FROM, WHERE WHERE, FROM,SELECT FROM, WHERE, SELECT ANSWER DOWNLOAD EXAMIANS APP
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