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?
A.
CREATE INDEX empname1 ON dept(info)
GENERATE KEY USING XMLPATTERN ‘//name’ as sql varchar(20);
CREATE INDEX empphone1 ON dept(info)
GENERATE KEY USING XMLPATTERN ‘//phone’ as sql varchar(20);
B.
CREATE INDEX empname1 ON dept(info)
GENERATE KEY USING XMLPATTERN ‘//name’ as sql varchar(20);
CREATE INDEX empphone1 ON dept(info)
GENERATE KEY USING XMLPATTERN ‘/deptinfo/phone’ as sql varchar(20);
C.
CREATE INDEX empname1 ON dept(info)
GENERATE KEY USING XMLPATTERN ‘/deptinfo/name’ as sql varchar(20);
CREATE INDEX empphone1 ON dept(info)
GENERATE KEY USING XMLPATTERN ‘//phone’ as sql varchar(20);
D.
CREATE INDEX empname1 ON dept(info)
GENERATE KEY USING XMLPATTERN ‘/deptinfo/employee/name’ as sql varchar(20);
CREATE INDEX empphone1 ON dept(info)
GENERATE KEY USING XMLPATTERN ‘/deptinfo/employee/phone’ as sql varchar(20);
Explanation: