High quality of C2090-730 practice exam materials and software for IBM certification for 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:
Q111. 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:
Q112. A view is created with the following statement:
CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ;
When will DB2 access the data from table T1 for view V1?
A. When view V1 is created
B. Each time the REFRESH VIEW v1 statement is executed
C. Each time an SQL statement is executed against view V1
D. Only the first time an SQL statement is executed against view V1
Answer: C
Explanation:
Q113. Which of the following is a typical data warehouse query?
A. What is this customer’s address?
B. Does this customer have any unpaid bills?
C. What is the balance in this customers account?
D. What are the total sales for each of the last 6 months?
Answer: D
Explanation:
Regenerate C2090-730 exam price:
Q114. Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?
A. REVOKE ALL PRIVILEGES FROM USER tom
B. REVOKE ALL ON EMPLOYEE FROM USER tom
C. REVOKE EXECUTE ON EMPLOYEE FROM USER tom
D. REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
Answer: B
Explanation:
Q115. User USER1 has the privileges needed to invoke a stored procedure named GEN_RESUME. User USER2 needs to be able to call the procedure - user USER1 and all members of the group PUBLIC should no longer be allowed to call the procedure. Which of the following statement(s) can be used to accomplish this?
A. GRANT EXECUTE ON ROUTINE gen_resume TO user2 EXCLUDE user1, PUBLIC
B. GRANT EXECUTE ON PROCEDURE gen_resume TO user2;
REVOKE EXECUTE ON PROCEDURE gen_resume FROM user1, PUBLIC;
C. GRANT CALL ON ROUTINE gen_resume TO user2 EXCLUDE user1 PUBLIC
D. GRANT CALL ON PROCEDURE gen_resume TO user2;
REVOKE CALL ON PROCEDURE gen_resume FROM user1, PUBLIC;
Answer: B
Explanation:
Q116. Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?
A. The cursor is only protected from updates and deletes by concurrent applications.
B. The row is only protected from positioned updates and deletes that reference another cursor of the same application.
C. The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
D. The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.
Answer: A
Explanation:
High quality C2090-730 :
Q117. Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?
A. DB2 Express Edition
B. DB2 Personal Edition
C. DB2 Workgroup Server Edition
D. DB2 Enterprise Server Edition
Answer: D
Explanation:
Q118. Which of the following DB2 products are required on an iSeries or System I server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?
A. DB2 for i5/OS
B. DB2 Runtime Client
C. DB2 Connect Enterprise Edition
D. DB2 for i5/OS SQL Development Kit
Answer: A
Explanation:
Q119. Which of the following describes the model used by the Geodetic Extender?
A. Flat earth
B. 3-D Square
C. Trapezoidal
D. Round earth
Answer: D
Explanation:
Q120. Given the following statement:
SELECT hyear, AVG(salary)
FROM (SELECT YEAR(hiredate) AS hyear, salary
FROM employee WHERE salary > 30000)
GROUP BY hyear
Which of the following describes the result if this statement is executed?
A. The statement will return the year and average salary for all employees that have a salary greater than $30,000, sorted by year.
B. The statement will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000.
C. The statement will return the year and average salary for all years that every employee hired had a salary greater than $30,000.
D. The statement will return the year and average salary for all years that any employee had a salary greater than $30,000.
Answer: B
Explanation: