Introduction to SQL Which SQL statement is used to delete data FROM a database? DELETE ALTER COLLAPSE REMOVE DELETE ALTER COLLAPSE REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: None of these for ranges. as a wildcard. to limit the columns displayed. None of these for ranges. as a wildcard. to limit the columns displayed. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat? SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; None of These SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; None of These SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? COUNT MAX All of these SUM COUNT MAX All of these SUM 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
EXAMIANS