Verified of C2090-730 braindumps materials and preparation exams for IBM certification for consumer, Real Success Guaranteed with Updated C2090-730 pdf dumps vce Materials. 100% PASS DB2 9 Family Fundamentals exam Today!
2021 Apr C2090-730 Study Guide Questions:
Q191. Given the statement: CREATE TABLE tablea (col1 INTEGER NOT NULL, CONSTRAINT const1 CHECK (col1 in (100, 200, 300)) Which of the following can be inserted into TABLEA?
A. 0
B. NULL
C. 100
D. '100'
Answer: C
Explanation:
Q192. 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:
Q193. Which of the following tasks can NOT be performed using the Developer Workbench?
A. Develop and debug an SQL stored procedure
B. Develop and debug a user-defined data type
C. Develop and debug a user-defined function
D. Develop and run XML queries
Answer: B
Explanation:
Improve C2090-730 exam question:
Q194. 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:
Q195. 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:
Q196. Given the following stored procedure:
CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6),
OUT p_sum DECIMAL(9,2) )
SET p_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);
How can this stored procedure be called from the Command Line Processor?
A. CALL increase_salary('A00')
B. VALUES increase_salary('A00')
C. CALL increase_salary('A00', ?)
D. VALUES increase_salary('A00', ?)
Answer: A
Explanation:
Guaranteed C2090-730 testing material:
Q197. Which of the following are NOT stored in the system catalog tables?
A. SQL statements used to create views
B. SQL statements used to create triggers
C. SQL statements used to create constraints
D. Table names
Answer: A
Explanation:
Q198. Given the following tables:
YEAR_2006
EMPID NAME
1 Jagger, Mick
2 Richards, Keith
3 Wood, Ronnie
4 Watts, Charlie
5 Jones, Darryl 6 Leavell, Chuck YEAR_1962 EMPID NAME
1 Jagger, Mick 2 Richards, Keith 3 Jones, Brian 4 Wyman, Bill 5 Watts, Charlie 6 Stewart, Ian
If the following SQL statement is executed, how many rows will be returned?
SELECT name FROM year_2007 UNION ALL SELECT name FROM year_1962
A. 6
B. 9
C. 10
D. 12
Answer: D
Explanation:
Q199. Given the following DDL for the PARTS table:
CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));
All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?
A. CREATE UNIQUE INDEX idx_partno ON parts(part_no)
B. CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)
C. CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)
D. CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
Answer: A
Explanation: