Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE ALTER DELETE REMOVE COLLAPSE ALTER DELETE REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? All of these Strings Dates Column Alias All of these Strings Dates Column Alias ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands is used to retrieve data? INSERT SELECT JOIN DELETE INSERT SELECT JOIN DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: can always be duplicated by a join. can only be used with two tables. cannot have its results sorted using ORDER BY. has a distinct form that cannot be duplicated by a join. can always be duplicated by a join. can only be used with two tables. cannot have its results sorted using ORDER BY. has a distinct form that cannot be duplicated by a join. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS