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

Given the following tables: YEAR_2006

EMPID NAME

— ——–

1 Jagger, Mick 2Richards, Keith

  1. Wood, Ronnie

  2. Watts, Charlie

  3. Jones, Darryl

  4. Leavell, Chuck YEAR_1962

EMPID NAME

— ——–

  1. Jagger, Mick

  2. Richards, Keith

  3. Jones, Brian

  4. Wyman, Bill

  5. Watts, Charlie

  6. Stewart, Ian

If the following SQL statement is executed, how many rows will be returned? SELECT name FROM year_2007

UNION ALL

SELECT name FROM year_1962

  1. 6

  2. 9

  3. 10

  4. 12

Answer: D

Question No: 62

Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?

  1. DB2 Express Edition

  2. DB2 Personal Edition

  3. DB2 Workgroup Server Edition

  4. DB2 Enterprise Server Edition

Answer: D

Question No: 63

Which of the following describes how DB2 9 stores an XML document if the XMLExtender is not used?

  1. CLOB

  2. BLOB

  3. Hierarchically

  4. Rows and columns

Answer: C

Question No: 64

Given the following table and XML data stored in the CONTACTINFO column:

CREATE TABLE clients(

id INT PRIMARY KEY NOT NULL, name VARCHAR(50),

statusVARCHAR(10), contactinfo XML)

lt;Clientgt;

lt;Addressgt;

lt;streetgt;25 EastCreeklt;/streetgt;

lt;citygt;Torontolt;/citygt;

lt;prov-stategt;Ontariolt;/prov-stategt;

lt;pcode-zipgt;M8X-3T6lt;/pcode-zipgt;

lt;/Addressgt;

lt;phonegt;

lt;workgt;4165551358lt;/workgt;

lt;homegt;9051112222lt;/homegt;

lt;faxgt;9051112222lt;/faxgt;

lt;/phonegt;

lt;preferredcontactgt;by faxlt;/preferredcontactgt;

lt;/Clientgt;

What is the result of the following XQuery expression?

for $y in db2-fn:xmlcolumn(#39;CLIENTS.CONTACTINFO#39;)/Client//fax return $y

A. 9051112222

B. lt;faxgt;9051112222lt;/faxgt;

  1. No results because there is no lt;faxgt; child element of lt;Clientgt;

  2. No results because the XQuery expression is not a valid FLWOR expression

Answer: B

Question No: 65

Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?

  1. Control Center

  2. Development Center

  3. Developer Workbench

  4. Stored ProcedureBuilder Security

Answer: C

Question No: 66

Given the following requirements:

Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values #39;C#39;, #39;H#39; and #39;N#39;, and permits inserts only when a corresponding value for the employee#39;s department exists in the DEPARTMENT table.

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

  1. CREATE TABLE emp (

    empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY,

    firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL,

    workdept CHAR(3) NOT NULL, edlevel CHAR(1),

    PRIMARY KEY emp_pk (empno),

    FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno), CHECKedlevel_ck VALUES (edlevel IN (#39;C#39;,#39;H#39;,#39;N#39;)),

    );

  2. CREATE TABLE emp (

    empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,

    firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL,

    workdept CHAR(3), edlevel CHAR(1),

    CONSTRAINT emp_pk PRIMARY KEY(empno),

    CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno),

    CONSTRAINT edlevel_ck CHECK edlevel VALUES (#39;C#39;,#39;H#39;,#39;N#39;)

    );

  3. CREATE TABLE emp (

    empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY,

    firstname VARCHAR(30) NOTNULL, lastname VARCHAR(30) NOT NULL,

    workdept CHAR(3) NOT NULL,

    edlevel CHAR(1) CHECK IN (#39;C#39;,#39;H#39;,#39;N#39;)),

    CONSTRAINT emp_pk PRIMARY KEY (empno),

    CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES (workdept)

    );

  4. CREATE TABLE emp (

empnoSMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,

firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL,

workdept CHAR(3), edlevel CHAR(1),

CONSTRAINT emp_pk PRIMARY KEY (empno),

CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCESdepartment (deptno),

CONSTRAINT edlevel_ck CHECK (edlevel IN (#39;C#39;,#39;H#39;,#39;N#39;))

);

Answer: D

Question No: 67

Which ofthe following database objects can be used to raise an error if a table is updated?

  1. Package

  2. Trigger

  3. Stored Procedure

  4. Informational Constraint

Answer: B

Question No: 68

Which of the following will DELETE all of the rows from table T03?

  1. DELETE * FROM TABLE T03

  2. DELETE ALL FROM T03

  3. DELETE * FROM T03

  4. DELETE FROMT03

Answer: D

Question No: 69

A table was created using the following DDL:

CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9),

dept SMALLINT CHECK (dept BETWEEN 10AND 100),

job CHAR(10) CHECK (job IN (#39;Sales#39;,#39;Mgr#39;,#39;Clerk#39;)), hiredate DATE,

salary DECIMAL(7,2), comm DECIMAL(7,2), PRIMARY KEY (id),

CONSTRAINT yearsal CHECK (YEAR(hiredate) gt; 2004 OR salary gt; 80500)

);

Which of the following INSERT statements will fail?

  1. INSERT INTO employee VALUES (2, #39;Smith#39;, 80, #39;Mgr#39;, #39;09/03/2006#39;, 80000, NULL)

  2. INSERT INTO employee VALUES (4, #39;Smith#39;, 86, #39;Mgr#39;, #39;07/14/2003#39;, 90000, NULL)

  3. INSERT INTO employee VALUES (1, #39;Smith#39;, 55, #39;Sales#39;, #39;07/14/2003#39;, NULL, NULL)

  4. INSERT INTO employee VALUES (3, #39;Smith#39;, 33, #39;Analyst#39;, #39;11/26/2006#39;, 90000, NULL)

Answer: D

Question No: 70

Which of the following commandsis used to retrieve database names from the local catalog for DRDA host databases on System i and System z?

  1. LIST DB DIRECTORY

  2. LIST DCS DIRECTORY

  3. LIST NODE DIRECTORY

  4. LIST ACTIVE DATABASES

Answer: B

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