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. False True False True ANSWER DOWNLOAD EXAMIANS APP
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 Which SQL statement is used to update data in a database? SAVE MODIFY UPDATE SAVE AS SAVE MODIFY UPDATE SAVE AS ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL query and modification commands make up a(n) ________ . HTML XML DDL DML HTML XML DDL DML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? BETWEEN operator EXISTS operator None of these LIKE operator BETWEEN operator EXISTS operator None of these LIKE operator 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. False True False True ANSWER DOWNLOAD EXAMIANS APP