Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? TRUNCATE COMMIT ROLLBACK DELETE TRUNCATE COMMIT ROLLBACK DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM All of these MAX COUNT SUM All of these MAX COUNT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? NUMERIC CHARACTER All of these FLOAT NUMERIC CHARACTER All of these FLOAT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the correct order of keywords for SQL SELECT statements? WHERE, FROM,SELECT SELECT, FROM, WHERE SELECT,WHERE,FROM FROM, WHERE, SELECT WHERE, FROM,SELECT SELECT, FROM, WHERE SELECT,WHERE,FROM FROM, WHERE, SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL query and modification commands make up a(n) ________ . HTML DDL XML DML HTML DDL XML DML 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