최신 DB2 A2090-730 무료샘플문제:
1. Which of the following products must be installed on an AIX server in order to build an application for AIX that will access a DB2 for z/OS database?
A) DB2 Universal DatabaseEnterprise Edition and DB2 Connect Enterprise Edition
B) DB2 Universal Developer's Edition
C) DB2Enterprise Server Edition
D) DB2 Personal Developer's Edition
2. 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 view1VALUES(100, abc)
C) INSERT INTO view1VALUES(100, 'abc')
D) INSERT INTO view1VALUES(50, 'abc')
3. Which of the following modes, when used with the LOCK TABLE statement, will cause the DB2 Database Manager to acquire a table-level lock that prevents other concurrent transactions from accessing data stored in the table while the owning transaction is active?
A) SHARE MODE
B) EXCLUSIVE MODE
C) RESTRICT MODE
D) ISOLATED MODE
4. 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
5. Which of the following will allow user USER1 to change the comment associated with a table named TABLE1?
A) GRANT ALTER ON TABLE table1 TO user1
B) GRANT UPDATE ON TABLE table1 TO user1
C) GRANT CONTROL ON TABLE table1 TO user1
D) GRANT REFERENCES ON TABLE table1 TO user1
질문과 대답:
| 질문 # 1 정답: B | 질문 # 2 정답: D | 질문 # 3 정답: B | 질문 # 4 정답: B | 질문 # 5 정답: A |
1043 개 고객 리뷰
품질과 가치ITCertKR 의 높은 정확도를 보장하는 최고품질의 덤프는 IT인증시험에 대비하여 제작된것으로서 높은 적중율을 자랑하고 있습니다.
테스트 및 승인ITCertKR 의 덤프는 모두 엘리트한 전문가들이 실제시험문제를 분석하여 답을 작성한 만큼 시험문제의 적중률은 아주 높습니다.
쉽게 시험패스ITCertKR의 테스트 엔진을 사용하여 시험을 준비한다는것은 첫 번째 시도에서 인증시험 패스성공을 의미합니다.
주문하기전 체험ITCertKR의 각 제품은 무료 데모를 제공합니다. 구입하기로 결정하기 전에 덤프샘플문제로 덤프품질과 실용성을 검증할수 있습니다.
