Introduction to SQL Which operator performs pattern matching? LIKE operator BETWEEN operator None of these EXISTS operator LIKE operator BETWEEN operator None of these EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ________ was adopted as a national standard by ANSI in 1992. Microsoft Access SQL Oracle DBase Microsoft Access SQL Oracle DBase ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; None of these SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? All of these Column Alias Strings Dates All of these Column Alias Strings Dates ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? CHANGE TABLE None of these MODIFY TABLE ALTER TABLE CHANGE TABLE None of these MODIFY TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: has a distinct form that cannot be duplicated by a join. can always be duplicated by a join. can only be used with two tables. cannot have its results sorted using ORDER BY. has a distinct form that cannot be duplicated by a join. can always be duplicated by a join. can only be used with two tables. cannot have its results sorted using ORDER BY. ANSWER DOWNLOAD EXAMIANS APP