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

Given the statement:

CREATE TABLE tablea (col1 INTEGER NOT NULL, CONSTRAINT const1 CHECK (col1 in (100, 200, 300))

Which of the following can be inserted into TABLEA?

  1. 0

  2. NULL C. 100 D. #39;100#39;

Answer: C

Question No: 132

Which of the following products is allowed to access other DB2 servers, but cannot accept requests from otherremote clients?

  1. DB2 Personal Edition

  2. DB2 Workgroup Server Edition

  3. DB2 Enterprise Server Edition

  4. DB2 Data Warehouse Edition

Answer: A

Question No: 133

Which of the following scenarios will ensure that the value of theNEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?

  1. Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.

  2. Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).

  3. Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as

    a foreign key referencing column STEPNO of the same table.

  4. Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.

Answer: C

Question No: 134

Which of thefollowing statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?

  1. GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp

  2. GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1

  3. GRANT INSERT ON TABLE tab1 TOUSER tom, GROUP appgrp

  4. GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom

Answer: C

Question No: 135

In which of the following situations would DB2 retain resources associated with a transaction at COMMIT time?

  1. A cursor is defined as WITH HOLD.

  2. Another user executes the same transaction.

  3. The application program amends during COMMIT.

  4. The transaction terminates abnormallyduring COMMIT.

Answer: A

Question No: 136

When does a view get populated?

  1. When it is created

  2. Whenit is referenced in an INSERT statement

  3. The first time any executable SQL statement references it

  4. Any time an executable SQL statement references it

Answer: D

Question No: 137

What is the SQL Performance Monitor used for?

  1. To examine the health of a DB2 Database Manager instance

  2. To visually construct complex DML statements and examine the results of their execution

  3. To schedule tasks, run tasks, and send notifications about completed tasks to other users

  4. To analyze database operations performed against a DB2 for i5/OS database

Answer: D

Question No: 138

CREATE TABLE customer (cid BIGINT NOT NULL PRIMARY KEY, info XML)

How many names will be returned for this XQuery?

  1. 0

  2. 1

  3. 2

  4. 3

Answer: C

Question No: 139

A database named TEST_DB resides ona z/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.20 and the TCP/IP host name is MYHOST. Which of the following commands is required to make this database accessible to a Linux client?

  1. CATALOG TCPIP NODE zos_srvrREMOTE myhost SERVER 192.168.10.20; CATALOG DATABASE zos_db AS test_db AT NODE zos_srvr;

    CATALOG DCS DATABASE zos_db AS test_db;

  2. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 192.168.10.20; CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;

  3. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 446; CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;

  4. CATALOG TCPIP NODE zos_srvr REMOTE myhost SERVER 446; CATALOG DATABASE zos_db AS test_db AT NODE zos_srvr; CATALOG DCS DATABASE zos_db AS test_db;

Answer: C

Question No: 140

If the following SQL statement is executed:

CREATE TABLE sales

(invoice_no NOT NULL PRIMARY KEY, sales_date DATE,

sales_amt NUMERIC(7,2)) IN tbsp0, tbsp1, tbsp2, tbsp3

PARTITION BY RANGE (sales_date NULLS FIRST) (STARTING #39;1/1/2007#39; ENDING #39;12/31/2007#39; EVERY 3 MONTHS)

Which of the following statements is true?

  1. Administrative tasks such as backing up, restoring, and reorganizing data stored in the SALES table must be done at the table level; not at the partition level

  2. Data can be quickly rolled in and out of the SALES table by using the ATTACH PARTITION and DETACH PARTITION clauses of the ALTER TABLE statement

  3. If an index is created for the SALES table, its data must be stored in table space TBSP0

  4. When resolving queries against the SALES table, each partition used is scanned asynchronously and the resultsof each partition scan are merged to produce the result data set returned

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