Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? ALTER TABLE All of these CHANGE TABLE MODIFY TABLE ALTER TABLE All of these CHANGE TABLE MODIFY TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Projection operation. Selection operation. Join operation. Rename operation. Projection operation. Selection operation. Join operation. Rename operation. ANSWER DOWNLOAD EXAMIANS APP
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 SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False True False ANSWER DOWNLOAD EXAMIANS APP