Introduction to SQL The result of every SQL query is a table. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: has a distinct form that cannot be duplicated by a join. can only be used with two tables. cannot have its results sorted using ORDER BY. can always be duplicated by a join. has a distinct form that cannot be duplicated by a join. can only be used with two tables. cannot have its results sorted using ORDER BY. can always be duplicated by a join. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. True False True False ANSWER DOWNLOAD EXAMIANS APP
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 Which of the following is a SQL aggregate function? AVG LEFT LEN JOIN AVG LEFT LEN JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Both of above Data Manipulation Language(DML) Data Definition Language(DDL) None Both of above Data Manipulation Language(DML) Data Definition Language(DDL) None ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS