Introduction to SQL In SQL, which command is used to change a table's storage characteristics? ALTER TABLE MODIFY TABLE None of these CHANGE TABLE ALTER TABLE MODIFY TABLE None of these CHANGE 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? SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; None of these SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; None of these SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? UPDATE SAVE MODIFY SAVE AS UPDATE SAVE MODIFY SAVE AS ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To define what columns should be displayed in an SQL SELECT statement: use USING to name the source table(s) and list the columns to be shown after SELECT. use SELECT to name the source table(s) and list the columns to be shown after USING. use USING to name the source table(s) and list the columns to be shown after WHER use FROM to name the source table(s) and list the columns to be shown after SELECT. use USING to name the source table(s) and list the columns to be shown after SELECT. use SELECT to name the source table(s) and list the columns to be shown after USING. use USING to name the source table(s) and list the columns to be shown after WHER use FROM to name the source table(s) and list the columns to be shown after SELECT. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT humidity = 89 FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city FROM weather; SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city FROM weather; SELECT city WHERE humidity = 89; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? COUNT MAX All of these SUM COUNT MAX All of these SUM ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS