Real of C2090-730 practice question materials and interactive bootcamp for IBM certification for consumer, Real Success Guaranteed with Updated C2090-730 pdf dumps vce Materials. 100% PASS DB2 9 Family Fundamentals exam Today!


♥♥ 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

Q141. Which of the following resources can be referenced in the LOCK statement? 

A. Row 

B. Table 

C. Column 

D. Table space 

Answer: B 

Explanation: 


Q142. Given the following two tables: 

TAB1 

C1 C2 

1 Antarctica 

2 Africa 

3 Asia 

4 Australia 

TAB2 

CX CY 5 Europe 6 North America 7 South America 

Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1? 

A. INSERT INTO tab1 SELECT cx, cy FROM tab2 

B. INSERT INTO tab1 VALUES (tab2.cx, tab2.cy) 

C. INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2) 

D. INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2) 

Answer: A 

Explanation: 


Q143. Which of the following will provide user USER1 and all members of the group GROUP1 with the ability to perform DML, but no other operations on table TABLE1? 

A. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO user1 AND group1 

B. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO USER user1, GROUP group1 

C. GRANT ALL PRIVILEGES EXCEPT ALTER, INDEX, REFERENCES ON TABLE table1 TO USER user1, GROUP group1 

D. GRANT CONTROL ON TABLE table1 TO user1 AND group1 

Answer: B 

Explanation: 


Q144. A sequence was created with the DDL statement shown below: 

CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10 

User USER1 successfully executes the following statements in the order shown: 

VALUES NEXT VALUE FOR my_seq INTO :hvar; 

VALUES NEXT VALUE FOR my_seq INTO :hvar; 

User USER2 successfully executes the following statements in the order shown: 

ALTER SEQUENCE my_seq RESTART WITH 5 INCREMENT BY 5 CACHE 5; 

VALUES NEXT VALUE FOR my_seq INTO :hvar; 

After users USER1 and USER2 are finished, user USER3 executes the following query: 

SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1 

What value will be returned by the query? 

A. 5 

B. 10 

C. 20 

D. 30 

Answer: D 

Explanation: 


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

A. "<employee />" 

B. "<name>John Doe</name>" 

C. "<?xml version='1.0' encoding='UTF-8' ?>" 

D. "<p></p>" 

Answer: C 

Explanation: 


Q146. Given the following CREATE TABLE statement: 

CREATE TABLE table2 LIKE table1 

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

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

B. TABLE2 will have the same column defaults as TABLE1 

C. TABLE2 will have the same nullability characteristics as TABLE1 

D. TABLE2 will have the same indexes as TABLE1. 

E. TABLE2 will have the same referential constraints as TABLE1 

Answer: D,E 

Explanation: 

185. If the following SQL statements are executed: 

CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY, 

name VARCHAR(25)); 

CREATE TABLE tab2 (empid SMALLINT, 

weekno SMALLINT, 

payamt DECIMAL(6,2), 

CONSTRAINT const1 FOREIGN KEY (empid) 

REFERENCES taba(id) ON UPDATE NO ACTION); 

Which of the following statements is true? 

A. Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2 

B. The updating of values in the ID column of table TAB1 is not allowed 

C. Only values that do not already exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2 

D. When values that exist in the ID column of table TAB1 are updated, corresponding values in the EMPID column of table TAB2 are updated as well 

Answer: A 

Explanation: 


Q147. Which of the following commands is used to retrieve database names from the local catalog for DRDA host databases on System i and System z? 

A. LIST DB DIRECTORY 

B. LIST DCS DIRECTORY 

C. LIST NODE DIRECTORY 

D. LIST ACTIVE DATABASES 

Answer: B 

Explanation: 


Q148. Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM? 

A. REVOKE ACCESS ON DATABASE FROM USER bob 

B. REVOKE CONNECT ON DATABASE FROM USER tom 

C. REVOKE tom FROM ACCESS ON DATABASE BY USER bob 

D. REVOKE tom FROM CONNECT ON DATABASE BY USER bob 

Answer: B 

Explanation: 


Q149. If the following SQL statements are executed: 

CREATE TABLE make (makeid SMALLINT NOT NULL PRIMARY KEY, make VARCHAR(25)); 

CREATE TABLE model (modelid SMALLINT, model VARCHAR(25), makeid SMALLINT, CONSTRAINT const1 FOREIGN KEY (makeid) REFERENCES make(makeid) ON DELETE RESTRICT); 

And each table created is populated as follows: 

MAKE 

MAKEID MAKE 

1 Ford 2 Chevrolet 3 Toyota 

MODEL 

MODELID MODEL MAKEID 1 Mustang 1 2 Escort 1 3 Malibu 2 4 Camry 3 

If the following SQL statement is executed: 

DELETE FROM make WHERE makeid = 1 

What is the total number of rows that will be deleted? 

A. 0 

B. 1 

C. 2 

D. 3 

Answer: A 

Explanation: 


Q150. Which of the following is NOT true about schemas? 

A. If a schema name is not specified, either by qualifying a database object name or by executing the SET CURRENT SCHEMA statement, the authorization ID of the current session user is used as the schema name by default 

B. The value assigned to the CURRENT SCHEMA special register is persistent across database restarts 

C. A schema enables the creation of multiple objects in a database without encountering namespace collisions 

D. When most database objects are created, they are either implicitly or explicitly assigned to a schema 

Answer: B 

Explanation: