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 To sort the results of a query use: None of these GROUP BY. ORDER BY. SORT BY. None of these GROUP BY. ORDER BY. SORT BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? UPDATE MODIFY SAVE AS SAVE UPDATE MODIFY SAVE AS SAVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the correct order of keywords for SQL SELECT statements? SELECT, FROM, WHERE WHERE, FROM,SELECT SELECT,WHERE,FROM FROM, WHERE, SELECT SELECT, FROM, WHERE WHERE, FROM,SELECT SELECT,WHERE,FROM FROM, WHERE, SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Data types Primary keys All of these Default values Data types Primary keys All of these Default values ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? MAX COUNT SUM All of these MAX COUNT SUM All of these ANSWER DOWNLOAD EXAMIANS APP