Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. 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. False True False True 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 FROM, WHERE, SELECT SELECT,WHERE,FROM WHERE, FROM,SELECT SELECT, FROM, WHERE FROM, WHERE, SELECT SELECT,WHERE,FROM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? REMOVE DELETE ALTER COLLAPSE REMOVE DELETE ALTER COLLAPSE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs FLASE TRUE Nothing Hi FLASE TRUE Nothing Hi ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? BETWEEN operator LIKE operator None of these EXISTS operator BETWEEN operator LIKE operator None of these EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS