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

Given the following CREATE TABLE statement:

CREATE TABLE EMPLOYEE (EMPNO CHAR(3) NOT NULL, FIRSTNAME CHAR(20) NOT NULL, MIDINIT CHAR(1),

LASTNAME CHAR(20) NOT NULL, SALARY DECIMAL(10, 2))

Which of the following will retrieve the rows that have a missing value in the MIDINIT column?

  1. SELECT * FROM employee WHERE midinit = #39; #39;

  2. SELECT * FROM employee WHERE midinit =NULL

  3. SELECT * FROM employee WHERE midinit = quot; quot;

  4. SELECT * FROM employee WHERE midinit IS NULL

Answer: D

Question No: 222

Given the following table definition:

SALES

——————- INVOICE_NO CHAR(20) NOT NULL SALES_DATE DATE SALES_PERSON VARCHAR(25) REGION CHAR(20)

SALES_AMT DECIMAL(9,2)

Which of the following queries will return SALES information, sorted by SALES_PERSON,

from A to Z, and SALES_DATE, from most recent to earliest?

  1. SELECT invoice_no, sales_person, sales_date, sales_amt FROM sales SORT BY sales_person, sales_date DESC

  2. SELECT invoice_no, sales_person, sales_date,sales_amt FROM sales SORT BY sales_person DESC, sales_date

  3. SELECT invoice_no, sales_person, sales_date, sales_amt FROM sales ORDER BY sales_person, sales_date DESC

  4. SELECT invoice_no, sales_person, sales_date, sales_amt FROM sales ORDER BY sales_person DESC, sales_date

Answer: D

Question No: 223

Which of the following DB2 data types can NOT be used to create an identity column?

  1. SMALLINT

  2. INTEGER

  3. NUMERIC

  4. DOUBLE

Answer: D

Question No: 224

ESTION NO:298

Given the following two tables: TAB1

C1 C2

Ensurepass 2017 PDF and VCE

A 11

B 12

C 13 TAB2 CX CY

Ensurepass 2017 PDF and VCE

A 21

C 22

D 23

The following results are desired: C1 C2 CX CY

Ensurepass 2017 PDF and VCE

A 11 A 21

C 13 C 22

– – D 23

Which of the following queries will yield thedesired results?

  1. SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx

  2. SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx

  3. SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx

  4. SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx

Answer: D

Question No: 225

Which of the following SQL statements can be used to create a DB2 object to store numerical data as EURO data?

  1. CREATE NICKNAME euro FOR DECIMAL (9,3)

  2. CREATE ALIAS euro FOR DECIMAL (9,3)

  3. CREATE DISTINCT TYPE euro AS DECIMAL (9,3)

  4. CREATE DATA TYPE euro AS DECIMAL (9,3)

Answer: C

Question No: 226

What is the lowest privilege and/or authority required to execute the following SQL statement?

CREATEVIEW view1 AS

SELECT * FROM table1 WHERE STATE = #39;TX#39;

  1. DBADM authority

  2. SYSADM authority

  3. SELECT privilege on TABLE1

  4. REFERENCES privilege on TABLE1

Answer: C

Question No: 227

Which of the following is a typical data warehouse query?

  1. What is this customer’s address?

  2. Does this customer have any unpaid bills?

  3. What is the balance in this customers account?

  4. What are the total sales for each of the last6 months?

Answer: D

Question No: 228

Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?

  1. Journal

  2. Task Center

  3. Control Center

  4. Activity Monitor

Answer: A

Question No: 229

Which of the following would NOT provide access to data stored in table TABLE1 using the name T1?

  1. An alias named T1 that references table TABLE1

  2. A view named T1 that references table TABLE1

  3. A schema named T1 that references table TABLE1

  4. An alias named T1 that references a view named V1 that references table TABLE1

Answer: C

Question No: 230

Given the following data: TAB1

C1 C2

– —

200 abc

250 abc

150 def 300ghi

175 def

If the following query is executed:

WITH subset (col1, col2) AS

(SELECT c1, c2 FROM tab1 WHERE c1 gt; 150)

SELECT col2, SUM(col1) AS col1_sum FROM subset

GROUP BY col2 ORDER BY col2

Which of the following result data sets will be produced?

  1. COL2 COL1_SUM

    — —-

    abc 200

    abc 250

    def 175

    ghi 300

    4 record(s) selected.

  2. COL2 COL1_SUM

    — —-

    abc 450

    def 175

    ghi 300

    3 record(s) selected.

  3. COL2COL1_SUM

    — —-

    abc 450

    def 325

    ghi 300

    3 record(s) selected.

  4. COL2 COL1_SUM

— —-

abc 450

abc 450

def 175

def 175

ghi 300

5 record(s) selected.

Answer: B

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