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

Which of the following are NOT stored in the system catalog tables?

  1. SQL statements used to create views

  2. SQL statements used to create triggers

  3. SQL statements used to create constraints

  4. Table names

Answer: A

Question No: 142

Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?

  1. CREATE DISTINCT TYPE currency AS NUMERIC(7,2)

  2. CREATE DISTINCT TYPE currency AS SMALLINT

  3. CREATE DISTINCT TYPE currency AS BIGINT

  4. CREATE DISTINCT TYPE currency AS DOUBLE

Answer: A

Question No: 143

Given the following table:

EMPLOYEE

EMPID NAME INSTRUMENT

— ——– —

  1. Jagger, Mick 01

  2. Richards, Keith 02

  3. Wood, Ronnie 02

  4. Watts, Charlie 03

  5. Jones, Darryl 04

  6. Leavell, Chuck 05

If the following query is executed: SELECT name,

CASE WHEN instrument = #39;01#39; THEN #39;HARMONICA#39;

WHEN instrument = #39;02#39; THEN#39;GUITAR#39; WHEN instrument = #39;03#39; THEN #39;DRUMS#39; ELSE #39;UNKNOWN#39;

END AS instrument FROM employee

What will be the results?

  1. NAME INSTRUMENT

    ——– —-

    Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, RonnieGUITAR Watts, Charlie DRUMS Jones, Darryl ERROR Leavell, Chuck ERROR

  2. NAME INSTRUMENT

    ——— —-

    Jagger, Mick HARMONICA Richards, Keith GUITAR

    Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl 04

    Leavell, Chuck 05

  3. NAME INSTRUMENT

    ——— —-

    Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl UNKNOWN Leavell, Chuck UNKNOWN

  4. NAME INSTRUMENT

——— —-

Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl –

Leavell, Chuck –

Answer: C

Question No: 144

If the following SQL statements are executed:

CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY, name VARCHAR(25));

CREATE TABLE tab2 (empid SMALLINT,

weekno SMALLINT, payamt DECIMAL(6,2),

CONSTRAINT const1 FOREIGN KEY (empid) REFERENCES taba(id) ON UPDATE NO ACTION);

Which of the following statements is true?

  1. Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2

  2. The updating of values in the ID column of table TAB1 is not allowed

  3. Only values thatdo not already exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2

  4. When values that exist in the ID column of table TAB1 are updated, corresponding values in the EMPID column of table TAB2 are updated aswell

Answer: A

Question No: 145

User USER1 is the owner of TABLE1. Assuming user USER1 only holds privileges for TABLE1, which of the following is the best way to remove all privileges user USER1 holds?

  1. REVOKE CONTROL ON table1 FROMuser1

  2. REVOKE ALL PRIVILEGES ON table1 FROM user1

  3. REVOKE CONTROL ON table1 FROM user1; REVOKE ALL PRIVILEGES ON table1 FROM user1;

  4. REVOKE CONTROL, ALL PRIVILEGES ON table1 FROM user1

Answer: C

Question No: 146

Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?

  1. Unique

  2. Check

  3. Referential

  4. Informational

Answer: B

Question No: 147

Given the following two tables:

TAB1

———– COL_1 COL_2

— — A 10

B12 C 14

TAB2

———– COL_A COL_B

— — A 21

C 23

D 25

Assuming the following results are desired: COL_1 COL_2 COL_ACOL_B

A 10 A 21 B 12 – –

C 14 C 23

– – D 25

Which of the followingjoins will produce the desired results?

  1. SELECT * FROM tab1 INNER JOIN tab2 ON col_1 = col_a

  2. SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON col_1 = col_a

  3. SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON col_1 = col_a

  4. SELECT * FROM tab1 FULL OUTER JOIN tab2 ON col_1 = col_a

Answer: D

Question No: 148

Given the following tables:

CONTINENTS

ID NAME COUNTRIES

  1. Antarctica 0

  2. Africa 53

  3. Asia 47

  4. Australia 14

  5. Europe 43

  6. North America 23

  7. South America 12 REGION

ID LOCATION

  1. East

  2. West

How many rows would bereturned using the following statement? SELECT location FROM continents, region

  1. 2

  2. 7

  3. 9

  4. 14

Answer: D

Question No: 149

If the following SQL statements are executed in the order shown:

CREATE TABLE table1 (c1 INTEGER, c2 INTEGER); INSERT INTO table1 VALUES (123, 456);

UPDATE table1 SET c1 = NULL;

What will be the resultof the following statement? SELECT * FROM table1;

  1. C1 C2

    — — 123 456

    1 record(s) selected.

  2. C1 C2

    — — NULL 456

    1 record(s) selected.

  3. C1 C2

    — —

    – 456

    1. record(s) selected.

  4. C1 C2

— — 0 456

1record(s) selected.

Answer: C

Question No: 150

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

  1. 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)

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

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

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

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