Want to know Exambible C2090-730 Exam practice test features? Want to lear more about IBM DB2 9 Family Fundamentals certification experience? Study Top Quality IBM C2090-730 answers to Abreast of the times C2090-730 questions at Exambible. Gat a success with an absolute guarantee to pass IBM C2090-730 (DB2 9 Family Fundamentals) test on your first attempt.


♥♥ 2021 NEW RECOMMEND ♥♥

Free VCE & PDF File for IBM C2090-730 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW C2090-730 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/C2090-730-exam-dumps.html

Q101. Given the following DDL for the PARTS table: 

CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9)); 

All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object? 

A. CREATE UNIQUE INDEX idx_partno ON parts(part_no) 

B. CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC) 

C. CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC) 

D. CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC) 

Answer: A 

Explanation: 


Q102. Given the following two tables: 

NAMES 

NAME NUMBER 

Wayne Gretzky 99 Jaromir Jagr 68 Bobby Orr 4 Bobby Hull 23 Mario Lemieux 66 

POINTS 

NAME POINTS 

Wayne Gretzky 244 Bobby Orr 129 Brett Hull 121 Mario Lemieux 189 Joe Sakic 94 

How many rows would be returned using the following statement? 

SELECT name FROM names, points 

A. 0 

B. 5 

C. 10 

D. 25 

Answer: D 

Explanation: 


Q103. Given the following query: 

SELECT quantity, 

CASE WHEN itemcode = '099' THEN 'SILVER' 

WHEN itemcode = '788' THEN 'GOLD' 

WHEN itemcode = '899' THEN 'PLATINUM' 

ELSE 'ERROR' 

END 

FROM supplier 

What will be the result of the query if the following data is evaluated by the CASE expression? 

SUPPLIER 

QUANTITY ITEMCODE 

3 099 

4 099 

1 788 

1 899 

5 009 

3 788 

1 899 

A. 3,SILVER 4,GOLD 1,SILVER 1,GOLD 5,PLATINUM 3,SILVER 1,GOLD 

B. 3,SILVER 4,SILVER 1,GOLD 1,PLATINUM 5,ERROR 3,GOLD 1,PLATINUM 

C. 3,SILVER 4,SILVER 1,PLATINUM 1,ERROR 5,SILVER 3,GOLD 1,PLATINUM 

D. 3,SILVER 4,SILVER 1,GOLD 1,GOLD 5,SILVER 3,ERROR 1,PLATINUM 

Answer: B 

Explanation: 


Q104. The following triggers were defined for a table named SALES in the order shown: 

CREATE TRIGGER trigger_a NO CASCADE BEFORE UPDATE ON sales REFERENCING NEW AS new FOR EACH ROW SET new.commission = sale_amt * .05 

WHERE invoice = n.invoice; 

CREATE TRIGGER trigger_b AFTER INSERT ON sales REFERENCING NEW AS new FOR EACH ROW UPDATE sales SET bill_date = CURRENT DATE + 30 DAYS 

WHERE invoice = n.invoice; 

CREATE TRIGGER trigger_c NO CASCADE BEFORE DELETE ON sales FOR EACH ROW SIGNAL SQLSTATE ‘75005' 

SET MESSAGE_TEXT = ‘Deletes not allowed!' 

Which of the following statements is NOT true? 

A. Once a row has been added to the SALES table, it cannot be removed 

B. Whenever a row is inserted into the SALES table, the value in the BILL_DATE column is automatically set to 30 days from today 

C. Each time a row is inserted into the SALES table, trigger TRIGGER_A is fired first, followed by trigger TRIGGER_B 

D. Whenever a row in the SALES table is updated, all three triggers are fired but nothing happens because none of the triggers have been coded to trap update operations 

Answer: D 

Explanation: 


Q105. When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens? 

A. An error will occur. 

B. Data passed between the client and the server is encrypted. 

C. User IDs and passwords are passed to the server unencrypted. 

D. User IDs and passwords are encrypted before they are passed to the server. 

Answer: A 

Explanation: 


Q106. Given the following table definition: 

STOCK: 

item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2) 

If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock? 

A. UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S% 

B. UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S% 

C. UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%' 

D. UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S% 

Answer: B 

Explanation: 


Q107. Given the following table: 

STOCK 

CATEGORY CHAR(1) 

PARTNO CHAR(12) 

DESCRIPTION VARCHAR(40) 

QUANTITY INTEGER 

PRICE DEC(7,2) 

If items are indicated to be out of stock by setting DESCRIPTION to NULL and QUANTITY and PRICE to zero, which of the following statements updates the STOCK table to indicate that all items except those with CATEGORY of ‘S’ are temporarily out of stock? 

A. UPDATE stock SET description = ’NULL’, quantity = 0, price = 0 WHERE category ‘S’ 

B. UPDATE stock SET description = NULL, SET quantity = 0, SET price = 0 WHERE category ‘S’ 

C. UPDATE stock SET (description, quantity, price) = (‘null’, 0, 0) WHERE category ‘S’ 

D. UPDATE stock SET (description, quantity, price) = (NULL, 0, 0) WHERE category ‘S’ 

Answer: D 

Explanation: 


Q108. What is the lowest privilege and/or authority required to execute the following SQL statement? 

CREATE VIEW view1 AS 

SELECT * FROM table1 

WHERE STATE = 'TX' 

A. DBADM authority 

B. SYSADM authority 

C. SELECT privilege on TABLE1 D. REFERENCES privilege on TABLE1 

Answer: C 

Explanation: 


Q109. Which of the following is true about XML columns? 

A. XML columns are used to store XML documents as a hierarchical set of entities 

B. Only XQuery can be used to retrieve an XML document from an XML column 

C. XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints 

D. In order to access any portion of an XML document stored in an XML column, the entire document must be retrieved 

Answer: A 

Explanation: 


Q110. Which of the following would NOT provide access to data stored in table TABLE1 using the name T1? 

A. An alias named T1 that references table TABLE1 

B. A view named T1 that references table TABLE1 

C. A schema named T1 that references table TABLE1 

D. An alias named T1 that references a view named V1 that references table TABLE1 

Answer: C 

Explanation: