Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints 045.926 prints 50 is illegal prints garbage prints 045.926 prints 50 is illegal prints garbage 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 When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): IN only. NOT IN only. Both IN and NOT IN. LIKE only. IN only. NOT IN only. Both IN and NOT IN. LIKE only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? None of these EXISTS operator NOT operator IS NULL operator None of these EXISTS operator NOT operator IS NULL operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: GROUP BY. None of these SORT BY. ORDER BY. GROUP BY. None of these SORT BY. ORDER BY. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS