Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . file form table report file form table report ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM COUNT All of these MAX SUM COUNT All of these MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . table file report form table file report form ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? ROLLBACK COMMIT DELETE TRUNCATE ROLLBACK COMMIT DELETE TRUNCATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature ends with two 0's Feature has more than two 0's Feature begins with two 0's Feature has two 0's in it, at any position Feature ends with two 0's Feature has more than two 0's Feature begins with two 0's Feature has two 0's in it, at any position ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS