Introduction to SQL Which SQL statement is used to update data in a database? UPDATE MODIFY SAVE AS SAVE UPDATE MODIFY SAVE AS SAVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL How to select all data from student table starting the name from letter 'r'? SELECT * FROM student WHERE name LIKE '_r%'; SELECT * FROM student WHERE name LIKE 'r%'; SELECT * FROM student WHERE name LIKE '%r%'; SELECT * FROM student WHERE name LIKE '%r'; SELECT * FROM student WHERE name LIKE '_r%'; SELECT * FROM student WHERE name LIKE 'r%'; SELECT * FROM student WHERE name LIKE '%r%'; SELECT * FROM student WHERE name LIKE '%r'; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? UNIQUE DISTINCTIVE DIFFERENT DISTINCT UNIQUE DISTINCTIVE DIFFERENT DISTINCT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes may be created or dropped at any time. True False True False 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 at least 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 atmost one sailor who have reserved red boats but not green boats Find the sailor IDs of at least 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 atmost one sailor who have reserved red boats but not green boats ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS