IBM
C2090-312 · Question #74
Click on the exhibit to view properly coded XML data. Some employees have been assigned assistants. Which two are the leanest, most efficient XML indexes to get both the names and phone numbers of…
The correct answer is D. CREATE INDEX empname1 ON dept(info). See the full explanation below for the reasoning.
Question
Click on the exhibit to view properly coded XML data. Some employees have been assigned assistants. Which two are the leanest, most efficient XML indexes to get both the names and phone numbers of employees who are not assistants?
Options
- ACREATE INDEX empname1 ON dept(info)
- BCREATE INDEX empname1 ON dept(info)
- CCREATE INDEX empname1 ON dept(info)
- DCREATE INDEX empname1 ON dept(info)
How the community answered
(17 responses)- A12% (2)
- B6% (1)
- D82% (14)
Community Discussion
No community discussion yet for this question.