Introduction to SQL In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that: all records with even partial criteria met are to be returned. all columns of the table are to be returned. all records meeting the full criteria are to be returned. None of these all records with even partial criteria met are to be returned. all columns of the table are to be returned. all records meeting the full criteria are to be returned. None of these 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
Introduction to SQL The SQL -92 wildcards are ____ and ____ . underscore(_); question mark (?) question mark (?); asterisk (*) percent sign (%); underscore (_) asterisk (*); percent sign (%) underscore(_); question mark (?) question mark (?); asterisk (*) percent sign (%); underscore (_) asterisk (*); percent sign (%) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. ONLY SINGLE DISTINCT UNIQUE ONLY SINGLE DISTINCT UNIQUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? Reduced training costs All of these Applications are not needed Increased dependence on a single vendor Reduced training costs All of these Applications are not needed Increased dependence on a single vendor ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS