Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? MODIFY TABLE ALTER TABLE All of these CHANGE TABLE MODIFY TABLE ALTER TABLE All of these CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? AVG LEFT LEN JOIN AVG LEFT LEN JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? MAKE INSERT CREATE ADD MAKE INSERT CREATE ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? MAX COUNT All of these SUM MAX COUNT All of these SUM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? TRUNCATE ROLLBACK COMMIT DELETE TRUNCATE ROLLBACK COMMIT DELETE ANSWER DOWNLOAD EXAMIANS APP