Introduction to SQL Which of the following SQL commands is used to retrieve data? DELETE JOIN SELECT INSERT DELETE JOIN SELECT INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? ORDER BY ALIGN BY SORT BY GROUP BY ORDER BY ALIGN BY SORT BY GROUP BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): LIKE only. IN only. Both IN and NOT IN. NOT IN only. LIKE only. IN only. Both IN and NOT IN. NOT IN only. 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. cannot have its results sorted using ORDER BY. can only be used with two tables. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. can only be used with two tables. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ________ was adopted as a national standard by ANSI in 1992. SQL Oracle DBase Microsoft Access SQL Oracle DBase Microsoft Access ANSWER DOWNLOAD EXAMIANS APP