Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID’s?

Related MCQs

• Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?
• Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is                            
• Which of the following fixed database roles can add or remove user IDs?
• The                operator takes the results of two queries and returns only rows that appear in both result sets.
• Ranking of queries is done by which of the following?
• Which of the following queries are legal?
•                                provides option for entering SQL queries as execution time, rather than at the development stage.
• After conversion of high level queries into low level commands for file access and is called compiled_____:
• The          connective tests for set membership, where the set is a collection of values produced by a select clause. The           connective tests for the absence of set membership.
• If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has