Introduction to SQL To establish a range of values, < and > can be used. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: Neither A nor B are correct. limits the row data are returned. limits the column data that are returned. Both A and B are correct. Neither A nor B are correct. limits the row data are returned. limits the column data that are returned. Both A and B are correct. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these SELECT SYSDATE - SYSDATE FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to eliminate a table from a database is: DROP TABLE CUSTOMER; REMOVE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DELETE TABLE CUSTOMER; DROP TABLE CUSTOMER; REMOVE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DELETE TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? LEN JOIN AVG LEFT LEN JOIN AVG LEFT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS