Ensurepass.com : Ensure you pass the IT Exams
2017 Nov IBM Official New Released C2090-730
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-730.html

DB2 9 Family Fundamentals

Question No: 151

Given the following tables:

YEAR_2006 EMPID NAME

—————–

1Jagger, Mick

  1. Richards, Keith

  2. Wood, Ronnie

  3. Watts, Charlie

  4. Jones, Darryl

  5. Leavell, Chuck YEAR_1962 EMPID NAME

—————–

  1. Jagger, Mick

  2. Richards, Keith

  3. Jones, Brian

  4. Wyman, Bill

  5. Chapman, Tony

  6. Stewart, Ian

If the following SQL statement is executed, how many rows will be returned? SELECTname FROM year_2006

UNION

SELECT name FROM year_1962

  1. 0

  2. 6

  3. 10

  4. 12

Answer: C

Question No: 152

Given thefollowing two tables: NAMES

NAME NUMBER

—– —-

Wayne Gretzky 99

Jaromir Jagr 68

Bobby Orr 4

Bobby Hull 23

Brett Hull 16

Mario Lemieux 66

MarkMessier 11

POINTS

NAME POINTS

—– —

Wayne Gretzky 244

Jaromir Jagr 168

Bobby Orr 129

Brett Hull 121

Mario Lemieux 189

Joe Sakic 94

Which of the following statements will display the player name, number, and points for all players that have scored points?

  1. SELECT p.name, n.number, p.points FROM names n INNER JOIN points p ON n.name

    = p.name

  2. SELECT p.name, n.number, p.points FROM names n LEFT OUTER JOIN points p ON n.name = p.name

  3. SELECT p.name, n.number, p.points FROM names n RIGHT OUTER JOIN points p ON n.name = p.name

  4. SELECT p.name, n.number, p.points FROM names n FULL OUTER JOIN points p ON n.name = p.name

Answer: C

Question No: 153

A view named V.VIEW1 is based on a table named T.TABLE1. A user with DBADM authority issues the following statement:

GRANTINSERT ON v.view1 TO user1 WITH GRANT OPTION

Which of the following statements is USER1 authorized to execute?

  1. GRANT INSERT ON t.table1 TO user2

  2. GRANT CONTROL ON v.view1 TO user2

  3. GRANT ALL PRIVILEGES ON v.view1 TO user2

  4. GRANT INSERT ONv.view1 TO user2

Answer: D

Question No: 154

A client application on z/OS must access a DB2 database on a Solaris Server. At a minimum, which of the following products must be installed on the Solaris workstation?

  1. DB2 Connect Enterprise Edition

  2. DB2 Workgroup Server Edition

  3. DB2 Workgroup Server Edition and DB2 Connect Enterprise Edition

  4. DB2 Enterprise Server Edition and DB2 Connect Enterprise Edition

Answer: D

Question No: 155

Which of the following can NOT be used to restrict specific values from being inserted into a column in a particular table?

  1. Index

  2. Check constraint

  3. Referential constraint

  4. Default constraint

Answer: D

Question No: 156

Application A holds an Exclusive lock on table TAB1 and needs to acquire an Exclusivelock 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?

  1. Applications A and B will cause a deadlock situation

  2. Application B will read the copy of table TAB1 that was loaded into memory when Application A first read it

  3. Application B will read the data in table TAB1 and see uncommitted changes made byApplication A

  4. Application B will be placed in a lock-wait state until Application A releases its lock

Answer: A

Question No: 157

Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolationlevel RS, which of the following will occur?

  1. Applications A and B will cause a deadlock situation.

  2. Application B will read the previous version of the row.

  3. Application B will read the row and see uncommitted changes made by application A.

  4. Application B will be placed in a lock-wait state until application A releases its lock.

Answer: D

Question No: 158

Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?

  1. quot;lt;employee /gt;quot;

  2. quot;lt;namegt;John Doelt;/namegt;quot;

  3. quot;lt;?xml version=#39;1.0#39;encoding=#39;UTF-8#39; ?gt;quot;

D. quot;lt;pgt;lt;/pgt;quot;

Answer: C

Question No: 159

Application A issues the following SQL statements within a single transaction using the Uncommitted Read isolationlevel:

SELECT * FROM department WHERE deptno = #39;A00#39;;

UPDATE department SET mgrno = #39;000100#39; WHERE deptno = #39;A00#39;;

As long as the transaction is not committed, which of the following statements is FALSE?

  1. Other applications not running under the Uncommitted Read isolation level are prohibited from reading the updated row

  2. Application A is allowed to read data stored in another table, even if an Exclusive lock is held on that table

  3. Other applications running under the Uncommitted Read isolation level are allowed to read the updated row

  4. Application A is not allowed to insert new rows into the DEPARTMENT table as long as the current transaction remains active

Answer: D

Question No: 160

Which of the following CANNOT be used to restrict specific values from being inserted into a column in a particular table?

  1. Index

  2. Checkconstraint

  3. Referential constraint

  4. Default constraint

Answer: D

100% Ensurepass Free Download!
Download Free Demo:C2090-730 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-730 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE