To look up an exact match, what should you enter in the range_lookup argument?
A. FALSE
B. TRUE
C. EXACT
D. Leave it blank
Answer: A
You might also like to view...
A table has 100,000 rows and each row occupies 200 bytes. The table is stored on a disk which has 4k bytes per page. Compute the maximum (worst case) cost (number of I/O operations) of doing an equality search on the primary key assuming the following access paths. Make your reasoning clear - a number without an explanation gets no credit.
(a) The data file is unsorted and has no index. (b) The data file is sorted on the primary key and has no index. (c) There is an unclustered static hash index whose search key is the primary key. Assume all buckets are stored on disk and that each bucket has one overflow page. (d) There is an unclustered B+ tree index whose search key is the primary key. Assume that each entry in the tree occupies 20 bytes and the entire tree resides on the disk.
Briefly describe the nested hybrid network model.
What will be an ideal response?
In a direct record organization scheme, the program used to store the data follows a set of instructions, called a ____ algorithm, that transforms each key into a number, the record's logical address.
A. hashing B. grouping C. translation D. lookup
The work breakdown structure (WBS) can only be prepared with a complex, specialized desktop PC application.
Answer the following statement true (T) or false (F)