We provide real C2090-730 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass IBM C2090-730 Exam quickly & easily. The C2090-730 PDF type is available for reading and printing. You can print more and practice many times. With the help of our IBM C2090-730 dumps pdf and vce product and material, you can easily pass the C2090-730 exam.


♥♥ 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

Q21. Assuming table TAB1 contains 100 rows, which of the following queries will return only half of the rows available? 

A. SELECT * FROM tab1 FIND FIRST 50 ROWS 

B. SELECT * FROM tab1 FETCH FIRST 50 ROWS ONLY 

C. SELECT * FROM tab1 WHILE ROW_NUM < 50 

D. SELECT * FROM tab1 MAXROWS 50 

Answer:

Explanation: 


Q22. 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:

Explanation: 


Q23. Which of the following is NOT a characteristic of a unique index? 

A. Each column in a base table can only participate in one unique index, regardless of how the columns are grouped (the same column cannot be used in multiple unique indexes) 

B. In order for an index to be used to support a unique constraint, it must have been defined with the UNIQUE attribute 

C. A unique index cannot be created for a populated table if the key column specified contains more than one NULL value 

D. A unique index can only be created for a non-nullable column 

Answer:

Explanation: 


Q24. 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:

Explanation: 


Q25. 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:

Explanation: 


Q26. Which of the following isolation levels will lock all rows scanned to build a result data set? 

A. Uncommitted Read 

B. Cursor Stability 

C. Read Stability 

D. Repeatable Read 

Answer:

Explanation: 


Q27. Given the following query: 

SELECT last_name, first_name, age, hire_date 

FROM employee 

WHERE age > 40 

Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z? 

A. SORT BY age ASC, last_name 

B. SORT BY age DESC, last_name 

C. ORDER BY age DESC, last_name 

D. ORDER BY age ASC, last_name 

Answer:

Explanation: 


Q28. Which of the following is a NOT a valid reason for defining a view on a table? 

A. Restrict users' access to a subset of table data 

B. Ensure that rows inserted remain within the scope of a definition 

C. Produce an action as a result of a change to a table 

D. Provide users with an alternate view of table data 

Answer:

Explanation: 


Q29. Given the requirements to store customer names, billing addresses, and telephone numbers, which of the following would be the best way to define the telephone number column for a table if all customers were located in the same country? 

A. PHONECHAR(15) 

B. PHONEVARCHAR(15) 

C. PHONELONG VARCHAR 

D. PHONECLOB(1K) 

Answer:

Explanation: 


Q30. Which of the following statements is used to grant user TOM and 

Application team APPGRP the ability to add data to table TAB1? 

A. GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp 

B. GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1 

C. GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp 

D. GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom 

Answer:

Explanation: