Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. False True False True 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 5 0 10 9 5 0 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints 50 prints garbage is illegal prints 045.926 prints 50 prints garbage is illegal prints 045.926 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? ORDER BY GROUP BY ALIGN BY SORT BY ORDER BY GROUP BY ALIGN BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS