Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Primary keys Default values Data types All of these Primary keys Default values Data types All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT city FROM weather; SELECT humidity = 89 FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city WHERE humidity = 89; SELECT city FROM weather; SELECT humidity = 89 FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city WHERE humidity = 89; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? Reduced training costs Applications are not needed Increased dependence on a single vendor All of these Reduced training costs Applications are not needed Increased dependence on a single vendor All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. OUTER JOIN NATURAL JOIN EQUIJOIN NON-EQUIJOIN OUTER JOIN NATURAL JOIN EQUIJOIN NON-EQUIJOIN ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS