Introduction to SQL Indexes may be created or dropped at any time. True False True False 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 Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return less than 10 rows exactly 10 rows None of these more than 10 rows less than 10 rows exactly 10 rows None of these more than 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. 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 with even partial criteria met are to be returned. all records meeting the full criteria are to be returned. all columns of the table are to be returned. None of these all records with even partial criteria met are to be returned. all records meeting the full criteria are to be returned. all columns of the table are to be returned. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS