Verified of C2090-730 training materials and discount pack for IBM certification for IT examinee, Real Success Guaranteed with Updated C2090-730 pdf dumps vce Materials. 100% PASS DB2 9 Family Fundamentals exam Today!
2021 May C2090-730 Study Guide Questions:
Q81. Which of the following isolation levels will lock all rows scanned to build a result data set?
A. Uncommitted Read
B. Cursor Stability
C. Read Stability
D. Repeatable Read
Answer: D
Explanation:
Q82. Which of the following best describes the difference between the DB2 Spatial Extender and the DB2 Geodetic Extender?
A. The DB2 Spatial Extender uses a latitude-longitude coordinate system; the DB2 Geodetic Extender uses a planar, x- and y-coordinate system
B. The DB2 Geodetic Extender is used to describe points, lines, and polygons; the DB2 Spatial Extender is used to find area, endpoints, and intersects
C. The DB2 Spatial Extender treats the world as a flat map; the DB2 Geodetic Extender treats the world as a round globe
D. The DB2 Geodetic Extender can be used to manage information like the locations of office buildings or the size of a flood zone; the DB2 Spatial Extender can be used for calculations and visualizations in disciplines like military command/control and asset management, meteorology and oceanography
Answer: C
Explanation:
Q83. Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?
A. DB2 for z/OS
B. DB2 Run-Time Client for z/OS
C. DB2 Connect Enterprise Edition for z/OS
D. z/OS Application Connectivity to DB2 for z/OS and OS/390
Answer: A
Explanation:
Improve C2090-730 practice exam:
Q84. Given the following requirements:
Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the identity column to generate the values for the column by default. Start the values at 10 and increment by 10. Make the identity column unique.
Which of the following CREATE statements will successfully create this table?
A. CREATE TABLE TESTTAB
(ACTIVITYNO SMALLINT NOT NULL
GENERATED ALWAYS AS IDENTITY
(START WITH 10
INCREMENT BY 10),
ACTKWD CHAR(6) NOT NULL,
ACTDESC VARCHAR(20) NOT NULL,
UNIQUE(ACTIVITYNO))
B. CREATE TABLE TESTTAB
(ACTIVITYNO SMALLINT NOT NULL
GENERATED ALWAYS AS IDENTITY
(START WITH 1
INCREMENT BY 10),
ACTKWD CHAR(6) NOT NULL,
ACTDESC VARCHAR(20) NOT NULL,
UNIQUE(ACTNO))
C. CREATE TABLE TESTTAB
(ACTIVITYNO SMALLINT NOT NULL
GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 1),
ACTKWD CHAR(6) NOT NULL,
ACTDESC VARCHAR(20) NOT NULL,
UNIQUE(ACTIVITYNO))
D. CREATE TABLE TESTTAB
(ACTIVITYNO SMALLINT NOT NULL
GENERATED BY DEFAULT AS IDENTITY
(START WITH 10
INCREMENT BY 10),
ACTKWD CHAR(6) NOT NULL,
ACTDESC VARCHAR(20) NOT NULL,
UNIQUE(ACTIVITYNO))
Answer: D
Explanation:
Q85. 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:
Q86. Application A holds a lock on a row in table TAB1. If lock timeout is set to 20, what will happen when Application B attempts to acquire a compatible lock on the same row?
A. Application B will acquire the lock it needs
B. Application A will be rolled back if it still holds its lock after 20 seconds have elapsed
C. Application B will be rolled back if Application A still holds its lock after 20 seconds have elapsed
D. Both applications will be rolled back if Application A still holds its lock after 20 seconds have elapsed
Answer: A
Explanation:
Verified C2090-730 torrent:
Q87. 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:
Q88. 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:
Q89. Which of the following statements allows user USER1 to take the ability to create packages in a database named SAMPLE away from user USER2?
A. REVOKE CONNECT ON DATABASE FROM user2
B. REVOKE CREATETAB ON DATABASE FROM user2
C. REVOKE BIND ON DATABASE FROM user2
D. REVOKE BINDADD ON DATABASE FROM user2
Answer: D
Explanation:
Q90. Given the following table definition:
EMPLOYESS
EMP ID INTEGER
NAME CHAR(20)
DEPT CHAR(10)
SALARY DECIMAL (10, 2)
COMMISSION DECIMAL (8, 2)
Assuming the DEPT column contains the values ‘ADMIN’, ‘PRODUCTION’, and ‘SALES’, which of the following statements will produce a result data set in which all ADMIN department employees are grouped together, all PRODUCTION department employees are grouped together, and all SALES department employees are grouped together?
A. SELECT name, dept FROM employees ORDER BY dept
B. SELECT name, dept FROM employees GROUP BY dept
C. SELECT name, dept FROM employees GROUP BY ROLLUP (dept)
D. SELECT name, dept FROM employees GROUP BY CUBE (dept)
Answer: A
Explanation: