Introduction to SQL If a query involves NOT, AND, OR with no parenthesis The order of occurrence determines the order of evaluation. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat? None of These SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is a programming language. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands is used to retrieve data? JOIN SELECT DELETE INSERT JOIN SELECT DELETE INSERT 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
EXAMIANS