Introduction to SQL The benefits of a standard relational language include which of the following? Increased dependence on a single vendor Applications are not needed Reduced training costs All of these Increased dependence on a single vendor Applications are not needed Reduced training costs All of these 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 s, reserves r WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These 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; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ________ was adopted as a national standard by ANSI in 1992. SQL DBase Oracle Microsoft Access SQL DBase Oracle Microsoft Access ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: ORDER BY. GROUP BY. None of these SORT BY. ORDER BY. GROUP BY. None of these SORT BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is the same as blank for character not a value the same as 0 for integer and blank for character the same as 0 for integer the same as blank for character not a value the same as 0 for integer and blank for character the same as 0 for integer ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS