Introduction to SQL Which of the following is valid SQL for an Index? CHANGE INDEX ID; CREATE INDEX ID; ADD INDEX ID; REMOVE INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; ADD INDEX ID; REMOVE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? AVG LEFT JOIN LEN AVG LEFT JOIN LEN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? REMOVE COLLAPSE ALTER DELETE REMOVE COLLAPSE ALTER DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To establish a range of values, < and > can be used. False True False True 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 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 0 9 10 5 0 9 10 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS