Introduction to SQL The SQL keyword(s) ________ is used with wildcards. LIKE only NOT IN only IN and NOT IN IN only LIKE only NOT IN only IN and NOT IN IN only ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: parenthesis -- (...) . braces -- {...}. brackets -- [...]. CAPITAL LETTERS. parenthesis -- (...) . braces -- {...}. brackets -- [...]. CAPITAL LETTERS. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? Dates Column Alias All of these Strings Dates Column Alias All of these Strings ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? INSERT APPEND UPDATE ADD INSERT APPEND UPDATE ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? MAKE ADD CREATE INSERT MAKE ADD CREATE INSERT ANSWER DOWNLOAD EXAMIANS APP