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

If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?

  1. COL1 will accept NULL values and can be referenced in another table#39;s foreign keyspecification.

  2. COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.

  3. COL1 will not accept NULL values and can be referenced in another tables foreign key specification.

  4. COL1 will accept NULL valuesand cannot be referenced in another tables foreign key specification.

Answer: C

Question No: 172

Which of the following DB2 tools allows a user to set DB2 registry parameters?

  1. Task Center

  2. Visual Explain

  3. Configuration Assistant

  4. Satellite Administration Center

Answer: C

Question No: 173

ION NO:203

A view is created with the following statement: CREATE VIEW v1

AS SELECT col1, col2, col3, col4 FROM t1

WHERE col4 gt;1000 WITH CHECK OPTION

What is the effect of the CHECK OPTION clause?

  1. Any row inserted or updated through view V1 must meet the condition that col4 gt; 1000.

  2. From now on, any row inserted or updated in table T1 must meet the condition that col4

    gt; 1000, but existing rows in the table are not checked.

  3. At view creation, DB2 will check the data in table T1, and if in any row doesn#39;t meet the condition col4 gt; 1000, the view creation will be rejected.

  4. Any row inserted or updated through view V1 mustmeet the condition that col4 gt; 1000 and no row in table T1 can be updated such that col4 lt;= 1000, but new rows in the table can be inserted with col4 lt;= 1000.

Answer: A

Question No: 174

Given the following CREATE TABLE statement: CREATE TABLE table2 LIKEtable1

Which two of the following will NOT occur when the statement is executed?

  1. TABLE2 will have the same column names and column data types as TABLE1

  2. TABLE2 will have the same column defaults as TABLE1

  3. TABLE2 will have the same nullability characteristics as TABLE1

  4. TABLE2 will have the same indexes as TABLE1.

  5. TABLE2 will have the same referential constraints as TABLE1

Answer: D,E

Question No: 175

Which of the following is an accurate statementabout packages?

  1. Packages provide a logical grouping of database objects.

  2. Packages contain control structures that are considered the bound form for SQL statements

  3. Packages describe the objects in a DB2 database and their relationship to each other

  4. Packages may be used during query optimization to improve the performance for a subset of SELECT queries

Answer: B

Question No: 176

Which of the following aretypes of routine objects?

  1. Package and function

  2. Function and userexit

  3. Procedure and package

  4. Function and procedure

Answer: D

Question No: 177

After the following SQL statement is executed:

GRANT ALL PRIVILEGES ON TABLE employee TO USER user1

Assuming user USER1 has no other authorities or privileges, which of the following actions is user USER1 allowed to perform?

  1. Drop an index on the EMPLOYEE table

  2. Grant all privileges on the EMPLOYEE table to other users

  3. Alter the table definition

  4. Drop the EMPLOYEE table

Answer: C

Question No: 178

Whichof the following causes a lock that is being held by an application using the Cursor Stability isolation level to be released?

  1. The cursor is moved to another row

  2. The row the cursor is on is deleted by the application

  3. The row the cursor is on isdeleted by another application

  4. The row the cursor is on needs to be updated by another application

Answer: A

Question No: 179

A stored procedure has been created with the followingstatement:

CREATE PROCEDURE proc1 (IN var1 VARCHAR(10), OUT rc INTEGER) SPECIFIC myproc LANGUAGE SQL …

What is the correct way to invoke this procedure from the command line processor (CLP)?

  1. CALL proc1 (#39;SALES#39;, ?)

  2. CALL myproc (#39;SALES#39;, ?)

  3. CALLproc1 (SALES, ?)

  4. RUN proc1 (SALES, ?)

Answer: A

Question No: 180

57 Given table T1 has column I1 containing the following data: I1

— 1

2

3

4

If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S

AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3;

SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS; INSERT INTO t1 (i1) VALUES (6);

ROLLBACK TOSAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT;

What is the expected sequence of values returned from? SELECT i1 FROM t1 ORDER BY i1

A. 1, 2, 3, 3

B. 1, 2, 2, 4

C. 1, 2, 3, 3, 6

D. 1, 2, 2, 5, 6

Answer: A

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