Download of C2090-730 free question materials and software for IBM certification for IT examinee, 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:
Q131. A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month's data?
A. Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.
B. Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re-create the view.
C. Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.
D. Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.
Answer: C
Explanation:
Q132. If an application issues the same query more than once in the same Unit of Work, which isolation level will not permit this application to see additional rows inserted by other applications?
A. Read Stability (RS)
B. Repeatable Read (RR)
C. Uncommitted Read (UR)
D. Cursor Stability (CS)
Answer: B
Explanation:
Q133. If application A issues the following SQL statement, which of the following statements about concurrency is true?
SELECT deptno, deptname, mgrno FROM dept WHERE admrdept = 'A00' FOR READ ONLY WITH RS
A. Rows accessed by application A can be seen by other applications.
B. Rows accessed by application A cannot be seen by other applications.
C. Application A can see uncommitted changes made by other applications.
D. Results produced by re-execution of the statement by application A will not be affected by other applications.
Answer: B
Explanation:
Most recent C2090-730 torrent:
Q134. Which of the following tools can be used to automate table reorganization operations?
A. Control Center
B. Command Center
C. Command Line Processor
D. Task Center
Answer: D
Explanation:
Q135. The opening of cursor CSR01 produces the following result set:
STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey James T100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405
If this Fetch statement is executed:
FETCH csr01 INTO :studnum, :firstname, :lastname, :class
Which of the following DELETE statements will cause this row to be deleted?
A. DELETE ALL FROM tab01 FOR CURRENT OF csr01
B. DELETE FROM tab01 FOR CURRENT csr01 WITH RS
C. DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS
D. DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
Answer: D
Explanation:
142. 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:
Q136. Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?
A. REVOKE ACCESS ON DATABASE FROM USER bob
B. REVOKE CONNECT ON DATABASE FROM USER tom
C. REVOKE tom FROM ACCESS ON DATABASE BY USER bob
D. REVOKE tom FROM CONNECT ON DATABASE BY USER bob
Answer: B
Explanation:
Download C2090-730 testing software:
Q137. Which of the following are all valid DB2 data types?
A. LONG VARCHAR, SMALLINT, NUMBER, BLOB
B. DECIMAL, DATE, DBCLOB, INTERVAL
C. NUMERIC, TIMESTAMP, BYTE, FLOAT
D. NUM, TIME, XML, DOUBLE
Answer: D
Explanation:
Q138. Which of the following is a characteristic of a sequence?
A. A sequence will never generate duplicate values.
B. The MAXVALUE of a sequence can be equal to the MINVALUE.
C. It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero.
D. When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries.
Answer: B
Explanation:
Q139. Which of the following is NOT a characteristic of a declared temporary table?
A. Declared temporary tables are not persistent and can only be used by the application that creates them B. It is possible for many applications to create declared temporary tables that have the same name
C. Declared temporary tables are created by executing a CREATE TABLE statement with the DECLARED GLOBAL TEMPORARY clause specified
D. Once the application that created a global temporary table is terminated, any records in the table are deleted and the table is automatically destroyed Data Concurrency
Answer: C
Explanation:
Q140. Which of the following is NOT an attribute of Declared Global Temporary Tables (DGTTs)?
A. Each application that defines a DGTT has its own instance of the DGTT
B. Two different applications cannot create DGTTs that have the same name
C. DGTTs can only be used by the application that creates them, and only for the life of the application
D. Data stored in a DGTT can exist across transaction boundaries
Answer: B
Explanation: