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 s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT 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 s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? CHANGE TABLE None of these ALTER TABLE MODIFY TABLE CHANGE TABLE None of these ALTER TABLE MODIFY TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: SORT BY. GROUP BY. ORDER BY. None of these SORT BY. GROUP BY. ORDER BY. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? Normalization All of these Materialized Views Data Integrity Normalization All of these Materialized Views Data Integrity ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: None of these to limit the columns displayed. for ranges. as a wildcard. None of these to limit the columns displayed. for ranges. as a wildcard. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes may be created or dropped at any time. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS