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 9 0 5 10 9 0 5 10 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . form file report table form file report table ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? Increased dependence on a single vendor All of these Applications are not needed Reduced training costs Increased dependence on a single vendor All of these Applications are not needed Reduced training costs ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: brackets -- [...]. braces -- {...}. parenthesis -- (...) . CAPITAL LETTERS. brackets -- [...]. braces -- {...}. parenthesis -- (...) . CAPITAL LETTERS. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? SAVE AS SAVE UPDATE MODIFY SAVE AS SAVE UPDATE MODIFY ANSWER DOWNLOAD EXAMIANS APP