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

Which of the following SQL statements will return the year and average salary for allemployees hired within a given year that have a salary greater than $30,000?

  1. SELECT * FROM t1 UNION

    SELECT * FROM t2

  2. SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2

  3. SELECT * FROM t1 INTERSECT

    SELECT * FROM t2

  4. SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)

Answer: B

Question No: 162

A sequence was created with the DDL statement shown below:

CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5

User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FORmy_seq INTO :con1hvar

VALUES NEXT VALUE FOR my_seq INTO :con1hvar

User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar

After User1 amp; User2 are finished, User3 executes the following statement in Connection3: SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1

Which value will be returned by the query?

  1. 20

  2. 25

  3. 50

  4. 55

Answer: D

Question No: 163

Which of the following best describes a unit of work?

  1. It is a recoverable sequence of operations whose point of consistency is established when aconnection to a database has been established or when a mechanism known as a savepoint is created.

  2. It is a recoverable sequence of operations whose current point of consistency can be determined by querying the system catalog tables.

  3. It is a recoverable sequence of operations whose point of consistency is established when an executable SQL statement is processed after a connection to a database has been established or a previous transaction has been terminated.

  4. It is a recoverable sequence of operations whose point of consistency is only established if a mechanism known as a savepoint is created.

Answer: C

Question No: 164

ESTION NO:181

Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?

  1. quot;lt;employee /gt;quot;

  2. quot;lt;namegt;John Doelt;/namegt;quot;

  3. quot;lt;?xml version=#39;1.0#39; encoding=#39;UTF-8#39; ?gt;quot;

D. quot;lt;pgt;lt;/pgt;quot;

Answer: C

Question No: 165

Given the following table:

CURRENT_EMPLOYEES

————-

EMPID INTEGER NOT NULL NAME CHAR(20)

SALARY DECIMAL(10,2)

PAST_EMPLOYEES

————-

EMPID INTEGER NOT NULL NAME CHAR(20)

SALARY DECIMAL(10,2)

Assuming both tables contain data, which of the following statements will NOT successfully add data to table CURRENT_EMPLOYEES?

  1. INSERT INTO current_employees (empid) VALUES (10)

  2. INSERT INTO current_employees VALUES (10, #39;JAGGER#39;, 85000.00)

  3. INSERT INTO current_employees SELECT empid, name, salary FROM past_employees WHERE empid = 20

  4. INSERT INTO current_employees (name, salary) VALUES (SELECT name, salary FROM past_employees WHERE empid = 20)

Answer: D

Question No: 166

Application A is designed to execute the followingSQL statements within a single Unit of Work (UOW).

UPDATE employee SET salary = salary * 1.1 WHERE empno=#39;000010#39; UPDATE department SET deptname = #39;NEW dept#39; WHERE deptno=#39;A00#39;

Application B is designed to execute the following SQL statements within a single Unit of Work (UOW).

UPDATE department SET deptname = #39;OLD DEPT#39; WHERE deptno=#39;A00#39; UPDATE employee SET salary = salary * 0.5 WHERE empno=#39;000010#39;

Application A and application B execute their first SQL statement at the same time. When application Aand application B try to execute their second SQL statement, a deadlock occurs. What will happen?

  1. The database manager will rollback the transaction in both applications.

  2. The database manager will rollback the transaction in one of the two applications.

  3. Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.

  4. Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.

Answer: B

Question No: 167

A quot;trustedquot; client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be usedto verify passwords?

  1. User ID/password file

  2. Communications layer

  3. Client applications

  4. Operating system

Answer: D

Question No: 168

A declared temporary table is used for which of the following purposes?

  1. Backup purposes

  2. Storing intermediate results

  3. Staging area for load operations

  4. Sharing result data sets between applications

Answer: B

Question No: 169

An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection.The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement:

CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT)

Which of the following SQL statements will provide the table definition that meets the specified requirements?

  1. DECLARE GLOBAL TEMPORARY TABLE tracker

    AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS

    ON DISCONNECT DROP TABLE

  2. DECLARE GLOBAL TEMPORARY TABLE tracker

    AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS

  3. CREATE TABLE systmp.tracker

    AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS

  4. CREATE TABLE tracker

AS (SELECTitem_num, item_name FROM items) ON COMMIT PRESERVE ROWS

ON DISCONNECT DROP TABLE

Answer: B

Question No: 170

Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?

  1. DB2 Express-C

  2. DB2 Express

  3. DB2 Personal Edition

  4. DB2 Enterprise Server Edition

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