Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of groups. values. columns. distinct values. groups. values. columns. distinct values. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . question mark (?); asterisk (*) underscore(_); question mark (?) percent sign (%); underscore (_) asterisk (*); percent sign (%) question mark (?); asterisk (*) underscore(_); question mark (?) percent sign (%); underscore (_) asterisk (*); percent sign (%) 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 A subquery in an SQL SELECT statement is enclosed in: braces -- {...}. parenthesis -- (...) . brackets -- [...]. CAPITAL LETTERS. braces -- {...}. parenthesis -- (...) . brackets -- [...]. CAPITAL LETTERS. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. False True False True ANSWER DOWNLOAD EXAMIANS APP