What Up to date C2090-730 Is?

Act now and download your IBM C2090-730 test today! Do not waste time for the worthless IBM C2090-730 tutorials. Download Up to date IBM DB2 9 Family Fundamentals exam with real questions and answers and begin to learn IBM C2090-730 with a classic professional.

♥♥ 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

Q11. Which of the following is a characteristic of a sequence? 

A. A sequence will never generate duplicate values. 

B. The MAXVALUE of a sequence can be equal to the MINVALUE. 

C. It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero. 

D. When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries. 

Answer: B 

Explanation: 

Q12. Given the following statements: 

CREATE TABLE table1 (col1 INTEGER, col2 CHAR(3)); 

CREATE VIEW view1 AS SELECT col1, col2 FROM table1 WHERE col1 < 100 WITH LOCAL CHECK OPTION; 

Which of the following INSERT statements will execute successfully? 

A. INSERT INTO view1 VALUES (50, abc) 

B. INSERT INTO view1 VALUES(100, abc) 

C. INSERT INTO view1 VALUES(50, 'abc') 

D. INSERT INTO view1 VALUES(100, 'abc') 

Answer: C 

Explanation: 

Q13. Given that tables T1 and T2 contain the following rows: 

Table T1: C1 C2 

5 4 5 2 5 5 Table T2: C1 C2 5 1 

5 2 

5 3 

Which of the following queries will return only those rows that exist in T1 and not in T2 ? 

A. SELECT * FROM T1 MINUS SELECT * FROM T2 

B. SELECT * FROM T1 EXCEPT SELECT * FROM T2 

C. SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1 

D. SELECT * FROM T1 NOT EXISTS SELECT * FROM T2 

Answer: B 

Explanation: 

Q14. A user invoking a user-defined function requires which DB2 privilege? 

A. CALL 

B. USAGE 

C. EXECUTE 

D. REFERENCES 

Answer: C 

Explanation: 

Q15. Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table? 

A. SELECT UNIQUE dept FROM staff 

B. SELECT DISTINCT dept FROM staff 

C. SELECT (dept) UNIQUE FROM staff 

D. SELECT (dept) DISTINCT FROM staff 

Answer: B 

Explanation: 

Q16. What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column? 

A. Check 

B. Range 

C. Referential 

D. Informational 

Answer: A 

Explanation: 

Q17. The following triggers were defined for table TAB1 in the order shown: 

CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW UPDATE shipping_tab SET ship_date = CURRENT DATE; CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SET billing_date = CURRENT DATE; 

If an event occurs that causes all of them to activate, which trigger will be activated first? 

A. TRIG_A 

B. TRIG_B 

C. TRIG_C 

D. TRIG_D 

Answer: A 

Explanation: 

Q18. Which type of key is defined on the child table to implement a referential constraint? 

A. Unique key 

B. Primary key 

C. Foreign key 

D. Composite key 

Answer: C 

Explanation: 

Q19. When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true? 

A. The list of column names in the FOREIGN KEY clause can be a subset of the list of columnnames in the primary key of T2 or a UNIQUE constraint that exists on T2. 

B. The list of column names in the FOREIGN KEY clause can be a subset of the list of columnnames in the primary key of T1 or a UNIQUE constraint that exists on T1. 

C. The list of column names in the FOREIGN KEY clause must be identical to the list of columnnames in the primary key of T2 or a UNIQUE constraint that exists on T2. 

D. The list of column names in the FOREIGN KEY clause must be identical to the list of columnnames in the primary key of T1 or a UNIQUE constraint that exists on T1. 

Answer: C 

Explanation: 

Q20. If the following SQL statement is executed: 

CREATE TABLE sales 

(invoice_no NOT NULL PRIMARY KEY, 

sales_date DATE, 

sales_amt NUMERIC(7,2)) 

IN tbsp0, tbsp1, tbsp2, tbsp3 

PARTITION BY RANGE (sales_date NULLS FIRST) 

(STARTING '1/1/2007' ENDING '12/31/2007' 

EVERY 3 MONTHS) 

Which of the following statements is true? 

A. Administrative tasks such as backing up, restoring, and reorganizing data stored in the SALES table must be done at the table level; not at the partition level 

B. Data can be quickly rolled in and out of the SALES table by using the ATTACH PARTITION and DETACH PARTITION clauses of the ALTER TABLE statement 

C. If an index is created for the SALES table, its data must be stored in table space TBSP0 

D. When resolving queries against the SALES table, each partition used is scanned asynchronously and the results of each partition scan are merged to produce the result data set returned 

Answer: B 

Explanation: