Want to know Testking C2090-730 Exam practice test features? Want to lear more about IBM DB2 9 Family Fundamentals certification experience? Study Printable IBM C2090-730 answers to Most recent C2090-730 questions at Testking. 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
Q111. 57 Given table T1 has column I1 containing the following data: I1
1 2 3 4
If the following sequence of SQL statements is applied within a single unit of work:
UPDATE t1 SET i1 = 3 WHERE i1 = 2; S
AVEPOINT s1 ON ROLLBACK RETAIN CURSORS;
UPDATE t1 SET i1 = 5 WHERE i1 = 3;
SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;
INSERT INTO t1 (i1) VALUES (6);
ROLLBACK TO SAVEPOINT s1;
UPDATE t1 SET i1 = 2 WHERE i1 = 4;
COMMIT;
What is the expected sequence of values returned from?
SELECT i1 FROM t1 ORDER BY i1
A. 1, 2, 3, 3
B. 1, 2, 2, 4
C. 1, 2, 3, 3, 6
D. 1, 2, 2, 5, 6
Answer: A
Explanation:
Q112. Which of the following is NOT a difference between a unique index and a primary key?
A. A primary key is a special form of a unique constraint; both use a unique index.
B. Unique indexes can be defined over one or more columns; primary keys can only be defined on a single column.
C. A table can have many unique indexes but only one primary key.
D. Unique indexes can be defined over one or more columns that allow null values; primary keys cannot contain null values.
Answer: B
Explanation:
Q113. If the following SQL statements are executed in the order shown:
CREATE TABLE table1 (c1 INTEGER, c2 INTEGER);
INSERT INTO table1 VALUES (123, 456);
UPDATE table1 SET c1 = NULL;
What will be the result of the following statement?
SELECT * FROM table1;
A. C1 C2
123 456
1 record(s) selected.
B. C1 C2
NULL 456 1 record(s) selected.
C. C1 C2
-
456
1 record(s) selected.
D.
C1 C2
0 456
1 record(s) selected.
Answer: C
Explanation:
Q114. Given the following table definition:
SALES
SALES_DATE DATE
SALES_PERSON CHAR(20)
REGION CHAR(20)
SALES INTEGER
Which of the following SQL statements will remove all rows that had a SALES_DATE in the year 1995?
A. DELETE * FROM sales WHERE YEAR(sales_date) = 1995
B. DELETE FROM sales WHERE YEAR(sales_date) = 1995
C. DROP * FROM sales WHERE YEAR(sales_date) = 1995
D. DROP FROM sales WHERE YEAR(sales_date) = 1995
Answer: B
Explanation:
Q115. Given the following function:
CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END
How can this function be used in an SQL statement?
A. SELECT TABLE(EMPLIST()) FROM EMPLOYEE
B. SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
C. SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
D. SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
Answer: D
Explanation:
Q116. If the following SQL statements are executed:
CREATE TABLE make (makeid SMALLINT NOT NULL PRIMARY KEY, make VARCHAR(25));
CREATE TABLE model (modelid SMALLINT, model VARCHAR(25), makeid SMALLINT, CONSTRAINT const1 FOREIGN KEY (makeid) REFERENCES make(makeid) ON DELETE RESTRICT);
And each table created is populated as follows: MAKE MAKEID MAKE
1 Ford 2 Chevrolet 3 Toyota
MODEL
MODELID MODEL MAKEID
1 Mustang 1 2 Escort 1 3 Malibu 2 4 Camry 3
If the following SQL statement is executed:
DELETE FROM make WHERE makeid = 1
What is the total number of rows that will be deleted?
A. 0
B. 1
C. 2
D. 3
Answer: A
Explanation:
Q117. Which of the following supports the XML data type?
A. A unique index
B. A composite index
C. A check constraint
D. A generated column
Answer: A
Explanation:
Q118. How does DB2 protect the integrity of indexes when data is updated?
A. Locks are acquired on the data.
B. Locks are acquired on index keys.
C. Locks are acquired on index pages.
D. Locks are acquired on index pointers.
Answer: A
Explanation:
Q119. Which of the following SQL statements can be used to create a DB2 object to store numerical data as EURO data?
A. CREATE NICKNAME euro FOR DECIMAL (9,3)
B. CREATE ALIAS euro FOR DECIMAL (9,3)
C. CREATE DISTINCT TYPE euro AS DECIMAL (9,3)
D. CREATE DATA TYPE euro AS DECIMAL (9,3)
Answer: C
Explanation:
Q120. Given the following table:
TEMP_DATA
TEMP DATE
45 12/25/2006 51 12/26/2006 67 12/27/2006 72 12/28/2006 34 12/29/2006 42 12/30/2006
And the following SQL statement:
CREATE FUNCTION degf_to_c (temp INTEGER)
RETURNS INTEGER
LANGUAGE SQL
CONTAINS SQL
NO EXTERNAL ACTION
DETERMINISTIC
BEGIN ATOMIC
DECLARE newtemp INTEGER;
SET newtemp = temp - 32;
SET newtemp = newtemp * 5;
RETURN newtemp / 9;
END
Which two of the following SQL statements illustrate the proper way to invoke the scalar function DEGF_TO_C?
A. VALUES degf_to_c(32)
B. SELECT date, degf_to_c(temp) AS temp_c FROM temp_data
C. CALL degf_to_c(32)
D. SELECT * FROM TABLE(degf_to_c(temp)) AS temp_c
E. VALUES degf_to_c(32) AS temp_c
Answer: A,B
Explanation: