Introduction to SQL Which of the following SQL commands can be used to add data to a database table? APPEND UPDATE ADD INSERT APPEND UPDATE ADD INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? SUM, AVG, MIN, MAX, NAME SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL data definition commands make up a(n) ________ . DDL HTML XML DML DDL HTML XML DML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. SINGLE UNIQUE DISTINCT ONLY SINGLE UNIQUE DISTINCT ONLY ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS