IBM A2090-730 : Assessment: DB2 9 Family Fundamentals

ITDumpsKR의 A2090-730 자료는 PDF, Desktop Test Engine, Online Test Engine 세 가지 형태로 제공됩니다. 인쇄해 공부하든, PC에서 실전처럼 풀든, 브라우저에서 바로 응시하든 총 303문항을 원하는 방식으로 학습하실 수 있습니다.

IBM A2090-730 시험 개요:

IBM A2090-730 시험 요강 주제:

A2090-730 시험에 대해 자주 묻는 질문

최신 DB2 A2090-730 무료샘플문제

문제 #1

The EMPLOYEE table contains the following information:
EMPNO NAME WORKDEPT
101 SAM A11 102 JOHN C12 103 JANE 104 PAT Remote 105 ANNE 106 BOB A11
The MANAGER table contains the following information:
MGRID NAME DEPTNO EMPCOUNT
1 WU B01 2 JONES A11 3 CHEN - 4 SMITH - 5 THOMAS C12
After this statement is executed:
UPDATE manager m SET empcount = (SELECT COUNT(workdept) FROM employee e WHERE workdept=m.deptno)
What is the result of the following query?
SELECT mgrid, empcount FROM MANAGER WHERE empcount IS NOT NULL ORDER BY mgrid

A. MGRID EMPCOUNT ----- -------- 1 0 22 3 2 4 2 5 1
B. MGRID EMPCOUNT ----- -------- 1 3 2 33 3 4 3 5 3
C. MGRID EMPCOUNT ----- -------- 1 0 22 3 0 4 0 5 1
D. MGRID EMPCOUNT ----- -------- 1 0 22 5 1

문제 #2

Which of the following DB2 data types can NOT be used to create an identity column?

A. NUMERIC
B. INTEGER
C. DOUBLE
D. SMALLINT

문제 #3

What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?

A. A unique constraint on the EMPLOYEE table WORKDEPT column
B. A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
C. A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table
D. A check constraint on the EMPLOYEE table

문제 #4

A table called DEPARTMENT has the following columns: DEPT_ID DEPT_NAME MANAGER Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME column?

A. GRANT UPDATE ON TABLE department TO user1
B. GRANT UPDATE (dept_name) ON TABLE department TO user1
C. GRANT ALTER ON TABLE department TO user1
D. GRANT ALTER (dept_name) ON TABLE department TO user1

문제 #5

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 CALL ON PROCEDUREgen_resume TO user2;
REVOKE CALL ON PROCEDURE gen_resume FROM user1, PUBLIC;
B. GRANT EXECUTE ON ROUTINEgen_resume TO user2 EXCLUDE user1, PUBLIC
C. GRANT CALL ON ROUTINEgen_resume TO user2 EXCLUDE user1 PUBLIC
D. GRANT EXECUTE ON PROCEDUREgen_resume TO user2;
REVOKE EXECUTE ON PROCEDURE gen_resume FROM user1, PUBLIC;

질문과 대답: