Introduction to SQL The condition in a WHERE clause can refer to only one value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? COUNT SUM MAX All of these COUNT SUM MAX All of these 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 None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? UPDATE ADD APPEND INSERT UPDATE ADD APPEND INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: modify database data only. All of these create database structures only. query database data only. modify database data only. All of these create database structures only. query database data only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DISTINCTIVE DIFFERENT UNIQUE DISTINCT DISTINCTIVE DIFFERENT UNIQUE DISTINCT ANSWER DOWNLOAD EXAMIANS APP