Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? NOT operator IS NULL operator None of these EXISTS operator NOT operator IS NULL operator None of these EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: braces -- {...}. CAPITAL LETTERS. parenthesis -- (...) . brackets -- [...]. braces -- {...}. CAPITAL LETTERS. parenthesis -- (...) . brackets -- [...]. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000? SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); None of these Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); None of these Both A and B ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? LIKE operator BETWEEN operator EXISTS operator None of these LIKE operator BETWEEN operator EXISTS operator None of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS