Introduction to SQL Which of the following SQL commands can be used to add data to a database table? ADD UPDATE APPEND INSERT ADD UPDATE APPEND INSERT 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 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 SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To establish a range of values, < and > can be used. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? UPDATE SAVE AS MODIFY SAVE UPDATE SAVE AS MODIFY SAVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);prints 9 0 10 5 9 0 10 5 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Rename operation. Selection operation. Projection operation. Join operation. Rename operation. Selection operation. Projection operation. Join operation. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS