Introduction to SQL In SQL, which of the following is not a data definition language commands? REVOKE GRANT UPDATE RENAME REVOKE GRANT UPDATE RENAME ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . form report table file form report table file ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard in a WHERE clause is useful when? An exact match is not possible in a CREATE statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a SELECT statement. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. NATURAL JOIN EQUIJOIN NON-EQUIJOIN OUTER JOIN NATURAL JOIN EQUIJOIN NON-EQUIJOIN OUTER JOIN 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 FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To establish a range of values, < and > can be used. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS