Introduction to SQL If a query involves NOT, AND, OR with no parenthesis AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is the same as blank for character the same as 0 for integer and blank for character not a value the same as 0 for integer the same as blank for character the same as 0 for integer and blank for character not a value the same as 0 for integer ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... None of these specify what table we are selecting or deleting data FROM specify search condition specify range for search condition None of these specify what table we are selecting or deleting data FROM specify search condition specify range for search condition ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The Microsoft Access wildcards are ____ and ____ . question mark (?); asterisk (*) percent sign (%); underscore (_) asterisk (*); percent sign (%) underscore(_); question mark (?) question mark (?); asterisk (*) percent sign (%); underscore (_) asterisk (*); percent sign (%) underscore(_); question mark (?) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? ALTER COLLAPSE REMOVE DELETE ALTER COLLAPSE REMOVE DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? COUNT SUM MAX All of these COUNT SUM MAX All of these ANSWER DOWNLOAD EXAMIANS APP