Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs TRUE FLASE Nothing Hi TRUE FLASE Nothing Hi ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. NOT IN only IN and NOT IN IN only LIKE only NOT IN only IN and NOT IN IN only LIKE only 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
Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. 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 What is the meaning of LIKE '%0%0%' Feature begins with two 0's Feature has more than two 0's Feature ends with two 0's Feature has two 0's in it, at any position Feature begins with two 0's Feature has more than two 0's Feature ends with two 0's Feature has two 0's in it, at any position ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS