Consider the following relations:
Emp(eid: integer, ename: varchar, sal: integer, age: integer...
![subject](/tpl/images/cats/User.png)
Engineering, 16.05.2020 13:57 dpazmembreno
Consider the following relations:
Emp(eid: integer, ename: varchar, sal: integer, age: integer, did: integer)
Dept(did: integer, budget: integer, floor: integer, mgr_eid: integer)
Salaries range from $10,000 to $100,000, ages vary from 20 to 80, each department has about 5 employees on average, there are 10 floors, and budgets vary from $10,000 to $1M. You can assume uniform distribution. For each of the following queries, which of the listed index choices would you choose to speed up the query? Explain briefly (no more than 3 lines).
Query 1: Print ename, age, and sal for all employees.
Primary (clustered) hash index on (ename, age, sal) fields of Emp.
Secondary (unclustered) hash index on (ename, age, sal) fields of Emp.
Primary B+ tree index on (ename, age, sal) fields of Emp
Secondary hash index on (eid, did) fields of Emp.
No index.
Query 2: Find the dids of departments that are on the 10th floor and have a budget of less than $15,000.
Primary index on the floor field of Dept.
Secondary index on the floor field of Dept.
Primary B+ tree index on (floor, budget) fields of Dept.
Secondary B+ tree index on (floor, budget) fields of Dept.
No index.
![ansver](/tpl/images/cats/User.png)
Answers: 2
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Another question on Engineering
![question](/tpl/images/cats/User.png)
Engineering, 04.07.2019 08:10
Which of the following is an easy way to remember the modified “x” tire rotation? a. nondrive wheels straight, cross the drive wheels b. drive wheels straight, cross the nondrive wheels c. drive wheels crossed, nondrive wheels straight d. drive wheels crossed, nondrive wheels crossed
Answers: 1
![question](/tpl/images/cats/User.png)
Engineering, 04.07.2019 18:10
Apump is used to circulate hot water in a home heating system. water enters the well-insulated pump operating at steady state at a rate of 0.42 gal/min. the inlet pressure and temperature are 14.7 lbf/in.2, and 180°f, respectively; at the exit the pressure is 60 lbf/in.2 the pump requires 1/15 hp of power input. water can be modeled as an incompressible substance with constant density of 60.58 lb/ft3 and constant specific heat of 1 btu/lb or. neglecting kinetic and potential energy effects, determine the temperature change, in °r, as the water flows through the pump.
Answers: 1
![question](/tpl/images/cats/User.png)
Engineering, 04.07.2019 18:10
Hydraulic fluid with a sg. of 0.78 is flowing through a 1.5 in. i.d. pipe at 58 gal/min. the fluid has an absolute viscosity of 11.8 x 105 lbf-sec/ft2. is the flow laminar, turbulent or within the critical range? give both a numerical reynolds number and a term answer.
Answers: 3
![question](/tpl/images/cats/User.png)
Engineering, 04.07.2019 18:10
Journeyman training is usually related (clo2) a)-to specific tasks b)-to cost analysis of maintenance task c)-to control process to ensure quality d)-to installation of machinery
Answers: 2
You know the right answer?
Questions
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/obshestvoznanie.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 24.05.2021 22:40
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/obshestvoznanie.png)
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 24.05.2021 22:40
![question](/tpl/images/cats/mat.png)
Mathematics, 24.05.2021 22:40
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/mkx.png)
Arts, 24.05.2021 22:40
![question](/tpl/images/cats/mat.png)
Mathematics, 24.05.2021 22:40
![question](/tpl/images/cats/mat.png)
Mathematics, 24.05.2021 22:40
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 24.05.2021 22:40
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 24.05.2021 22:40