________-level information flow is primarily vertical.
A. Top
B. Middle
C. Low
D. Supervisory
Answer: D
You might also like to view...
Which backup method allows for easy full-system restorations (no shuffling through tapes with partial backups on them)?
A. RAID B. The Towers of Hanoi C. Grandfather-Father-Son (GFS) D. Six-tape rotation
What does it mean if we say pattern P matches text T?
a. It means that we can align pattern P with text T such that all characters in P match the ones in T b. It means that we can align pattern P with text T such that all characters in P match the ones in T only once c. It means that all characters from the pattern P occur in T in the given order d. It means that all characters in the pattern P occur in T in any order
Answer the following questions (and explain how you arrived at your solutions).
Consider the following relations that represent part of a real estate database:
Agent(Id, AgentName)
House(Address, OwnerId, AgentId)
Amenity(Address, Feature)
The Agent relation keeps information on real estate agents, the House relation has information
on who is selling the house and the agent involved, and the Amenity relation provides
information on the features of each house. Each relation has its keys underlined.
Consider the following query:
SELECT H.OwnerId, A.AgentName
FROM House H, Agent A, Amenity Y
WHERE H.Address=Y.Address AND A.Id = H.AgentId
AND Y.Feature = '5BR' AND H.AgentId = '007'
Assume that the buffer space available for this query has 5 pages and that the following statistics and indices are available:
- Amenity:
10,000 records on 1,000 houses, 5 records/page
Clustered 2-level B+ tree index on Address
Unclustered hash index on Feature, 50 features
- Agent:
200 agents with 10 tuples/page
Unclustered hash index on Id
- House:
1,000 houses with 4 records/page
Unclustered hash index on AgentId
Clustered 2-level B+ tree index on Address
(a) Draw a fully pushed query tree corresponding to the above query.
(b) Find the best query plan to evaluate the above query and estimate its cost.
(c) Find the next-best plan and estimate its cost.
The advantage of using a footer in your document is the ability to add text that will appear on all your pages.
Answer the following statement true (T) or false (F)