Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. True False True False 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
Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE ALTER DELETE REMOVE COLLAPSE ALTER DELETE REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? All of these Default values Data types Primary keys All of these Default values Data types Primary keys ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword BETWEEN can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT VALUES INTO student ( INSERT VALUES ( INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES INTO student ( INSERT VALUES ( INSERT INTO student VALUES ( INSERT student VALUES ( ANSWER DOWNLOAD EXAMIANS APP