Introduction to SQL Which of the following group functions ignore NULL values? All of these MAX COUNT SUM All of these MAX COUNT SUM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? MODIFY TABLE None of these ALTER TABLE CHANGE TABLE MODIFY TABLE None of these ALTER TABLE CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? UNIQUE DISTINCTIVE DISTINCT DIFFERENT UNIQUE DISTINCTIVE DISTINCT DIFFERENT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS