Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? EXISTS operator LIKE operator None of these BETWEEN operator EXISTS operator LIKE operator None of these BETWEEN operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. IN and NOT IN LIKE only NOT IN only IN only IN and NOT IN LIKE only NOT IN only IN only ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. True False True False 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