Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? DELETE COMMIT TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword BETWEEN can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MULT, DIV, MIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? CHANGE TABLE ALTER TABLE None of these MODIFY TABLE CHANGE TABLE ALTER TABLE None of these MODIFY TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS