Introduction to SQL The SQL statement that queries or reads data from a table is ________ . SELECT None of these QUERY READ SELECT None of these QUERY READ ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM MAX COUNT All of these SUM MAX COUNT All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints ab bc gh 23 ab bc gh 23 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 command to eliminate a table from a database is: DELETE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DROP TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The Microsoft Access wildcards are ____ and ____ . question mark (?); asterisk (*) percent sign (%); underscore (_) underscore(_); question mark (?) asterisk (*); percent sign (%) question mark (?); asterisk (*) percent sign (%); underscore (_) underscore(_); question mark (?) asterisk (*); percent sign (%) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS