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: 31

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?

  1. 20

  2. 30

  3. 40

  4. 50

Answer: C

Question No: 32

Given the following requirements:

Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the identity column to generate the values for the column by default. Start the values at 10 and increment by 10. Makethe identity column unique.

Which of the following CREATE statements will successfully create this table?

  1. CREATE TABLE TESTTAB

    (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 10

    INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL,

    ACTDESCVARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))

  2. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1

    INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL,

    ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTNO))

  3. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL

    GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 1), ACTKWD CHAR(6) NOT NULL,

    ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))

  4. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10

INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL,

ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))

Answer: D

Question No: 33

Which of the following will provide user USER1 and all members of the group GROUP1 with the ability to perform DML, but no other operations on table TABLE1?

  1. GRANT INSERT, UPDATE,DELETE, SELECT ON TABLE table1 TO user1 AND group1

  2. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO USER user1, GROUP group1

  3. GRANT ALL PRIVILEGES EXCEPT ALTER, INDEX, REFERENCES ON TABLE table1 TO USER user1, GROUP group1

  4. GRANT CONTROL ON TABLE table1 TO user1 AND group1

Answer: B

Question No: 34

Given the following table definitions:

EMPLOYEE

ID NAME DEPTID

– — —–

  1. Smith 10

  2. Bossy 20

  3. Peterson 20

  4. Goss 30

  5. Pape 40

  6. Avery 50

  7. O#39;Neal 60

  8. Carter 50 DEPARTMENT ID DEPTNAME

——–

05 Hardware

10 Kitchen

20 Shoes

30 Toys

40 Electronics

50 Automotive

and the following query:

SELECT e.id, d.deptname

FROM employee e, department d WHERE e.deptid = d.id AND e.id gt;4

Which of the following queries will produce the same result set as the query above?

  1. SELECT e.id, d.deptname FROM employee e, department d WHERE e.id gt; 4

  2. SELECT e.id, d.deptname FROM employee e

    INNER JOIN

    department d

    ON e.deptid = d.id WHERE e.id gt; 4

  3. SELECT e.id, d.deptname FROM employee e

    FULL OUTER JOIN

    department d ON e.id = d.id WHERE e.id gt;4

  4. SELECT e.id, d.deptname FROM employee e

LEFT OUTER JOIN

department d

ON e.deptid = d.id WHERE e.id gt; 4 UNION ALL

SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN

department d

ON e.deptid = d.id WHERE e.id gt; 4

Answer: B

Question No: 35

Which authority or privilege is granted by the DB2Database Manager configuration file?

  1. CONNECT

  2. CONTROL

  3. SYSMAINT

  4. EXECUTE

Answer: C

Question No: 36

Given the following scenario:

Table TABLE1 needs to hold specific numericvalues up to 9999999.999 in column COL1. Once TABLE1 is populated, arithmetic operations will be performed on data stored in column COL1.

Which of the following would be the most appropriate DB2 data type to use for column COL1?

  1. INTEGER

  2. REAL

  3. NUMERIC(7, 3)

  4. DECIMAL(10, 3)

Answer: D

Question No: 37

Whichof the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?

  1. SELECT UNIQUE dept FROM staff

  2. SELECT DISTINCT dept FROM staff

  3. SELECT (dept) UNIQUE FROM staff

  4. SELECT (dept) DISTINCT FROM staff

Answer: B

Question No: 38

Given that tables T1 and T2 contain the followingrows:

Table T1: C1 C2

— — 1 4

1 3

1 2

Table T2: C1 C2

— — 1 1

1 2

1 3

Which of the following queries will return only those rows that exist in both T1 and T2?

  1. SELECT * FROM t1 UNION

    SELECT * FROM t2

  2. SELECT * FROM t1 UNION DISTINCT SELECT *FROM t2

  3. SELECT * FROM t1 INTERSECT

    SELECT * FROM t2

  4. SELECT * FROM t1 WHERE (c1,c2)=

(SELECT c1,c2 FROM t2)

Answer: C

Question No: 39

Which of the following products is used to shred extensible markup language documents?

  1. DB2 AVI Extender

  2. DB2 Text Extender

  3. DB2XML Extender

  4. DB2 Spatial Extender

Answer: C

Question No: 40

Given the following two tables:

NAMES

NAME NUMBER

————-

Wayne Gretzky 99

Jaromir Jagr 68

Bobby Orr 4

Bobby Hull 23

Brett Hull 16

Mario Lemieux 66

Mark Messier 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, andpoints 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

100% Ensurepass Free Download!
Download Free Demo:C2090-730 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-730 Dumps

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