Introduction to SQL The SQL statement that queries or reads data from a table is ________ . None of these SELECT READ QUERY None of these SELECT READ QUERY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? SORT BY SORT ORDER ORDER BY SORT BY SORT ORDER ORDER BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds colors of boats reserved by "Dustin"? SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid; SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? Materialized Views Normalization Data Integrity All of these Materialized Views Normalization Data Integrity All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature has more than two 0's Feature begins with two 0's Feature ends with two 0's Feature has two 0's in it, at any position Feature has more than two 0's Feature begins with two 0's Feature ends with two 0's Feature has two 0's in it, at any position ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? INSERT UPDATE ADD APPEND INSERT UPDATE ADD APPEND ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS