최신 DB2 000-730 무료샘플문제:
1. 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) 20
B) 30
C) 5
D) 10
2. Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?
A) REVOKE tom FROM ACCESS ON DATABASE BY USER bob
B) REVOKE CONNECT ON DATABASE FROM USER tom
C) REVOKE tom FROM CONNECT ON DATABASE BY USER bob
D) REVOKE ACCESS ON DATABASE FROM USER bob
3. Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?
A) "<?xml version='1.0' encoding='UTF-8' ?>"
B) "<p></p>"
C) "<name>John Doe</name>"
D) "<employee />"
4. 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) Both applications will be rolled back if Application A still holds its lock after 20 seconds have elapsed
B) Application B will be rolled back if Application A still holds its lock after 20 seconds have elapsed
C) Application A will be rolled back if it still holds its lock after 20 seconds have elapsed
D) Application B will acquire the lock it needs
5. Which of the following causes a lock that is being held by an application using the Cursor Stability isolation level to be released?
A) The row the cursor is on is deleted by the application
B) The cursor is moved to another row
C) The row the cursor is on is deleted by another application
D) The row the cursor is on needs to be updated by another application
질문과 대답:
| 질문 # 1 정답: B | 질문 # 2 정답: B | 질문 # 3 정답: A | 질문 # 4 정답: D | 질문 # 5 정답: B |
0 개 고객 리뷰
품질과 가치ITCertKR 의 높은 정확도를 보장하는 최고품질의 덤프는 IT인증시험에 대비하여 제작된것으로서 높은 적중율을 자랑하고 있습니다.
테스트 및 승인ITCertKR 의 덤프는 모두 엘리트한 전문가들이 실제시험문제를 분석하여 답을 작성한 만큼 시험문제의 적중률은 아주 높습니다.
쉽게 시험패스ITCertKR의 테스트 엔진을 사용하여 시험을 준비한다는것은 첫 번째 시도에서 인증시험 패스성공을 의미합니다.
주문하기전 체험ITCertKR의 각 제품은 무료 데모를 제공합니다. 구입하기로 결정하기 전에 덤프샘플문제로 덤프품질과 실용성을 검증할수 있습니다.
