Want to know Examcollection C2090-730 Exam practice test features? Want to lear more about IBM DB2 9 Family Fundamentals certification experience? Study Downloadable IBM C2090-730 answers to Up to date C2090-730 questions at Examcollection. 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
Q121. Which two of the following statements are true about the HAVING clause?
A. The HAVING clause is used in place of the WHERE clause.
B. The HAVING clause uses the same syntax as the WHERE clause.
C. The HAVING clause can only be used with the GROUP BY clause.
D. The HAVING clause accepts wildcards.
E. The HAVING clause uses the same syntax as the IN clause.
Answer: B,C
Explanation:
Q122. Which of the following DB2 data types can NOT be used to create an identity column?
A. SMALLINT
B. INTEGER
C. NUMERIC
D. DOUBLE
Answer: D
Explanation:
Q123. Which of the following describes the model used by the Geodetic Extender?
A. Flat earth
B. 3-D Square
C. Trapezoidal
D. Round earth
Answer: D
Explanation:
Q124. Given the following table definition: EMPLOYEES
EMPID INTEGER
NAME CHAR(20)
SALARY DECIMAL(10,2)
If the following SQL statement is executed:
CREATE UNIQUE INDEX empid_ui ON employees (empid)
Which two of the following statements are true?
A. Multiple null values are allowed in the EMPID column of the EMPLOYEES table.
B. No null values are allowed in the EMPID column of the EMPLOYEES table.
C. One (and only one) null value is allowed in the EMPID column of the EMPLOYEES table.
D. No other unique indexes can be created on the EMPLOYEES table.
E. Every value found in the EMPID column of the EMPLOYEES table will be different.
Answer: C,E
Explanation:
Q125. Which of the following is a typical data warehouse query?
A. What is this customer’s address?
B. Does this customer have any unpaid bills?
C. What is the balance in this customers account?
D. What are the total sales for each of the last 6 months?
Answer: D
Explanation:
Q126. Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ:
PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?
A. After a ROLLBACK is issued
B. After the sequence is altered
C. After the sequence is dropped
D. After the current session ends
Answer: A
Explanation:
Q127. Which of the following is used to create and debug user-defined functions?
A. SQL Assist
B. Control Center
C. Command Editor
D. Developer Workbench
Answer: D
Explanation:
Q128. Which of the following DB2 objects is NOT considered executable using SQL?
A. Routine
B. Function
C. Procedure
D. Trigger
Answer: D
Explanation:
Q129. Which of the following is NOT a characteristic of a unique index?
A. Each column in a base table can only participate in one unique index, regardless of how the columns are grouped (the same column cannot be used in multiple uniqueindexes)
B. In order for an index to be used to support a unique constraint, it must have been defined with the UNIQUE attribute
C. A unique index cannot be created for a populated table if the key column specified contains more than one NULL value
D. A unique index can only be created for a non-nullable column
Answer: D
Explanation:
Q130. When does a view get populated?
A. When it is created
B. When it is referenced in an INSERT statement
C. The first time any executable SQL statement references it
D. Any time an executable SQL statement references it
Answer: D
Explanation: