Introduction to SQL Which SQL keyword is used to retrieve a maximum value? MAX TOP MOST UPPER MAX TOP MOST UPPER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands is used to retrieve data? SELECT DELETE INSERT JOIN SELECT DELETE INSERT JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . asterisk (*); percent sign (%) underscore(_); question mark (?) percent sign (%); underscore (_) question mark (?); asterisk (*) asterisk (*); percent sign (%) underscore(_); question mark (?) percent sign (%); underscore (_) question mark (?); asterisk (*) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? COUNT All of these SUM MAX COUNT All of these SUM MAX ANSWER DOWNLOAD EXAMIANS APP