Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints 5 10 0 9 5 10 0 9 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? ALTER TABLE MODIFY TABLE CHANGE TABLE None of these ALTER TABLE MODIFY TABLE CHANGE TABLE None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to eliminate a table from a database is: REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DELETE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DELETE TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE DELETE ALTER REMOVE COLLAPSE DELETE ALTER REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands is used to retrieve data? SELECT JOIN INSERT DELETE SELECT JOIN INSERT DELETE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS