Introduction to SQL A dynamic view is one whose contents materialize when referenced. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? CHANGE TABLE ALTER TABLE All of these MODIFY TABLE CHANGE TABLE ALTER TABLE All of these MODIFY TABLE 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. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard in a WHERE clause is useful when? An exact match is necessary in a SELECT statement. An exact match is not possible in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is necessary in a CREATE statement. An exact match is necessary in a SELECT statement. An exact match is not possible in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is necessary in a CREATE statement. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . None of these SELECT READ QUERY None of these SELECT READ QUERY ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS