Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? COMMIT TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ________ was adopted as a national standard by ANSI in 1992. Microsoft Access DBase Oracle SQL Microsoft Access DBase Oracle SQL ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? MODIFY TABLE ALTER TABLE CHANGE TABLE None of these MODIFY TABLE ALTER TABLE CHANGE TABLE None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? Strings Dates Column Alias All of these Strings Dates Column Alias 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 gh 23 bc ab gh 23 bc ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): LIKE only. Both IN and NOT IN. IN only. NOT IN only. LIKE only. Both IN and NOT IN. IN only. NOT IN only. ANSWER DOWNLOAD EXAMIANS APP