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

Consider the following table called EMPLOYEES:

ID FIRSTNAME LASTNAME JOB LEVEL

——————————

  1. Paul Jones DBA 2

  2. George Baker MGR 1

  3. Roger Melvin CLERK 3 4 Jim Smith MGR1

  1. Kevin Street CLERK 3

  2. Chris Eaton MGR 1

If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1

  1. 0

  2. 1

  3. 3

  4. 6

Answer: D

Question No: 72

Given the following table definitions:

EMPLOYEES

———————— EMPID INTEGER

NAME CHAR(20) DEPTID CHAR(3) SALARY DECIMAL(10,2)

COMMISSION DECIMAL(8,2) DEPARTMENTS

———————— DEPTNO INTEGER

DEPTNAME CHAR(20)

Which of the following statements will produce a result data set that satisfies all of these conditions:

gt;Displays the total number of employees in each department

gt;gt; Displays the corresponding department name for each department ID

gt;gt; Sorted by department employee count, from greatest to least

  1. SELECT *, COUNT(empno) FROM departments, employees WHEREdeptid = deptno GROUP BY deptname ORDER BY 2 DESC

  2. SELECT deptname, COUNT(empno) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2 DESC

  3. SELECT deptname, COUNT(empno) FROM departments, employees WHERE deptid = deptno GROUPBY deptname ORDER BY 2 ASC

  4. SELECT deptname, COUNT(*) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2

Answer: B

Question No: 73

Whileattempting to connect to a database stored on an iSeries server from a Windows client, the following message was displayed:

SQL1013N The database alias name or database name quot;TEST_DBquot; could not be found.

Which of the following actions can be used to help determine why this message was displayed?

  1. Execute the LIST REMOTE DATABASES command on the server; look for an entry for the TEST_DB database

  2. Execute the LIST DCS DIRECTORY command on the server; look for an entry for the TEST_DB database

  3. Executethe LIST REMOTE DATABASES command on the client; look for an entry for the TEST_DB database

  4. Execute the LIST DCS DIRECTORY command on the client; look for an entry for the TEST_DB database

Answer: D

Question No: 74

Which of the following DB2 data types can be used tostore 1000 MB of single-byte character data?

  1. BLOB

  2. CLOB

  3. DBCLOB

  4. GRAPHIC

Answer: B

Question No: 75

An application needs to store a 5 MBJPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?

  1. GRAPHIC

  2. BINARY

  3. IMAGE

  4. BLOB

Answer: D

Question No: 76

Given the following table definitions:

TABLE1

—————— ID INT

NAME CHAR(30) PERSON INT CITIES INT TABLE2

—————— ID INT

LASTNAME CHAR(30)

Which of the following statements will remove all rows in table TABLE1 that have matching PERSONs in table TABLE2?

  1. DELETE FROM table1 WHERE id IN (SELECT id FROM table2)

  2. DELETE FROM table1 WHERE id IN (SELECT person FROMtable2)

  3. DELETE FROM table1 WHERE person IN (SELECT id FROM table2)

  4. DELETE FROM table1 WHERE person IN (SELECT person FROM table2)

Answer: C

Question No: 77

Given the following table: TEMP_DATA

TEMP DATE

— —

45 12/25/2006

51 12/26/2006

67 12/27/2006

72 12/28/2006

3412/29/2006

42 12/30/2006

And the following SQL statement:

CREATE FUNCTION degf_to_c (temp INTEGER) RETURNS INTEGER

LANGUAGE SQL CONTAINS SQL

NO EXTERNAL ACTION DETERMINISTIC BEGIN ATOMIC

DECLARE newtemp INTEGER; SET newtemp = temp – 32; SET newtemp = newtemp * 5; RETURN newtemp / 9;

END

Which two of the following SQL statements illustrate the proper way to invoke the scalar function DEGF_TO_C?

  1. VALUES degf_to_c(32)

  2. SELECT date,degf_to_c(temp) AS temp_c FROM temp_data

  3. CALL degf_to_c(32)

  4. SELECT * FROM TABLE(degf_to_c(temp)) AS temp_c

  5. VALUES degf_to_c(32) AS temp_c

Answer: A,B

Question No: 78

Which of thefollowing DB2 data types does NOT have a fixed length?

  1. INT

  2. CHAR

  3. XML

  4. DOUBLE

Answer: C

Question No: 79

Which of the following DB2 objects is NOT considered executable using SQL?

  1. Routine

  2. Function

  3. Procedure

  4. Trigger

Answer: D

Question No: 80

Which of the following statements allows USER1 to take away read access on thetable ORG.TAB1 from USER2?

  1. REVOKE SELECT FROM user2 ON TABLE org.tab1

  2. REVOKE SELECT ON TABLE org.tab1 FROM user2

  3. REVOKE READ ACCESS FROM user2 ON TABLE org.tab1

  4. REVOKE READ ACCESS ON TABLE org.tab1 FROM user2

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