Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. True False True False 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 10 0 9 5 10 0 9 5 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of every SQL query is a table. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? BETWEEN operator EXISTS operator None of these LIKE operator BETWEEN operator EXISTS operator None of these LIKE operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The Microsoft Access wildcards are ____ and ____ . percent sign (%); underscore (_) question mark (?); asterisk (*) asterisk (*); percent sign (%) underscore(_); question mark (?) percent sign (%); underscore (_) question mark (?); asterisk (*) asterisk (*); percent sign (%) underscore(_); question mark (?) ANSWER DOWNLOAD EXAMIANS APP