Introduction to SQL ON UPDATE CASCADE ensures which of the following? All of these Materialized Views Data Integrity Normalization All of these Materialized Views Data Integrity Normalization ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? DELETE TRUNCATE COMMIT ROLLBACK DELETE TRUNCATE COMMIT ROLLBACK 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? All of these ALTER TABLE CHANGE TABLE MODIFY TABLE All of these ALTER TABLE CHANGE TABLE MODIFY TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? None of these Self-Join Non-Equijoin Equijoin None of these Self-Join Non-Equijoin Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS