Proper study guides for Improve IBM DB2 9 Family Fundamentals certified begins with IBM C2090-730 preparation products which designed to deliver the Refined C2090-730 questions by making you pass the C2090-730 test at your first time. Try the free C2090-730 demo right now.
♥♥ 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
Q31. Which of the following best describes a unit of work?
A. It is a recoverable sequence of operations whose point of consistency is established when a connection to a database has been established or when a mechanism known as asavepoint is created.
B. It is a recoverable sequence of operations whose current point of consistency can be determined by querying the system catalog tables.
C. It is a recoverable sequence of operations whose point of consistency is established when an executable SQL statement is processed after a connection to a database has been established or a previous transaction has been terminated.
D. It is a recoverable sequence of operations whose point of consistency is only established if a mechanism known as a savepoint is created.
Answer: C
Explanation:
Q32. Which of the following can be viewed with the Journal?
A. Historical information about tasks, database changes, messages, and notifications
B. Information about licenses associated with each DB2 9 product installed on a particular system
C. Graphical representations of data access plans chosen for SQL statements
D. Warning and alarm thresholds for database indicators
Answer: A
Explanation:
Q33. Which of the following actions will NOT cause a trigger to be fired?
A. INSERT
B. DELETE
C. ALTER
D. UPDATE
Answer: C
Explanation:
Q34. If the following SQL statements are executed in the order shown:
CREATE TABLE orders
(order_num INTEGER NOT NULL,
buyer_name VARCHAR(35), amount NUMERIC(5,2));
CREATE UNIQUE INDEX idx_orderno ON orders (order_num);
Which of the following describes the resulting behavior?
A. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows should be displayed in order of increasing ORDER_NUM values
B. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows will be displayed in no particular order
C. Duplicate ORDER_NUM values are allowed; no other index can be created for the ORDERS table that reference the ORDER_NUM column
D. Every ORDER_NUM value entered must be unique; no other index can be created for the ORDERS table that reference the ORDER_NUM column
Answer: A
Explanation:
Q35. 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:
Q36. Which of the following will DELETE all of the rows from table T03?
A. DELETE * FROM TABLE T03
B. DELETE ALL FROM T03
C. DELETE * FROM T03
D. DELETE FROM T03
Answer: D
Explanation:
124. Given the following table definitions:
EMPLOYEE ID NAME DEPTID
01 Smith 10 02 Bossy 20 03 Peterson 20 04 Goss 30 05 Pape 40 06 Avery 50 07 O'Neal 60 08 Carter 50 DEPARTMENT ID DEPTNAME
05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and the following query:
SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4 Which of the following queries will produce the same result set as the query above?
A. SELECT e.id, d.deptname FROM employee e, department d WHERE e.id > 4
B. SELECT e.id, d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4
C. SELECT e.id, d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id > 4
D. SELECT e.id, d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4 UNION ALL SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4
Answer: B
Explanation:
Q37. On which two of the following database objects may the SELECT privilege be controlled?
A. Sequence
B. Nickname
C. Schema
D. View
E. Index
Answer: B,D
Explanation:
Q38. Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?
A. REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
B. REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
C. REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
D. REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
Answer: D
Explanation:
71. Which of the following privileges permits a user to update the comment on a sequence?
A. CONTROL
B. UPDATE
C. USAGE
D. ALTER
Answer: D
Explanation:
Q39. Which of the following is NOT a valid method of authentication that can be used by DB2 9?
A. SERVER
B. SERVER_ENCRYPT
C. CLIENT
D. DCS Answer: D
Explanation:
Q40. Which of the following is a feature of a unit of work?
A. It applies to a single data server.
B. It is a recoverable sequence of operations.
C. Its value can be queried from the system catalog tables.
D. It begins when the application connects to the data server.
Answer: B
Explanation: