Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... UPDATE FROM CUSTOMER ... DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... UPDATE FROM CUSTOMER ... 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 Which of the following is a SQL aggregate function? AVG LEFT JOIN LEN AVG LEFT JOIN LEN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature has more than two 0's Feature has two 0's in it, at any position Feature begins with two 0's Feature ends with two 0's Feature has more than two 0's Feature has two 0's in it, at any position Feature begins with two 0's Feature ends with two 0's ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS