14. Which of the following statements are TRUE concerning an Informix B-tree ind

Question

14. Which of the following statements are TRUE concerning an Informix B-tree index? (Choose all that apply) *This question is required.
a. An Informix B-tree index is built in either ascending or descending order, but can be accessed in either direction
b. An Informix B-tree index consists of at least three levels: a root level, a branch level, and a leaf level
c. An Informix B-tree index is used for both duplicate and unique indexes
d. An Informix B+ tree index is not used for partitioned indexes
16. The rows in the ORDERS table are currently stored in ascending order by ORDERNO. You want the rows in the ORDERS table to be stored in descending order by CUSTOMERNO. The only index on the table is ORDERNO_IDX, which is on the ORDERNO column in ascending order. What must you do? *This question is required.
a. Use CREATE INDEX to create a descending index on the CUSTOMERNO column, including the CLUSTER option
b. First, use CREATE INDEX to create a descending index on the CUSTOMERNO column, including the CLUSTER option. Then, use ALTER INDEX on the ORDERNO_IDX index to set the NOT CLUSTER option
c. First, use ALTER INDEX on the ORDERNO_IDX index to set the NOT CLUSTER option. Then, use CREATE INDEX to create a descending index on the CUSTOMERNO column, including the CLUSTER option
d. First, use ALTER TABLE to set the ORDERNO column to NOT CLUSTER. Then, use ALTER TABLE to set the CUSTOMERNO column to CLUSTER DESC
18. Which of the following statements is TRUE concerning the characteristics of a MODE ANSI database? *This question is required.
a. Uses unbuffered logging by default, but can be switched to buffered logging
b. Uses cursor stability by default, but can be switched to any other isolation level
c. All SQL statements are implicitly contained in transactions
d. Default table and synonym privileges are granted to user PUBLIC
21. Three rows are being updated by the following statement:

UPDATE items
SET quantity = quantity - 10
WHERE itemcode in ('A100','A102','B590');
The following trigger has been defined on the items table:

CREATE TRIGGER item_trig
UPDATE OF quantity ON items
BEFORE (EXECUTE PROCEDURE qty_proc);
How many times will the qty_proc procedure be executed? *This question is required.
a. 0
b. 1
c. 3
d. 10

Explanation / Answer

Solution 14 :

a] Option (a) is correct because B-Tree's Each Leaf node has data pointers more than one UNLIKE B+ Tree.

b] Option (b) is not correct because It is not mendatory.

c] Option (c) is not correct because it is used only for unique indexes.

d] Option (d) is correct because B+Tree has only one data pointer in its Leaf Node.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

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