Introduction to SQL The keyword BETWEEN can be used in a WHERE clause to refer to a range of values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints 50 is illegal prints garbage prints 045.926 prints 50 is illegal prints garbage prints 045.926 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ________ was adopted as a national standard by ANSI in 1992. DBase Oracle SQL Microsoft Access DBase Oracle SQL Microsoft Access ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? IS NULL operator NOT operator EXISTS operator None of these IS NULL operator NOT operator EXISTS operator None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . underscore(_); question mark (?) question mark (?); asterisk (*) percent sign (%); underscore (_) asterisk (*); percent sign (%) underscore(_); question mark (?) question mark (?); asterisk (*) percent sign (%); underscore (_) asterisk (*); percent sign (%) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. True False True False ANSWER DOWNLOAD EXAMIANS APP