Practical of C2090-730 practice materials and secret for IBM certification for customers, Real Success Guaranteed with Updated C2090-730 pdf dumps vce Materials. 100% PASS DB2 9 Family Fundamentals exam Today!


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

Q51. Given the following query: 

SELECT last_name, first_name, age, hire_date 

FROM employee 

WHERE age > 40 

Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z? 

A. SORT BY age ASC, last_name 

B. SORT BY age DESC, last_name 

C. ORDER BY age DESC, last_name 

D. ORDER BY age ASC, last_name 

Answer: C 

Explanation: 


Q52. Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs? 

A. DB2 Express Edition 

B. DB2 Personal Edition 

C. DB2 Workgroup Server Edition 

D. DB2 Enterprise Server Edition 

Answer: D 

Explanation: 


Q53. Given the following two tables: 

EMPLOYEE 

ID NAME DEPTID 

01 Mick Jagger 10 02 Keith Richards 20 03 Ronnie Wood 20 04 Charlie Watts 20 05 Bill Wyman 30 06 Brian Jones -

DEPARTMENT 

ID DEPTNAME 

10 Executive Staff 20 Sales 30 Marketing 40 Engineering 50 Human Resources 

Which two of the following queries will display the employee name and department name for all employees that are in Sales? 

A. SELECT e.name, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND d.id = '20' 

B. SELECT e.name, d.deptname FROM employee e FULL OUTER JOIN department d ON e.deptid = d.id WHERE d.id = '20' 

C. SELECT e.name, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE d.id = '20' 

D. SELECT e.name, d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE d.id = '20' 

E. SELECT e.name, d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE d.id = '20' 

Answer: D,E 

Explanation: 


Q54. Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values? 

A. CREATE DISTINCT TYPE currency AS NUMERIC(7,2) 

B. CREATE DISTINCT TYPE currency AS SMALLINT 

C. CREATE DISTINCT TYPE currency AS BIGINT 

D. CREATE DISTINCT TYPE currency AS DOUBLE 

Answer: A 

Explanation: 


Q55. 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: 

197. Which of the following CREATE TABLE statements will NOT be successful? 

A. CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT) 

B. CREATE TABLE t1 (c1 XML NOT NULL, c2 CHAR(20)) 

C. CREATE TABLE t1 (c1 XML CHECK (c1 IS VALIDATED), c2 INT) 

D. CREATE TABLE t1 (c1 XML, c2 XML) 

Answer: A 

Explanation: 


Q56. Which of the following products must be installed on an AIX server in order to build an application for AIX that will access a DB2 for z/OS database? 

A. DB2 Enterprise Server Edition 

B. DB2 Personal Developer's Edition 

C. DB2 Universal Developer's Edition 

D. DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition 

Answer: C 

Explanation: 


Q57. Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1? 

A. DB2 will no longer allow updating the value of IDCOL1 in TABLE1. 

B. When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1. 

C. When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2,that is values which do not exist in IDCOL1. 

D. When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement. 

Answer: B 

Explanation: 


Q58. Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column? 

A. Sequence 

B. Identity column 

C. Trigger 

D. Table function 

Answer: A 

Explanation: 


Q59. 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: 


Q60. Which two of the following are optional and do not have to be specified when creating a table? 

A. Table name 

B. Column name 

C. Default constraint 

D. Column data type 

E. NOT NULL constraint 

Answer: C,E 

Explanation: