Question 1
Question
What are b-tree's optimized for in comparison to binary search trees?
Question 2
Question
You hired to create a database for a large corporation. Your
employeers want you to organize their data in a tree data structure.
Which is an appropriate tree data structure?
Answer
-
A) AVL Tree
-
B) 2-3 Tree
-
C) B-Tree
-
D) Red/Black Tree
Question 3
Question
What makes a b-tree seperate from a binary tree?
Question 4
Question
Which one of the following is a key factor for preferring B-trees to binary search trees for indexing database relations?
Answer
-
A.Database relations have a large number of records
-
B.Database relations are sorted on the primary key
-
C.B-trees require less memory than binary search trees
-
D.Data transfer form disks is in blocks
Question 5
Question
What are B-tree's optimized to do?
Question 6
Question
B-Tree is a self-balancing search tree.
Question 7
Question
in a binary search tree, a node can have up to ______ children, while in a 2-3 tree it can have up to ________ children,
and in a 2-3-4 tree a node can have up to _____ chidlren?
Answer
-
A.2, 2, 2
-
B.2, 1, 3
-
C.2, 3, 4
-
D.2, 4, 1
Question 8
Question
Which of the following is true of B-trees?
Answer
-
a. The data items are stored at leaves.
-
b. The nonleaf nodes store up to M-1 keys to guide the searching.
-
c. The root is either a leaf or has between two and M children.
-
d. All of these are true!
Question 9
Question
What is the worst case search time for a B-Tree?
Answer
-
A) O(n^2)
-
B) O(n log n)
-
C) O(log n)
-
D) O(n)
Question 10
Answer
-
a. Keeps values balanced with a sorting algorithm
-
b. uses partially full blocks to speed insertions and deletions
-
c. keys are in sorted order for reverse sequential traversing
-
d. None of the above
Question 11
Question
Which of the following are B-Trees?
Answer
-
A. 2-3 Tree
-
B. 2-3-4 Tree
-
C. Red-Black Tree
-
D. A and B
Question 12
Question
What is a B-Tree?
Answer
-
A) A tree with only right children
-
B) A tree with only left children
-
C) A tree in which a node can have more than two children
-
D) None
Question 13
Question
Which of the following is TRUE about B-Trees?
Answer
-
A. B-trees aim to have the largest tree height possible
-
B. if a B-tree has M children, each node will hold (M + 1) keys
-
C. the max number of children is not user-defined
-
D. if a B-tree has M children, each node will hold (M - 1) keys
Question 14
Question
Which of the following is correct about B-trees?
Answer
-
A. A B-tree is a tree data structure that does not sort data or allow searches, insertions, and deletions in logarithmic amortized time.
-
B. A B-tree is a tree data structure that cannot keep data sorted or allow searches, insertions, and deletions in logarithmic amortized time.
-
C. A B-tree is a tree data structure that keeps data sorted and allows searches, insertions, and deletions in logarithmic amortized time.
-
D. A B-tree is a tree data structure that rewrites data and fails to sort or allow searches, insertions, and deletions in logarithmic amortized time.
Question 15
Question
When talking about a B tree the number of children does NOT need to be greater than the number of the branching factor.
Question 16
Question
The B-tree is a generalization of a binary search tree in that a node can have more than two children
According to Knuth's definition, Which is not correct the following properties of B-tree of order m?
Answer
-
a. Every node has at most m children. All leaves appear in the same level
-
b. Every non-leaf node (except root) has at least ?m/2? children.
-
c. The root has at least two children if it is not a leaf node.
-
d. All leaves don't need to appear in the same level
Question 17
Question
which one is not right about the B tree?
Answer
-
A. one node in a B tree can has a variable number of child nodes.
-
B. Red_black trees B-trees of order 2.
-
C. 2–3 trees are B-trees of order 3.
-
D. 2–3–4 trees are B-trees of order 4.
Question 18
Question
In a B-tree how many children will each nonleaf node have (excluding root) ?
Answer
-
A) M/2 rounded down
-
B) M-1
-
C) M/2 rounded up
-
D) M+1