Actualtests C2090-730 Questions are updated and all C2090-730 answers are verified by experts. Once you have completely prepared with our C2090-730 exam prep kits you will be ready for the real C2090-730 exam without a problem. We have Updated IBM C2090-730 dumps study guide. PASSED C2090-730 First attempt! Here What I Did.
♥♥ 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
Q81. Application A issues the following SQL statements within a single transaction using the Uncommitted Read isolation level:
SELECT * FROM department WHERE deptno = 'A00'
UPDATE department SET mgrno = '000100' WHERE deptno = 'A00'
As long as the transaction is not committed, which of the following statements is FALSE?
A. Other applications not running under the Uncommitted Read isolation level are prohibited from reading the updated row
B. Application A is allowed to read data stored in another table, even if an Exclusive lock is held on that table
C. Other applications running under the Uncommitted Read isolation level are allowed to read the updated row
D. Application A is not allowed to insert new rows into the DEPARTMENT table as long as the current transaction remains active
Answer: D
Explanation:
Q82. Given the requirements to store employee names, employee numbers, and when employees were hired, which of the following built-in data types CANNOT be used to store the day an employee was hired?
A. Character Large Object
B. Time
C. Varying-Length Character String
D. Timestamp
Answer: B
Explanation:
Q83. 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:
Q84. Given the following CREATE TABLE statement:
CREATE TABLE customer(custid INTEGER, info XML)
And the following INSERT statements:
INSERT INTO customer VALUES (1000,
'<customerinfo xmlns="http://custrecord.dat" custid="1000">
<name>John Doe</name>
<addr country="United States">
<street>25 East Creek Drive</street>
<city>Raleigh</city>
<state-prov>North Carolina</state-prov>
<zip-pcode>27603</zip-pcode>
</addr>
<phone type="work">919-555-1212</phone>
<email>john.doe@abc.com</email>
</customerinfo>');
INSERT INTO customer VALUES (1000,
'<customerinfo xmlns="http://custrecord.dat" custid="1001">
<name>Paul Smith</name>
<addr country="Canada">
<street>412 Stewart Drive</street>
<city>Toronto</city>
<state-prov>Ontario</state-prov>
<zip-pcode>M8X-3T6</zip-pcode>
</addr>
<phone type="work">919-555-4444</phone>
<email>psmith@xyz.com</email>
</customerinfo>');
What is the result of the following XQuery expression?
XQUERY declare default element namespace "http://custrecord.dat"; for
$info in db2-fn:xmlcolumn('CUSTOMER.INFO')/customerinfo where
$info/addr/state-prov="Ontario" return $info/name/text();
A. Paul Smith
B. <name xmlns="http://custrecord.dat">Paul Smith</name>
C. <customerinfo xmlns="http://custrecord.dat" custid="1001"><name xmlns="http://custrecord.dat">Paul Smith</name>
D. <customerinfo xmlns="http://custrecord.dat" custid="1001">Paul Smith</customerinfo>
Explanation:
Q85. Which two of the following privileges is required in order to use a package?
A. BINDADD
B. BIND
C. CONNECT
D. EXECUTE
E. USE
Answer: C,D
Explanation:
Q86. A view is created with the following statement:
CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ;
When will DB2 access the data from table T1 for view V1?
A. When view V1 is created
B. Each time the REFRESH VIEW v1 statement is executed
C. Each time an SQL statement is executed against view V1
D. Only the first time an SQL statement is executed against view V1
Answer: C
Explanation:
Q87. Given the following table definition:
EMPLOYESS
EMP ID INTEGER
NAME CHAR(20)
DEPT CHAR(10)
SALARY DECIMAL (10, 2)
COMMISSION DECIMAL (8, 2)
Assuming the DEPT column contains the values ‘ADMIN’, ‘PRODUCTION’, and ‘SALES’, which of the following statements will produce a result data set in which all ADMIN department employees are grouped together, all PRODUCTION department employees are grouped together, and all SALES department employees are grouped together?
A. SELECT name, dept FROM employees ORDER BY dept
B. SELECT name, dept FROM employees GROUP BY dept
C. SELECT name, dept FROM employees GROUP BY ROLLUP (dept)
D. SELECT name, dept FROM employees GROUP BY CUBE (dept)
Answer: A
Explanation:
Q88. Which of the following products is allowed to access other DB2 servers, but cannot accept requests from other remote clients?
A. DB2 Personal Edition
B. DB2 Workgroup Server Edition
C. DB2 Enterprise Server Edition
D. DB2 Data Warehouse Edition
Answer: A
Explanation:
Q89. Given the following table:
TAB1
COL1 COL2
A 10 B 20 C 30 D 40 E 50
And the following SQL statements:
DECLARE c1 CURSOR WITH HOLD FOR
SELECT * FROM tab1 ORDER BY col_1; OPEN c1; FETCH c1; FETCH c1; FETCH c1; COMMIT; FETCH c1; CLOSE c1; FETCH c1;
Which of the following is the last value obtained for COL_2?
A. 20
B. 30
C. 40
D. 50
Answer: C
Explanation:
Q90. Which of the following strings can be inserted into an XML column using XMLPARSE?
A. "<employee/>"
B. "<?xml version='1.0' encoding='UTF-8' ?>"
C. "<!DOCTYPE hello SYSTEM 'hello_world.dtd'>"
D. "<x xmlns:ibmcert='http://www.ibm.com/certify'>"
Answer: A
Explanation: