Introduction to SQL Which of the following is valid SQL for an Index? ADD INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; CHANGE INDEX ID; ADD INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; CHANGE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... specify search condition specify what table we are selecting or deleting data FROM None of these specify range for search condition specify search condition specify what table we are selecting or deleting data FROM None of these specify range for search condition ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. 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 9 5 10 0 9 5 10 0 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? SAVE MODIFY SAVE AS UPDATE SAVE MODIFY SAVE AS UPDATE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS