Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE DELETE ALTER REMOVE COLLAPSE DELETE ALTER REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints gh bc ab 23 gh bc ab 23 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? MAX SUM All of these COUNT MAX SUM All of these COUNT 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 > ALL (SELECT SALARY FROM EMPLOYEE);prints 10 9 0 5 10 9 0 5 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is a programming language. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? ADD MAKE CREATE INSERT ADD MAKE CREATE INSERT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS