Our pass rate is high to 98.9% and the similarity percentage between our C2090-730 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the IBM C2090-730 exam in just one try? I am currently studying for the IBM C2090-730 exam. Latest IBM C2090-730 Test exam practice questions and answers, Try IBM C2090-730 Brain Dumps First.
♥♥ 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
Q151. Which of the following DB2 data types can be used to store 1000 MB of single-byte character data?
A. BLOB
B. CLOB
C. DBCLOB
D. GRAPHIC
Answer: B
Explanation:
Q152. Which of the following DB2 data types CANNOT be used to create an identity column?
A. SMALLINT
B. INTEGER
C. NUMERIC
D. DOUBLE
Answer: D
Explanation:
Q153. 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:
Q154. Which of the following is a valid DB2 data type?
A. NUMBER
B. INTERVAL
C. BYTE
D. NUM
Answer: D
Explanation:
Q155. 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:
Q156. Which of the following products is allowed to access other DB2 servers, but cannot accept requests from other remote clients?
A. DB2 Personal Edition
B. DB2 Workgroup Server Edition
C. DB2 Enterprise Server Edition
D. DB2 Data Warehouse Edition
Answer: A
Explanation:
Q157. 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:
Q158. 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:
Q159. Which of the following DB2 UDB isolation levels will only lock rows during read processing if another transaction tries to drop the table the rows are being read from?
A. Repeatable Read
B. Read Stability
C. Cursor Stability
D. Uncommitted Read
Answer: D
Explanation:
Q160. 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: