Introduction to SQL Which of the following SQL commands can be used to add data to a database table? INSERT UPDATE APPEND ADD INSERT UPDATE APPEND ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? SAVE AS UPDATE MODIFY SAVE SAVE AS UPDATE MODIFY SAVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is a programming language. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? REMOVE DELETE ALTER COLLAPSE REMOVE DELETE ALTER COLLAPSE 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 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, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid 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 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, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS