Act now and download your IBM C2090-730 test today! Do not waste time for the worthless IBM C2090-730 tutorials. Download Update IBM DB2 9 Family Fundamentals exam with real questions and answers and begin to learn IBM C2090-730 with a classic professional.


♥♥ 2021 NEW RECOMMEND ♥♥

Free VCE & PDF File for IBM C2090-730 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW C2090-730 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/C2090-730-exam-dumps.html

Q161. Which of the following can NOT be used to restrict specific values from being inserted into a column in a particular table? 

A. Index 

B. Check constraint 

C. Referential constraint 

D. Default constraint 

Answer: D 

Explanation: 


Q162. Given the following CREATE TABLE statement: 

CREATE TABLE EMPLOYEE 

(EMPNO CHAR(3) NOT NULL, 

FIRSTNAME CHAR(20) NOT NULL, 

MIDINIT CHAR(1), 

LASTNAME CHAR(20) NOT NULL, 

SALARY DECIMAL(10, 2)) Which of the following will retrieve the rows that have a missing value in the MIDINIT column? 

A. SELECT * FROM employee WHERE midinit = ' ' 

B. SELECT * FROM employee WHERE midinit = NULL 

C. SELECT * FROM employee WHERE midinit = " " 

D. SELECT * FROM employee WHERE midinit IS NULL 

Answer: D 

Explanation: 


Q163. Which of the following tools can NOT be used to catalog a database? 

A. Control Center 

B. SQL Assist 

C. Configuration Assistant 

D. Command Line Processor 

Answer: B 

Explanation: 


Q164. What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column? 

A. Check 

B. Range 

C. Referential 

D. Informational 

Answer: A 

Explanation: 


Q165. Given the following statements: 

CREATE TABLE table1 (col1 INTEGER, col2 CHAR(3)); 

CREATE VIEW view1 AS SELECT col1, col2 FROM table1 WHERE col1 < 100 WITH LOCAL CHECK OPTION; 

Which of the following INSERT statements will execute successfully? 

A. INSERT INTO view1 VALUES (50, abc) 

B. INSERT INTO view1 VALUES(100, abc) 

C. INSERT INTO view1 VALUES(50, 'abc') 

D. INSERT INTO view1 VALUES(100, 'abc') 

Answer: C 

Explanation: 


Q166. Application A holds an Exclusive lock on table TAB1 and needs to acquire an Exclusive lock on table TAB2. Application B holds an Exclusive lock on table TAB2 and needs to acquire an Exclusive lock on table TAB1. If lock timeout is set to -1 and both applications are using the Read Stability isolation level, which of the following will occur? 

A. Applications A and B will cause a deadlock situation 

B. Application B will read the copy of table TAB1 that was loaded into memory when Application A first read it 

C. Application B will read the data in table TAB1 and see uncommitted changes made by Application A 

D. Application B will be placed in a lock-wait state until Application A releases its lock 

Answer: A 

Explanation: 


Q167. When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true? 

A. The list of column names in the FOREIGN KEY clause can be a subset of the list of columnnames in the primary key of T2 or a UNIQUE constraint that exists on T2. 

B. The list of column names in the FOREIGN KEY clause can be a subset of the list of columnnames in the primary key of T1 or a UNIQUE constraint that exists on T1. 

C. The list of column names in the FOREIGN KEY clause must be identical to the list of columnnames in the primary key of T2 or a UNIQUE constraint that exists on T2. 

D. The list of column names in the FOREIGN KEY clause must be identical to the list of columnnames in the primary key of T1 or a UNIQUE constraint that exists on T1. 

Answer: C 

Explanation: 


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

UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' 

UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00' 

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

UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' 

UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' 

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

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

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

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

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

Answer: B 

Explanation: 


Q169. Assuming USER1 has no authorities or privileges, which of the following will allow USER1 to create a view named VIEW1 that references two tables named TAB1 and TAB2? 

A. CREATEIN privilege on the database 

B. REFERENCES privilege on TAB1 and TAB2 

C. CREATE_TAB privilege on the database 

D. SELECT privilege on TAB1 and TAB2 

Answer: D 

Explanation: 


Q170. 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 TO SAVEPOINT 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 

Explanation: