C2090_612 questions • Exam prepare

Exam contains 131 questions

Page 19 of 22

Question 109 🔥

Click on the exhibit to view properly coded XML data. Some employees have been assigned assistants. Which two are the leanest, most efficient XML indexes to get both the names and phone numbers of employees who are not assistants?

Which database solution meets these requirements?

A. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '//phone' as sql varchar(20);

B. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/phone' as sql varchar(20);

C. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '//phone' as sql varchar(20);

D. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/employee/name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info)

Discussion of the question

Question 110 🔥

What is the one significant difference between sequence objects and identity columns?

Which database solution meets these requirements?

A. Identity columns can cache values and sequence objects cannot.

B. Identity columns can be defined on tables and sequence objects cannot.

C. Sequence objects can have a character data type and identity columns cannot.

D. Sequence object values can be used as primary keys and identity column values cannot.

Discussion of the question

Question 111 🔥

Altering the DSSIZE is allowed for what type of table space?

Which database solution meets these requirements?

A. XML table space.

B. Universal table space.

C. Segmented table space.

D. DSSIZE cannot be altered.

Discussion of the question

Question 112 🔥

An EBCDIC table t1 and a UNICODE table t2 are joined by t1.col1=t2.col2. Which statement is true?

Which database solution meets these requirements?

A. col2 is converted to EBCDIC

B. col1 is converted to UNICODE

C. SQLCode-270: Function not supported

D. col2 and col1 are converted to UTF-32

Discussion of the question

Question 113 🔥

When these two commands are issued in sequence, one after the other: STOP FUNCTION SPECIFIC(A.B) ACTION(REJECT) STOP FUNCTION SPECIFIC(A.B)ACTION(QUEUE) What will occur?

Which database solution meets these requirements?

A. Function B is stopped and queues all access.

B. Function A.B is stopped and rejects all access.

C. Function A.B is stopped and rejects all access until we start the function or run out of installation timeout.

D. Function A.B is stopped and queues all access until we start the function or run out of installation timeout.

Discussion of the question

Question 114 🔥

What is the purpose of the following query? SELECT DBNAME, NAME FROM SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME,TP.TSNAME FROM SYSIBM.SYSTABLEPART TP WHERE TP.DBNAME = TS.DBNAME AND TP.TSNAME = TS.NAME);

Which database solution meets these requirements?

A. It displays the number of inconsistent rows in SYSIBM.SYSTABLESPACE.

B. It identifies which tables do not have related rows in SYSIBM.SYSTABLEPART.

C. It identifies which table spaces have missing related rows in SYSIBM.SYSTABLEPART.

D. It displays which rows in SYSIBM.SYSTABLEPART do not have a matching table name in SYSIBM.SYSTABLESPACE.

Discussion of the question

Ready to Pass Your Certification Test

ibm C2090_612

Exam contains 131 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us