Introduction to SQL Which of the following is illegal? SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; None of these SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; None of these SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK DELETE COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The Microsoft Access wildcards are ____ and ____ . question mark (?); asterisk (*) percent sign (%); underscore (_) asterisk (*); percent sign (%) underscore(_); question mark (?) question mark (?); asterisk (*) percent sign (%); underscore (_) asterisk (*); percent sign (%) underscore(_); question mark (?) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? MODIFY TABLE All of these CHANGE TABLE ALTER TABLE MODIFY TABLE All of these CHANGE TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
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 Which of the following join is also called as an 'inner-join'? Equijoin Self-Join None of these Non-Equijoin Equijoin Self-Join None of these Non-Equijoin ANSWER DOWNLOAD EXAMIANS APP