Introduction to SQL Which of the following is a SQL aggregate function? LEN AVG JOIN LEFT LEN AVG JOIN LEFT 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. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. can always be duplicated by a join. can only be used with two tables. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To specify the syntax and semantics of SQL data definition language To define the data structures To specify the syntax and semantics of SQL manipulation language All of these To specify the syntax and semantics of SQL data definition language To define the data structures To specify the syntax and semantics of SQL manipulation language All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is a programming language. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause does which of the following? Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for rows rather than columns. Acts like a WHERE clause but is used for columns rather than groups. Acts like a WHERE clause but is used for groups rather than rows. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for rows rather than columns. Acts like a WHERE clause but is used for columns rather than groups. Acts like a WHERE clause but is used for groups rather than rows. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS