Introduction to SQL What operator tests column for the absence of data? None of these IS NULL operator EXISTS operator NOT operator None of these IS NULL operator EXISTS operator NOT operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. NOT IN only IN only LIKE only IN and NOT IN NOT IN only IN only LIKE only IN and NOT IN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes can usually be created for both primary and secondary keys. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is a programming language. 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 IN ('VA'); SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'V'; ANSWER DOWNLOAD EXAMIANS APP