Tested of C2090-730 exam engine materials and paper for IBM certification for customers, Real Success Guaranteed with Updated C2090-730 pdf dumps vce Materials. 100% PASS DB2 9 Family Fundamentals exam Today!
2021 May C2090-730 Study Guide Questions:
Q21. Which of the following is used to indicate a column will not accept NULL values and can be referenced in another table's foreign key specification?
A. Check constraint
B. Unique constraint
C. Default constraint
D. Informational constraint
Answer: B
Explanation:
Q22. Given the following table definition: SALES INVOICE_NO CHAR(20) NOT NULL
SALES_DATE DATE
SALES_PERSON VARCHAR(25)
REGION CHAR(20)
SALES_AMT DECIMAL(9,2)
Which of the following queries will return SALES information, sorted by SALES_PERSON, from A to Z, and SALES_DATE, from most recent to earliest?
A. SELECT invoice_no, sales_person, sales_date, sales_amt FROM sales SORT BY sales_person, sales_date DESC
B. SELECT invoice_no, sales_person, sales_date, sales_amt FROM sales SORT BY sales_person DESC, sales_date
C. SELECT invoice_no, sales_person, sales_date, sales_amt FROM sales ORDER BY sales_person, sales_date DESC
D. SELECT invoice_no, sales_person, sales_date, sales_amt FROM sales ORDER BY sales_person DESC, sales_date
Answer: D
Explanation:
Q23. The following SQL statement:
DELETE FROM tab1 WHERE CURRENT OF csr1 WITH RR Is used to perform which type of delete operation?
A. Positioned
B. Searched
C. Embedded
D. Dynamic
Answer: A
Explanation:
Avant-garde C2090-730 latest exam:
Q24. 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:
Q25. If a view named V1 is created in such a way that it references every column in a table named EMPLOYEE except a column named SALARY, which of the following is NOT an accurate statement?
A. View V1 can be used in the same context as the EMPLOYEE table for all data retrieval operations that do not acquire SALARY information
B. View V1 can be used as a data source for other views
C. View V1 does not have to reside in the same schema as the EMPLOYEE table
D. All data, except SALARY data that is stored in the EMPLOYEE table is copied to the physical location associated with view V1
Answer: D
Explanation:
Q26. Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?
A. DB2 Express Edition
B. DB2 Personal Edition
C. DB2 Workgroup Server Edition
D. DB2 Enterprise Server Edition
Answer: C
Explanation:
Refined C2090-730 paper:
Q27. Given the following table:
STOCK
CATEGORY CHAR(1)
PARTNO CHAR(12)
DESCRIPTION VARCHAR(40)
QUANTITY INTEGER
PRICE DEC(7,2)
If items are indicated to be out of stock by setting DESCRIPTION to NULL and QUANTITY and PRICE to zero, which of the following statements updates the STOCK table to indicate that all items except those with CATEGORY of ‘S’ are temporarily out of stock?
A. UPDATE stock SET description = ’NULL’, quantity = 0, price = 0 WHERE category ‘S’
B. UPDATE stock SET description = NULL, SET quantity = 0, SET price = 0 WHERE category ‘S’
C. UPDATE stock SET (description, quantity, price) = (‘null’, 0, 0) WHERE category ‘S’
D. UPDATE stock SET (description, quantity, price) = (NULL, 0, 0) WHERE category ‘S’
Answer: D
Explanation:
Q28. Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?
A. The cursor is only protected from updates and deletes by concurrent applications.
B. The row is only protected from positioned updates and deletes that reference another cursor of the same application.
C. The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
D. The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application
Answer: A
Explanation:
Q29. Which of the following causes a lock that is being held by an application using the Cursor Stability isolation level to be released?
A. The cursor is moved to another row
B. The row the cursor is on is deleted by the application
C. The row the cursor is on is deleted by another application
D. The row the cursor is on needs to be updated by another application
Answer: A
Explanation:
Q30. Which of the following actions will NOT cause a trigger to be fired?
A. INSERT
B. DELETE
C. ALTER
D. UPDATE
Answer: C
Explanation: