Introduction to SQL Which SQL keyword is used to retrieve only unique values? DISTINCTIVE DISTINCT UNIQUE DIFFERENT DISTINCTIVE DISTINCT UNIQUE DIFFERENT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: ORDER BY. None of these GROUP BY. SORT BY. ORDER BY. None of these GROUP BY. SORT BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . percent sign (%); underscore (_) underscore(_); question mark (?) question mark (?); asterisk (*) asterisk (*); percent sign (%) percent sign (%); underscore (_) underscore(_); question mark (?) question mark (?); asterisk (*) asterisk (*); percent sign (%) 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 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
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . file report form table file report form table ANSWER DOWNLOAD EXAMIANS APP