Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: can only be used with two tables. can always be duplicated by a join. cannot have its results sorted using ORDER BY. has a distinct form that cannot be duplicated by a join. can only be used with two tables. can always be duplicated by a join. cannot have its results sorted using ORDER BY. has a distinct form that cannot be duplicated by a join. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE DELETE REMOVE ALTER COLLAPSE DELETE REMOVE ALTER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of every SQL query is a table. 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 = 'V'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS