Introduction to SQL Which SQL keyword is used to sort the result-set? SORT BY ORDER SORT ORDER BY SORT BY ORDER SORT ORDER BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 1234 6789 2345 456789 1234 6789 2345 456789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . asterisk (*); percent sign (%) underscore(_); question mark (?) percent sign (%); underscore (_) question mark (?); asterisk (*) asterisk (*); percent sign (%) underscore(_); question mark (?) percent sign (%); underscore (_) question mark (?); asterisk (*) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? MAKE CREATE INSERT ADD MAKE CREATE INSERT ADD ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS