Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. False True False True 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. can always be duplicated by a join. cannot have its results sorted using ORDER BY. has a distinct form that cannot be duplicated by a join. can only be used with two tables. can always be duplicated by a join. cannot have its results sorted using ORDER BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 1234 6789 2345 456789 1234 6789 2345 456789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To define what columns should be displayed in an SQL SELECT statement: use SELECT to name the source table(s) and list the columns to be shown after USING. use FROM to name the source table(s) and list the columns to be shown after SELECT. use USING to name the source table(s) and list the columns to be shown after WHER use USING to name the source table(s) and list the columns to be shown after SELECT. use SELECT to name the source table(s) and list the columns to be shown after USING. use FROM to name the source table(s) and list the columns to be shown after SELECT. use USING to name the source table(s) and list the columns to be shown after WHER use USING to name the source table(s) and list the columns to be shown after SELECT. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. False True False True ANSWER DOWNLOAD EXAMIANS APP