create a \"unique\" index of EMP_CODE by filling in the table below : (the numbe

Question

create a "unique" index of EMP_CODE by filling in the table below: (the number of rows shown is not indicative of the correct answer)

Be sure to fill in the blank lines above (key) and (pointer) accordingly.

_______________

(key)

_______________

(pointer)

_______________

(key)

_______________

(pointer)

Table Name: FLEET Table Name: EMPLOYEE EMP CODE VEH ID L NAME Davolio Grubb Leverling Penn Buchanan Smith King Callaharn Dodsworth Klein Johnston Phillips Basil Sunn Barker VEH ID VEH TYPE 10 20 30 40 50 Truck-FLOATER 2 Truck Truck Truck Truck Van Line ServiceTruck 4 6 4 70 80 100 110 120 130 140 150 4

Explanation / Answer

Hi please use below query to create unique index on employee table.

Create unique index empCode_index
ON EMPLOYEE (EMP_CODE);

Find below index table.

Here pointer is the memory address of first block of row being pojnted.

Feel free to ask in comments if you need more clarification.

Index table Key pointer 10 points to first row 20 points to second row 30 points to third row

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.