Introduction to SQL When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): Both IN and NOT IN. IN only. NOT IN only. LIKE only. Both IN and NOT IN. IN only. NOT IN only. LIKE only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? None of these LIKE operator BETWEEN operator EXISTS operator None of these LIKE operator BETWEEN operator EXISTS operator 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 is a SQL aggregate function? LEN LEFT JOIN AVG LEN LEFT JOIN AVG ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'V'; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS