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 To sort the results of a query use: ORDER BY. None of these GROUP BY. SORT BY. ORDER BY. None of these GROUP BY. SORT BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: modify database data only. create database structures only. query database data only. All of these modify database data only. create database structures only. query database data only. All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? EXISTS operator BETWEEN operator None of these LIKE operator EXISTS operator BETWEEN operator None of these LIKE operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. can only be used with two tables. cannot have its results sorted using ORDER BY. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. can only be used with two tables. cannot have its results sorted using ORDER BY. ANSWER DOWNLOAD EXAMIANS APP