Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If a query involves NOT, AND, OR with no parenthesis AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. The order of occurrence determines the order of evaluation. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. The order of occurrence determines the order of evaluation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is: an operating system. a DBMS. a data sublanguage. a programming language. an operating system. a DBMS. a data sublanguage. a programming language. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: Both A and B are correct. limits the row data are returned. limits the column data that are returned. Neither A nor B are correct. Both A and B are correct. limits the row data are returned. limits the column data that are returned. Neither A nor B are correct. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS