Exam Code: C2090-730 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 9 Family Fundamentals
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-730 Exam.
2021 Apr C2090-730 Study Guide Questions:
Q31. Application A holds an Exclusive lock on table TAB1 and needs to acquire an Exclusive lock on table TAB2. Application B holds an Exclusive lock on table TAB2 and needs to acquire an Exclusive lock on table TAB1. If lock timeout is set to -1 and both applications are using the Read Stability isolation level, which of the following will occur?
A. Applications A and B will cause a deadlock situation
B. Application B will read the copy of table TAB1 that was loaded into memory when Application A first read it
C. Application B will read the data in table TAB1 and see uncommitted changes made by Application A
D. Application B will be placed in a lock-wait state until Application A releases its lock
Answer: A
Explanation:
Q32. Which of the following DB2 tools allows a user to set DB2 registry parameters?
A. Task Center
B. Visual Explain
C. Configuration Assistant
D. Satellite Administration Center
Answer: C
Explanation:
Q33. A sequence was created with the DDL statement shown below:
CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5
User1 successfully executes the following statements in Connection1:
VALUES NEXT VALUE FOR my_seq INTO :con1hvar
VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar
After User1 & User2 are finished, User3 executes the following statement in Connection3:
SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1
Which value will be returned by the query?
A. 20
B. 25
C. 50
D. 55
Answer: D
Explanation:
113. An Alias can be an alternate name for which DB2 object?
A. Sequence
B. Trigger
C. Schema
D. View
Answer: D
Explanation:
Far out C2090-730 test question:
Q34. A sequence was created with the DDL statement shown below:
CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10
User USER1 successfully executes the following statements in the order shown:
VALUES NEXT VALUE FOR my_seq INTO :hvar;
VALUES NEXT VALUE FOR my_seq INTO :hvar;
User USER2 successfully executes the following statements in the order shown:
ALTER SEQUENCE my_seq RESTART WITH 5 INCREMENT BY 5 CACHE 5;
VALUES NEXT VALUE FOR my_seq INTO :hvar;
After users USER1 and USER2 are finished, user USER3 executes the following query:
SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1
What value will be returned by the query?
A. 5
B. 10
C. 20
D. 30
Answer: D
Explanation:
Q35. Given the following table and XML data stored in the CONTACTINFO column:
CREATE TABLE clients(
id INT PRIMARY KEY NOT NULL,
name VARCHAR(50),
status VARCHAR(10),
contactinfo XML)
<Client>
<Address>
<street>25 EastCreek</street>
<city>Toronto</city>
<prov-state>Ontario</prov-state>
<pcode-zip>M8X-3T6</pcode-zip>
</Address>
<phone>
<work>4165551358</work>
<home>9051112222</home>
<fax>9051112222</fax>
</phone>
<preferredcontact>by fax</preferredcontact>
</Client>
What is the result of the following XQuery expression?
for $y in db2-fn:xmlcolumn('CLIENTS.CONTACTINFO')/Client//fax return $y
A. 9051112222
B. <fax>9051112222</fax>
C. No results because there is no <fax> child element of <Client>
D. No results because the XQuery expression is not a valid FLWOR expression
Answer: B
Explanation:
Q36. 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:
Verified C2090-730 testing bible:
Q37. A "trusted" client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords?
A. User ID/password file
B. Communications layer
C. Client applications
D. Operating system
Answer: D
Explanation:
Q38. What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?
A. A check constraint on the EMPLOYEE table
B. A unique constraint on the EMPLOYEE table WORKDEPT column
C. A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column ofthe EMPLOYEE table
D. A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of theDEPARTMENT table
Answer: D
Explanation:
Q39. Which object may be used during query optimization to improve the performance for a subset of SELECT queries?
A. MQT
B. Trigger
C. Read Only Cursor
D. Stored Procedure
Answer: A
Explanation:
94. A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the following commands is required to update the local node directory so that a DB2 client can access this DRDA database?
A. CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446
B. CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446
C. CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1
D. CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1
Answer: B
Explanation:
Q40. How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?
CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXTERNAL ACTION NOT DETERMINISTIC BEGIN ... END
A. CALL getratews11('USA','CANADA')
B. CALL expenses.getratews11('USA','CANADA')
C. SELECT getratews11('USA','CANADA') FROM expenses
D. SELECT * FROM TABLE(getratews11('USA','CANADA')) AS convert_currency
Answer: C
Explanation: