SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. False True TRUE ANSWER : ? YOUR ANSWER : ?
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 5 10 0 TRUE ANSWER : ? YOUR ANSWER : ?
The wildcard in a WHERE clause is useful when? An exact match is not possible in a SELECT statement. An exact match is necessary in a SELECT statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a CREATE statement. TRUE ANSWER : ? YOUR ANSWER : ?
The SQL keyword BETWEEN is used: None of these for ranges. to limit the columns displayed. as a wildcard. TRUE ANSWER : ? YOUR ANSWER : ?
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): LIKE only. IN only. Both IN and NOT IN. NOT IN only. TRUE ANSWER : ? YOUR ANSWER : ?
A dynamic view is one whose contents materialize when referenced. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following group functions ignore NULL values? COUNT All of these SUM MAX TRUE ANSWER : ? YOUR ANSWER : ?
Count function in SQL returns the number of groups. distinct values. values. columns. TRUE ANSWER : ? YOUR ANSWER : ?