Want to know Testking C2090-730 Exam practice test features? Want to lear more about IBM DB2 9 Family Fundamentals certification experience? Study 100% Correct IBM C2090-730 answers to Regenerate 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. A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?
A. REFERENCES
B. SELECT
C. UPDATE
D. ALTER
Answer: D
Explanation:
Q112. Which of the following CANNOT be used to restrict specific values from being inserted into a column in a particular table?
A. Index
B. Check constraint
C. Referential constraint
D. Default constraint
Answer: D
Explanation:
234. If table TAB1 is created using the following statement:
CREATE TABLE tab1 (col1 INTEGER NOT NULL, col2 CHAR(5), CONSTRAINT cst1 CHECK (col1 in (1, 2, 3)))
Which of the following statements will successfully insert a record into table TAB1?
A. INSERT INTO tab1 VALUES (0, 'abc')
B. INSERT INTO tab1 VALUES (NULL, 'abc')
C. INSERT INTO tab1 VALUES (ABS(2), 'abc')
D. INSERT INTO tab1 VALUES (DEFAULT, 'abc')
Answer: C
Explanation:
Q113. Which of the following is a characteristic of a schema?
A. Foreign key references cannot cross schema boundaries.
B. A DB2 user must be created before a schema with the same name can be created.
C. If no schema is specified when an object is created, the default schema PUBLIC is used.
D. A schema enables the creation of multiple objects in a database without encountering namespace collisions.
Answer: D
Explanation:
Q114. 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:
Q115. 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:
Q116. Which of the following resources can be explicitly locked?
A. Row
B. Page
C. Table
D. Column
Answer: C
Explanation:
Q117. Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?
A. Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
B. Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
C. Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
D. Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
Answer: C
Explanation:
Q118. Which two of the following privileges is required in order to use a package?
A. BINDADD
B. BIND
C. CONNECT
D. EXECUTE
E. USE
Answer: C,D
Explanation:
Q119. 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:
Q120. A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet this requirement?
A. Sequence
B. Table Function
C. Identity Column
D. INSTEAD OF Trigger
Answer: A
Explanation: