Introduction to SQL SQL data definition commands make up a(n) ________ . DDL XML DML HTML DDL XML DML HTML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause does which of the following? Acts like a WHERE clause but is used for rows rather than columns. 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 columns rather than groups. Acts like a WHERE clause but is used for rows rather than columns. 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 columns rather than groups. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of every SQL query is a table. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that: None of these all records meeting the full criteria are to be returned. all columns of the table are to be returned. all records with even partial criteria met are to be returned. None of these all records meeting the full criteria are to be returned. all columns of the table are to be returned. all records with even partial criteria met are to be returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL query and modification commands make up a(n) ________ . DML XML HTML DDL DML XML HTML DDL ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS