Introduction to SQL SQL data definition commands make up a(n) ________ . DDL XML HTML DML DDL XML HTML DML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 456789 2345 1234 6789 456789 2345 1234 6789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters." False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? COMMIT TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. DISTINCT SINGLE UNIQUE ONLY DISTINCT SINGLE UNIQUE ONLY ANSWER DOWNLOAD EXAMIANS APP