Introduction to SQL Which of the following join is also called as an 'inner-join'? None of these Equijoin Self-Join Non-Equijoin None of these Equijoin Self-Join Non-Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: GROUP BY. SORT BY. ORDER BY. None of these GROUP BY. SORT BY. ORDER BY. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. DISTINCT UNIQUE SINGLE ONLY DISTINCT UNIQUE SINGLE ONLY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is a view? A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. A view is a special stored procedure executed when certain event occurs. None of these A view is a database diagram. A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. A view is a special stored procedure executed when certain event occurs. None of these A view is a database diagram. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79 SELECT * FROM weather WHERE humidity IN (63 to 79) SELECT * FROM weather WHERE humidity NOT IN (63 AND 79) SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity IN (63 to 79) SELECT * FROM weather WHERE humidity NOT IN (63 AND 79) SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS