Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. SINGLE DISTINCT ONLY UNIQUE SINGLE DISTINCT ONLY UNIQUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which of the following is not a data definition language commands? RENAME UPDATE GRANT REVOKE RENAME UPDATE GRANT REVOKE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints bc gh 23 ab bc gh 23 ab ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . asterisk (*); percent sign (%) percent sign (%); underscore (_) question mark (?); asterisk (*) underscore(_); question mark (?) asterisk (*); percent sign (%) percent sign (%); underscore (_) question mark (?); asterisk (*) underscore(_); question mark (?) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS