Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-543
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-543.html

DB2 9.7 Application Development

Question No: 11 – (Topic 1)

Click the Exhibit button.

CREATE TABLE store(sid INTEGER, info XML); INSERT INTO store VALUES (1,

#39;lt;storeinfo sid=quot;1quot;gt;

lt;namegt;Grocery Alt;/namegt;

lt;itemsgt;

lt;fruitgt;lt;namegt;Mangolt;/namegt;lt;pricegt;1.20lt;/pricegt;lt;/fruitgt;

lt;fruitgt;lt;namegt;Applelt;/namegt;lt;pricegt;0.50lt;/pricegt;lt;/fruitgt;

lt;dessertgt;lt;namegt;Ice Creamlt;/namegt;lt;pricegt;6.00lt;/pricegt;lt;/dessertgt;

lt;/itemsgt;

lt;/storeinfogt;#39;);

Given the statements shown in the exhibit, a user executes the query shown below: XQUERY for $store in db2-fn:xmlcolumn(#39;STORE.INFO#39;)/storeinfolet $items :=

$store/items/fruit, $count := fn:count($items) return lt;itemcountgt;$countlt;/itemcountgt; What is the output?

  1. 2

  2. lt;itemcountgt;2lt;/itemcountgt;

  3. lt;itemcountgt;1lt;/itemcountgt;

  4. lt;itemcountgt;$countlt;/itemcountgt;

Answer: D

Question No: 12 – (Topic 1)

Table T1 and view V1 were created by executing the statements shown below: CREATE TABLE t1 (c1 INT CHECK (c1 lt; 275), c2 CHAR(3));

CREATE VIEW v1 AS SELECT c1, c2 FROM t1 WHERE c1 gt; 250 WITH LOCAL CHECK OPTION;

Which statement will execute successfully?

  1. INSERT INTO t1 VALUES (275, #39;abc#39;)

  2. INSERT INTO t1 VALUES (260, #39;abc#39;)

  3. INSERT INTO v1 VALUES (250, #39;abc#39;)

  4. INSERT INTO v1 VALUES (NULL, abc)

Answer: B

Question No: 13 – (Topic 1)

The table shown below contains a large number of financial transactions:

CREATE TABLE webstore.transactions (transaction_id INTEGER NOT NULL PRIMARY KEY, order_date TIMESTAMP NOT NULL, shipped_date TIMESTAMP, customer_id INTEGER NOT NULL, shipping_info XML NOT NULL, billing_info XML NOT NULL, invoice XML NOT NULL )

Only members of the AUDIT_TEAM group have SELECT privilege on the WEBSTORE.TRANSACTIONS table. For appropriate supply-chain management, members of the INVENTORY_CONTROL group need to see the INVOICE document for each transaction that has a NULL SHIPPED_DATE, but are restricted from seeing any shipping or billing information.

Which database object can a member of the AUDIT_TEAM group create to enable the INVENTORY_CONTROL group to access the information needed from WEBSTORE.TRANSACTIONS?

  1. alias

  2. sequence

  3. trigger

  4. view

Answer: D

Question No: 14 – (Topic 1)

Given the two tables shown below: TAB1

LETTER GRADE A 80

B 70

C 60 TAB2

LETTER GPA A 4

C 2

D 1

and the successful execution of the following query:

SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON tab1.letter = tab2.letter; How many rows will be returned?

  1. 1

  2. 2

  3. 3

  4. 4

Answer: C

Question No: 15 – (Topic 1)

Which condition will prevent a developer from using the DB2 Call Level Interface in an application?

  1. The developer must control the cursor names to comply with company naming standards.

  2. An SQL precompiler is not available to the developer.

  3. The application must create an external scalar function with the CREATE FUNCTION statement.

  4. The DECLARE CURSOR statement needs to be used.

Answer: D

Question No: 16 – (Topic 1)

Which object can be created to group together related procedures and user-defined functions that are used for tax calculations?.

  1. collection

  2. module

  3. routine

  4. routine space

Answer: B

Question No: 17 – (Topic 1)

A database contains a table and a view declared as shown below: CREATE TABLE s1.t1 ( c1 INTEGER, c2 CHAR(20) );

CREATE VIEW s1.v1 AS SELECT * FROM s1.t1;

A system administrator successfully executes the following code: GRANT CONNECT, IMPLICIT_SCHEMA ON DATABASE TO user1; GRANT INSERT ON TABLE s1.t1 TO user1;

GRANT CONTROL ON s1.v1 TO user1;

Which SQL statement does user USER1 have privileges to execute?

  1. UPDATE s1.t1 SET c1 = 2 WHERE c1 IS NULL

  2. CREATE VIEW user1.v2 AS SELECT * FROM s1.v1

  3. CREATE PUBLIC ALIAS a1 FOR s1.v1

  4. SELECT * FROM s1.t1 WHERE c2 lt; 100

Answer: B

Question No: 18 – (Topic 1)

For which two database objects can an ALIAS be created? (Choose two.)

  1. schema

  2. trigger

  3. sequence

  4. module

Answer: C,D

Question No: 19 – (Topic 1)

Table T1 and views V1 and V2 were created by executing the statements shown below: CREATE TABLE t1 (c1 INT, c2 CHAR(3));

CREATE VIEW v1 AS SELECT c1, c2 FROM t1 WHERE c1 gt; 100; CREATE VIEW v2 AS SELECT * FROM v1 WHERE c2 IS NULL WITH CASCADED CHECK OPTION;

Which statement will execute successfully?

  1. INSERT INTO v2 VALUES (125, NULL)

  2. INSERT INTO v2 VALUES (125, #39;abc#39;)

  3. INSERT INTO v2 VALUES (100, NULL)

  4. INSERT INTO v2 VALUES (100, #39;abc#39;)

Answer: A

Question No: 20 – (Topic 1)

An existing table has the definition shown below:

CREATE TABLE hr.employees (empid INTEGER NOT NULL PRIMARY KEY,deptno INTEGER,authid VARCHAR(255), salary DECIMAL (10,2), commission DECIMAL (5,3) DEFAULT 0,benefits XML )

Only members of the HR_ADMIN group have privilege to SELECT, INSERT, UPDATE, or DELETE from the HR.EMPLOYEES table. A Web-based application is under development that connects to the database with a user#39;s AUTHID and enables a user to see their record. No other records are visible.

Which type of database object can be created by a member of the HR_ADMIN that provides the necessary information without changing the privileges on the HR.EMPLOYEES table?

  1. trigger

  2. view

  3. alias

  4. index

Answer: B

100% Ensurepass Free Download!
Download Free Demo:C2090-543 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-543 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.