Introduction to SQL Indexes may be created or dropped at any time. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green') Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats Find the sailor IDs of all sailors who have reserved red boats but not green boats None of These Find the sailor IDs of at least one sailor who have reserved red boats but not green boats Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats Find the sailor IDs of all sailors who have reserved red boats but not green boats None of These Find the sailor IDs of at least one sailor who have reserved red boats but not green boats ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: query database data only. create database structures only. modify database data only. All of these query database data only. create database structures only. modify database data only. All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? ROLLBACK COMMIT DELETE TRUNCATE ROLLBACK COMMIT DELETE TRUNCATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS