최신 IBM certifications I C2090-541 무료샘플문제:
1. Which statement is true about using the EXPORT utility with a table that contains XML data?
A) If the table being exported does not contain well-formed XML documents, the XMLSAVESCHEMA option must be provided with the EXPORT command used.
B) By default, XML documents are written to a single, separate file, which is stored in the same location as the file that contains the relational data exported.
C) If you are exporting XML documents that are greater than 32 Kb in size, you must use the XMLINSEPFILES modifier to avoid truncation.
D) By default, XML documents will be written to the same file that contains the relational data exported unless the XMLFILE option is used.
2. A file named db2advise.in contains the text shown below:
-#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design
Advisor?
A) Executes the first SQL statement in the workload file 100 times.
B) Executes both SQL statements in the workload file 100 times.
C) Executes an index analysis for the first SQL statement in the workload file 100 times.
D) Executes up to 100 combinations of optimizations for both SQL statements in the workload file.
3. Click the Exhibit button.
IBM 000-541: Practice Exam
Given the TCP/IP configuration shown in the exhibit, to what must the alternate server be set on the Primary, to allow Automatic Client Reroute to connect to the Standby after a HADR takeover?
A) 192.168.2.102
B) 192.168.1.102
C) 192.168.2.1
D) 192.168.1.1
4. A database administrator created a new database from an existing full database backup image. If the original database resided on a 64-bit AIX server and the new database was created on a different 64-bit AIX server, which two statements are correct? (Choose two.)
A) Incremental backup images for the original database can be used to restore the new database.
B) Existing SQL procedures must be dropped and re-created in the new database before they can be used
C) Incremental backups are not allowed until a non-incremental backup is taken.
D) Existing packages will be copied to the new database and can be used immediately.
5. What are two valid protocols that can be used with the CATALOG NODE command to establish communication with a server named SERVER1? (Choose two.)
A) token ring
B) NetBIOS
C) named pipe
D) IPv6
질문과 대답:
| 질문 # 1 정답: B | 질문 # 2 정답: B | 질문 # 3 정답: A | 질문 # 4 정답: B,C | 질문 # 5 정답: C,D |
869 개 고객 리뷰
품질과 가치ITCertKR 의 높은 정확도를 보장하는 최고품질의 덤프는 IT인증시험에 대비하여 제작된것으로서 높은 적중율을 자랑하고 있습니다.
테스트 및 승인ITCertKR 의 덤프는 모두 엘리트한 전문가들이 실제시험문제를 분석하여 답을 작성한 만큼 시험문제의 적중률은 아주 높습니다.
쉽게 시험패스ITCertKR의 테스트 엔진을 사용하여 시험을 준비한다는것은 첫 번째 시도에서 인증시험 패스성공을 의미합니다.
주문하기전 체험ITCertKR의 각 제품은 무료 데모를 제공합니다. 구입하기로 결정하기 전에 덤프샘플문제로 덤프품질과 실용성을 검증할수 있습니다.
