Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . report file form table report file form table 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? Both A and B SELECT name FROM staffinfo WHERE salary IN (10000, 25000); None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; Both A and B SELECT name FROM staffinfo WHERE salary IN (10000, 25000); None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs TRUE Hi FLASE Nothing TRUE Hi FLASE Nothing ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' None of these SELECT Username, Password FROM Users SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' None of these SELECT Username, Password FROM Users ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS