高品質のIBM 000-M65 000-M48 000-555 000-375 000-173 000-170「{ProductName}」問題集

成功することが大変難しいと思っていますか。IT認定試験に合格するのは難しいと思いますか。今IBMの000-M65 000-M48 000-555 000-375 000-173 000-170認定試験のためにため息をつくのでしょうか。実際にはそれは全く不要です。IT認定試験はあなたの思い通りに神秘的なものではありません。我々は適当なツールを使用して成功することができます。適切なツールを選択する限り、成功することは正に朝飯前のことです。どんなツールが最高なのかを知りたいですか。いま教えてあげます。IT-Passports.comの000-M65 000-M48 000-555 000-375 000-173 000-170問題集が最高のツールです。この問題集には試験の優秀な過去問が集められ、しかも最新のシラバスに従って出題される可能性がある新しい問題も追加しました。これはあなたが一回で試験に合格することを保証できる問題集です。

弊社は君の試験に合格させるとともにまた一年の無料の更新のサービスも提供し、もし試験に失敗したら全額で返金いたします。しかしその可能性はほとんどありません。弊社は100%合格率を保証し、購入前にネットでダウンロードしてください。

IT-Passports.comはIT試験問題集を提供するウエブダイトで、ここによく分かります。最もよくて最新で資料を提供いたします。こうして、君は安心で試験の準備を行ってください。弊社の資料を使って、１００％に合格を保証いたします。

人生には様々な選択があります。選択は必ずしも絶対な幸福をもたらさないかもしれませんが、あなたに変化のチャンスを与えます。IT-Passports.comのIBMの000-M65 000-M48 000-555 000-375 000-173 000-170試験トレーニング資料はIT職員としてのあなたがIT試験に受かる不可欠なトレーニング資料です。IT-Passports.comのIBMの000-M65 000-M48 000-555 000-375 000-173 000-170試験トレーニング資料はカバー率が高くて、更新のスピードも速くて、完全なトレーニング資料ですから、IT-Passports.com を手に入れたら、全てのIT認証が恐くなくなります。

試験番号：000-M65問題集
試験科目：IBM 「IBM Lotus XPages Technical Sales Mastery Test v1」
問題と解答：全40問

試験番号：000-M48問題集
試験科目：IBM 「IBM Lotus Web Content Management Technical Sales Mastery Test v2 」
問題と解答：全30問

試験番号：000-555問題集
試験科目：IBM 「IBM Informix Dynamic Server 11.50 Fundamentals」
問題と解答：全115問

試験番号：000-375問題集
試験科目：IBM 「IBM WebSphere Process Server V6.2, System Administration」
問題と解答：全107問

試験番号：000-173問題集
試験科目：IBM 「IBM BPM Blueprint; IBM WebSphere Lombardi Edition V7.1, Application Development」
問題と解答：全72問

試験番号：000-170問題集
試験科目：IBM 「IBM BPM Blueprint: WebSphere Lombardi Edition V7.1 Analysis」
問題と解答：全40問

購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード：http://www.it-passports.com/000-M65.html

NO.1 Where should a Developer go to freely manipulate inline style coding for an object?
A. Design
B. Source
C. Properties
D. Controls
Answer: B

IBM   000-M65   000-M65参考書   000-M65

NO.2 Which of the following is NOT one of the performance enhancements to XPages in the 8.5.1 release?
A. New properties for better control of the JSF lifecycle
B. Domino Designer built on top of Eclipse
C. JavaScript interpreter performance
D. End user experience / browser rendering
Answer: B

IBM   000-M65   000-M65参考書   000-M65

NO.3 Which of the following provides an integrated development environment for building XPages
applications?
A. Lotus Domino Messaging Express
B. Lotus Domino Administrator
C. Lotus Domino Designer
D. Lotus Collaboration Express
Answer: C

IBM   000-M65過去問   000-M65参考書   000-M65

NO.4 What are some of the questions you should ask yourself when analyzing your existing Domino NSF
application for modernizing with XPages?
A. All of the below
B. How much UI code do you have?
C. How complex are your subs and functions?
D. How do you use Rich Text, if any at all?
Answer: A

IBM   000-M65問題集   000-M65

NO.5 How are iNotes (DWA) widgets enabled?
A. formsXX.nsf
B. Mail policies
C. Dojo toolkit
D. Mail template settings
Answer: B

IBM   000-M65認定資格   000-M65   000-M65認定証

IT-Passports.comはIBM 000-545 000-421 000-375 000-173 000-170 000-169試験の実践訓練を提供する

IT-Passports.comが提供した問題集をショッピングカートに入れて100分の自信で試験に参加して、成功を楽しんで、一回だけIBMの000-545 000-421 000-375 000-173 000-170 000-169試験に合格するのが君は絶対後悔はしません。

IBMの000-545 000-421 000-375 000-173 000-170 000-169認定試験を受験したいですか。試験がたいへん難しいですから悩んでいるのですか。試験を申し込みたいですが、合格できないことが心配します。いまこのような気持ちを持っていますか。大丈夫ですよ。安心に000-545 000-421 000-375 000-173 000-170 000-169試験を申し込みましょう。IT-Passports.comの試験参考書を使用する限り、どんなに難しい試験でも問題にならないです。試験に合格する自信を全然持っていなくても、IT-Passports.comの000-545 000-421 000-375 000-173 000-170 000-169問題集はあなたが一度簡単に成功することを保証できます。不思議と思っていますか。では、IT-Passports.comのウェブサイトへ来てもっと多くの情報をブラウズすることもできます。それに、000-545 000-421 000-375 000-173 000-170 000-169問題集の一部を試用することもできます。そうすると、この参考書が確かにあなたが楽に試験に合格する保障ということをきっと知るようになります。

IT-Passports.comの専門家チームが君の需要を満たすために自分の経験と知識を利用してIBMの000-545 000-421 000-375 000-173 000-170 000-169認定試験対策模擬テスト問題集が研究しました。模擬テスト問題集と真実の試験問題がよく似ています。一目でわかる最新の出題傾向でわかりやすい解説と充実の補充問題があります。

今の社会の中で、ネット上で訓練は普及して、弊社は試験問題集を提供する多くのネットの一つでございます。IT-Passports.comが提供したのオンライン商品がIT業界では品質の高い学習資料、受験生の必要が満足できるサイトでございます。

IBM 000-545 000-421 000-375 000-173 000-170 000-169認証試験を通るために、いいツールが必要です。IBM 000-545 000-421 000-375 000-173 000-170 000-169認証試験について研究の資料がもっとも大部分になって、IT-Passports.comは早くてIBM 000-545 000-421 000-375 000-173 000-170 000-169認証試験の資料を集めることができます。弊社の専門家は経験が豊富で、研究した問題集がもっとも真題と近づいて現場試験のうろたえることを避けます。

試験番号：000-545問題集
試験科目：IBM 「DB2 9.7 SQL Procedure Developer」
問題と解答：全109問

試験番号：000-421問題集
試験科目：IBM 「InfoSphere DataStage v8.5」
問題と解答：全194問

試験番号：000-375問題集
試験科目：IBM 「IBM WebSphere Process Server V6.2, System Administration」
問題と解答：全107問

試験番号：000-173問題集
試験科目：IBM 「IBM BPM Blueprint; IBM WebSphere Lombardi Edition V7.1, Application Development」
問題と解答：全72問

試験番号：000-170問題集
試験科目：IBM 「IBM BPM Blueprint: WebSphere Lombardi Edition V7.1 Analysis」
問題と解答：全40問

試験番号：000-169問題集
試験科目：IBM 「IBM BPM Blueprint: WebSphere Lombardi Edition V7.1 Administr」
問題と解答：全72問

IBMの000-545 000-421 000-375 000-173 000-170 000-169認証試験を選んだ人々が一層多くなります。000-545 000-421 000-375 000-173 000-170 000-169試験がユニバーサルになりましたから、あなたはIT-Passports.com のIBMの000-545 000-421 000-375 000-173 000-170 000-169試験問題と解答￥を利用したらきっと試験に合格するができます。それに、あなたに極大な便利と快適をもたらせます。実践の検査に何度も合格したこのサイトは試験問題と解答を提供しています。皆様が知っているように、IT-Passports.comはIBMの000-545 000-421 000-375 000-173 000-170 000-169試験問題と解答を提供している専門的なサイトです。

購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード：http://www.it-passports.com/000-375.html

NO.1 A system administrator wants to create a stand-alone profile and minimize the steps to complete the
task. The profile should be configured to use DB2 as the backend database and have the Business
Process Choreographer component configured. How should the administrator proceed to create the
stand-alone profile?
A. Use the advanced profile creation option.
B. Use the deployment environment creation option.
C. Use the createprofiles command to create the profile silently as additional configuration options can be
enabled in the responsefile.
D. After creating the stand-alone profile, augment the profile with the default.bpc template.
Answer: A

IBM   000-375   000-375認証試験   000-375   000-375

NO.2 A company has an IBM WebSphere Process Server clustered environment running. A system
administrator is asked to configure a LDAP people directory provider to be used by human tasks. Which
action should the system administrator take?
A. Configure the URL of the local LDAP server on all nodes within the cluster.
B. Configure the people directory provider on the cell that contains the cluster.
C. Configure the people directory provider on every node that hosts members of the cluster.
D. Configure a custom property listing on the nodes within the cluster; then configure the people directory
provider on the node associated with the custom property.
Answer: C

IBM   000-375認定資格   000-375   000-375認証試験   000-375認定試験

NO.3 An administrator is configuring an existing Business Process Choreographer (BPC) configuration to
use a new database. The new database product is different from the one currently being used. Which
step should an administrator take to ensure that the tables that BPC requires will be present in the new
database?
A. Use the bpeConfig.jacl script to create the new database tables
B. In Business Process Choreographer configuration, ensure the Create Tables option has been
selected.
C. Use the sibDDLGenerator to generate new DDLs for the tables and run the new scripts on the new
database.
D. Export the tables from the previous database and import them into the new database.
Answer: B

IBM認定証   000-375   000-375練習問題   000-375   000-375過去問   000-375

NO.4 A WebSphere Process Server module is performing poorly. What can a system administrator do to
improve the performance?
A. Turn off state observers that are not needed.
B. Configure module to use application security instead of Java2 security.
C. Optimize performance by installing a Derby database on each node in a cluster.
D. Ensure XA datasources are selected if Common Event Infrastructure (CEI) is used.
Answer: A

IBM問題集   000-375   000-375練習問題   000-375認定試験

NO.5 The Service Integration Bus Browser is a tool available from the Integrated Solutions Console (ISC) that
allows the system administrator to perform which tasks?
A. View runtime properties of messaging engines.
B. View runtime properties of messaging engines, and modify message contents.
C. View runtime properties of messaging engines, queue depths, and message contents.
D. View runtime properties of messaging engines, queue depths, and message contents, and perform
administration of queued messages.
Answer: C

IBM   000-375練習問題   000-375   000-375   000-375練習問題

NO.6 Which tool should the administrator use to apply the fix packs and updates to an IBM WebSphere
Process Server?
A. Profile Management Tool
B. IBM Support Assistant (ISA)
C. IBM Installation Manager
D. Update Installer for WebSphere Software
Answer: D

IBM問題集   000-375認定資格   000-375過去問   000-375過去問   000-375

NO.7 A credit approval service implementation is frequently updated. Which WebSphere Process Server
component should be used to route the client application to the latest release?
A. A selector
B. A business rule
C. A mediation flow
D. An interface map
Answer: A

IBM過去問   000-375   000-375認定資格   000-375

NO.8 Which component in the SOA core layer provides basic event management services to applications
which require them?
A. The event catalog application
B. The event management component
C. The Common Base Event (CBE) service
D. The Common Event Infrastructure (CEI)
Answer: D

IBM   000-375   000-375過去問   000-375

NO.9 When a system administrator creates an IBM WebSphere Process Server profile and selects Enable
administrative security, an administrator user name must be supplied. This identity is used as a default for
all underlying components. After the installation, which of the following components should be configured
to appropriate users from the user repository?
A. Human Task Manager
B. Business State Machine
C. Business Process Choreographer
D. Common Event Infrastructure (CEI)
E. Service component architecture (SCA)
Answer: C,D,E

IBM   000-375練習問題   000-375練習問題   000-375問題集

NO.10 A system administrator is configuring a new Business Process Choreographer (BPC) container via the
Integrated Solutions Console (ISC). The database administrator has confirmed that the tables that the
container needs are already present in the database. On completion, the administrator installs the
BPCIVT application in order to verify the configuration. On starting the application, many failures are seen
in the server logs with the following output CWWBF0030E: Error during update of Business Process
Choreographer database with processes for application BPCIVT: CWWBA0010E:
com.ibm.db2.jcc.c.SqlException: "BPEBE00.SCHEMA_VERSION" is an undefined name What is the
cause of this problem?
A. The database name in the BPC configuration is incorrect
B. The User Id that the BPC database connection uses is incorrect
C. The Schema Name in the BPC configuration is incorrect
D. The scope that the BPC database has been configured at is incorrect
Answer: C

IBM練習問題   000-375   000-375   000-375認定資格

NO.11 Which IBM product is an integral part of WebSphere Process Server?
A. WebSphere MQ.
B. WebSphere Business Modeler.
C. WebSphere Enterprise Service Bus (WESB).
D. WebSphere Service Registry and Repository (WSRR).
Answer: C

IBM   000-375練習問題   000-375過去問   000-375過去問   000-375練習問題

NO.12 A WebSphere Process Server deployment environment is used by the development team. The
Common Event Infrastructure (CEI) was configured to be on its own Derby database. The functional and
recovery tests have passed the Proof of Concept (PoC). The next stage will be to conduct performance
tests on a staging environment. For consistency, the production environment will use the same topology
as the staging environment. Which action must the system administrator take to improve performance for
the staging system?
A. Configure CEI to use multiple Derby databases.
B. Configure a deployment environment referencing a high performance database instead of Derby.
C. Configure the CEI database to be on the same server as the WebSphere Process Server db
D. Configure the CEI database to be on the same server as the Messaging database to minimize network
latency.
Answer: B

IBM問題集   000-375問題集   000-375   000-375過去問

NO.13 A company is installing IBM WebSphere Process Server using the Launchpad and wants to create one
stand-alone IBM WebSphere Process Server and one stand-alone IBM WebSphere Application Server.
They want to minimize the steps required to create this environment. What background information does
the administrator need to know to accomplish these goals?
A. Only the IBM WebSphere Process Server stand-alone server can be created during installation.
B. Only the IBM WebSphere Application Server stand-alone server can be created during installation.
C. Either the IBM WebSphere Application Server stand-alone server or the IBM WebSphere Process
Server stand-alone server can be created during installation.
D. Both the IBM WebSphere Application Server stand-alone server and the IBM WebSphere Process
Server stand-alone server can be created during installation.
Answer: A

IBM認定試験   000-375練習問題   000-375

NO.14 In a clustered IBM WebSphere Process Server environment, a company has created two application
deployment clusters using a single remote messaging engine cluster in the same cell. Client and server
applications are communicating via asynchronous Service Component Architecture (SCA) invocations.
Each application is deployed to a different cluster. Which task must the system administrator perform to
establish connectivity between the applications?
A. There is no need to change the configuration.
B. Configure a new messaging engine cluster.
C. Advise the development team to replace the SCA bindings with Web Service bindings.
D. Create a bus link between the SCA.SYSTEM and SCA.APPLICATION bus to establish connectivity.
Answer: A

IBM問題集   000-375認定証   000-375認証試験   000-375問題集

NO.15 A developer is trying to change the settings for the Business Process Choreographer container
authentication alias (BPC_Auth_Alias) that was created during the profile creation step. An error message
indicating the developer does not have sufficient authority to change the settings is displayed. Which one
of the following is the minimum role a system administrator should grant to the developer to correct this
error?
A. Deployer role
B. Operator role
C. Configurator role
D. Administrator role
E. Adminsecuritymanager role
Answer: C

IBM   000-375   000-375参考書   000-375参考書   000-375

NO.16 A company plans to use WebSphere Business Space widgets. The development team has
implemented custom widgets using the Representational State Transfer (REST) services of the Business
Process Choreographer API. Security is an important aspect and all communication channels and APIs
must be security enabled. Before the development team can test the installed widgets in a secured
environment, which action should be performed by the system administrator?
A. Change the communication protocol of all relevant REST service endpoints to use HTTPS.
B. No action needs to be taken because the REST service endpoints do not support HTTPS protocols for
API access.
C. Enable administrative security and disable application security on the server or cluster hosting the
REST service endpoints.
D. Remove all HTTP port mapping from the list of virtual hosts to automatically use HTTPS ports and
communication channels.
Answer: A

IBM問題集   000-375   000-375

NO.17 A new business integration application retrieves and processes sensitive information from an Enterprise
Integration System (EIS). The connection is established using a WebSphere JCA adapter export
component. To protect the target component (wired) processing the data, the system administrator plans
to enable security on WebSphere Process Server. Which action should be performed to integrate the
adapter component in this environment?
A. No action is required because the JCA adapter does not support any inbound authentication
mechanisms.
B. No action is required. In a security enabled environment all EIS connections to back-end systems are
secured by default.
C. The run-as role should be set on the target component of the adapter export to protect downstream
component access.
D. The adapter export component should be configured to use a J2C authentication alias to access the
downstream components.
Answer: C

IBM   000-375認定証   000-375参考書   000-375   000-375   000-375参考書

NO.18 A company requires a business process that consists of multiple discrete steps which will run over a
period of several weeks. Some of these activities will be executed in parallel. Which type of business
process is this?
A. Microflow
B. Synchronous
C. Interruptible
D. Uninterruptible
Answer: C

IBM   000-375参考書   000-375認定証   000-375   000-375

NO.19 A system administrator wants to create a stand-alone profile and run Business Space on the
corresponding server. The administrator will need to store the Business Space tables in a DB2 database.
What is the best method for the administrator to create the profile and enable Business Space support?
A. Business Space is not supported for a stand-alone profile.
B. Run the manageprofiles command using the -configureBSdb option.
C. Create the profile using the typical installation which installs and configures Business Space.
D. Create the profile using the Profile Management Tool and install and configure Business Space using
the Integrated Solutions Console.
Answer: D

IBM   000-375   000-375   000-375   000-375

NO.20 A business process event has failed. Assuming events are enabled, how may an administrator most
easily examine the end-to-end process flow that led to the failed event, working from the Failed Event
Manager?
A. From the failed event Details page, click rowse Related Common Base Events?
B. From the failed event Details page, click pen calling process in Business Process Choreographer
Explorer?
C. Select the failed event, click esubmit with Trace? and view component logs.
D. Enable tracing on the Failed Event Manager, and resubmit the original request.
Answer: A

IBM   000-375   000-375問題集

高品質のIBM 000-173 000-170 000-169 000-022 000-544「{ProductName}」問題集

IT-Passports.comは専門的なIT認証サイトで、成功率が１００パーセントです。これは多くの受験生に証明されたことです。IT-Passports.comにはIT専門家が組み立てられた団体があります。彼らは受験生の皆さんの重要な利益が保障できるように専門的な知識と豊富な経験を活かして特別に適用性が強いトレーニング資料を研究します。その資料が即ちIBMの000-173 000-170 000-169 000-022 000-544試験トレーニング資料で、問題集と解答に含まれていますから。

IT-Passports.comが提供した問題集を使用してIT業界の頂点の第一歩としてとても重要な地位になります。君の夢は1歩更に近くなります。資料を提供するだけでなく、IBMの000-173 000-170 000-169 000-022 000-544試験も一年の無料アップデートになっています。

現在、IT業界での激しい競争に直面しているあなたは、無力に感じるでしょう。これは避けられないことですから、あなたがしなければならないことは、自分のキャリアを護衛するのです。色々な選択がありますが、IT-Passports.comのIBMの000-173 000-170 000-169 000-022 000-544問題集と解答をお勧めします。それはあなたが成功認定を助ける良いヘルパーですから、あなたはまだ何を待っているのですか。速く最新のIT-Passports.comのIBMの000-173 000-170 000-169 000-022 000-544トレーニング資料を取りに行きましょう。

現状に自己満足して、自分の小さな持ち場を守って少ない給料をもらって解雇されるのを待っている人がいないです。こんな生活はとてもつまらないですから。あなたの人生をよりカラフルにしたいのですか。ここで成功へのショートカットを教えてあげます。即ちIBMの000-173 000-170 000-169 000-022 000-544認定試験に受かることです。この認証を持っていたら、あなたは、高レベルのホワイトカラーの生活を送ることができます。実力を持っている人になって、他の人に尊敬されることもできます。IT-Passports.comはIBMの000-173 000-170 000-169 000-022 000-544試験トレーニング資料を提供できます。IT-Passports.comを利用したら、あなたは美しい夢を実現することができます。さあ、ためらわずにIT-Passports.comのIBMの000-173 000-170 000-169 000-022 000-544試験トレーニング資料をショッピングカートに入れましょう。

試験番号：000-173問題集

試験科目：IBM 「IBM BPM Blueprint; IBM WebSphere Lombardi Edition V7.1, Application Development」

問題と解答：全72問

試験番号：000-170問題集

試験科目：IBM 「IBM BPM Blueprint: WebSphere Lombardi Edition V7.1 Analysis」

問題と解答：全40問

試験番号：000-169問題集

試験科目：IBM 「IBM BPM Blueprint: WebSphere Lombardi Edition V7.1 Administr」

問題と解答：全72問

試験番号：000-022問題集

試験科目：IBM 「IBM Tivoli Composite Application Manager for Transactions V7.1 Implementation」

問題と解答：全133問

試験番号：000-544問題集

試験科目：IBM 「DB2 9.7 Advanced DBA for LUW」

問題と解答：全110問

購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード：http://www.it-passports.com/000-544.html

NO.1 Given the following table spaces, their associated page size, and number of pages:
TSP1 - 16K page size, 10000 pages
TSP2 - 8K page size, 10000 pages
TSP3 - 4K page size, 20000 pages
USERSPACE1 - 4K page size, 5000 pages
Which sets of buffer pools will ensure that all of the data in the table spaces will be fit into memory for
optimal data access?
A. IBMDEFAULTBP - 16K page size, 85000 pages
B. IBMDEFAULTBP - 4K page size, 25000 pages
BP1 -16K page size, 20000 pages
C. BP1 - page size 8K, 45000 pages
D. BP1 - 4K page size, 30000 pages
BP2 - 8K page size, 20000 pages
BP3 - 16K page size, 15000 pages
Answer: D

IBM参考書   000-544   000-544   000-544

NO.2 What is a method for enabling non-buffered I/O at the table space level in a DB2 database?
A. Set the DB2_DIRECT_IO configuration parameter to YES.
B. Set the DB2_FILESYSTEM_CACHE configuration parameter to YES.
C. Use the USE DIRECT IO clause with the CREATE TABLESPACE or ALTER TABLESPACE command.
D. Use the NO FILE SYSTEM CACHING clause with the CREATE TABLESPACE or ALTER
TABLESPACE command.
Answer: D

IBM参考書   000-544過去問   000-544   000-544認定証   000-544

NO.3 A database and a table space were created using the following commands:
CREATE DATABASE mydb AUTOMATIC STORAGE NO;
CONNECT TO mydb;
CREATE TABLESPACE tbsp1
MANAGED BY DATABASE USING (FILE '/mnt/file1' 1 M, FILE '/mnt/file2' 1 M)
AUTORESIZE YES
INCREASESIZE 2 M
MAXSIZE 100 M;
$>?
Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000
rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are
needed to convert both the database and table space TBSP1?
A. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?
B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?
ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
C. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
D. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
Answer: B

IBM認定資格   000-544認定証   000-544   000-544

NO.4 A table named TAB_A was created with the COMPRESS YES option specified and populated with
100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?
A. In order for the index to be compressed, it must be enabled for compression by specifying the
COMPRESS YES option with the CREATE INDEX statement that is used to create it.
B. The index will automatically be compressed since the table it is associated with is compressed; the
ALTER INDEX command does not have to be executed.
C. In order for the index to be compressed, it must be enabled for compression by specifying the
COMPRESS YES option in the CREATE INDEX statement used to create it; however, the index will not
be compressed until the ALTER INDEX command is used to create an index compression dictionary.
D. The index will automatically be enabled for compression because the associated table is compressed;
however, the index will not be compressed until it is REORGed.
Answer: B

IBM認定試験   000-544認定資格   000-544   000-544

NO.5 if table space TBSP1 is using automatic storage, and the existing storage paths are full, which
command would increase the available storage?
A. ALTER DATABASE ADD STORAGE ON '/db2/filesystem1'
B. ALTER TABLESPACE tbsp1 ADD ('/db2/filesystem1')
C. ALTER DATABASE ADD STORAGE FOR tbsp1 ('/db2/filesystem1')
D. ALTER TABLESPACE tbsp1 EXTEND USING ('/db2/filesystem1')
Answer: A

IBM   000-544   000-544   000-544認証試験

NO.6 Table T1 was created by executing the following statement:
CREATE TABLE t1
(deptno CHAR(2) NOT NULL,
deptname VARCHAR(36) NOT NULL,
empno CHAR(3) NOT NULL)
Immediately after creation, table T1 was populated with 10 rows. Later, user USER1 ran an application
that inserted 100,000 rows into table T1.
The following query is frequently ran against the T1 table:
SELECT deptno, empno, deptname FROM t1 WHERE deptno = 'EN' AND empno = '123'
Assuming current statics exist for the table and index, which index will provide optimal performance for
this query?
A. CREATE INDEX idx1 ON t1 (deptno, empno) INCLUDE (deptname)
B. CREATE INDEX idx1 ON t1 (deptno, empno)
C. CREATE INDEX idx1 ON t1 (deptno) INCLUDE (empno)
D. CREATE INDEX idx1 ON t1 (deptno)
Answer: B

IBM認定証   000-544過去問   000-544   000-544認定証

NO.7 A DBA needs to create a federated database and configure access to join data from three Oracle
instances and one DB2 database.
Which objects are needed to establish the specified connections?
A. 1 Oracle server , 1 DB2 server , 3 Oracle wrappers , and nicknames for each database
B. 1 Oracle server , 1 DB2 server , 1 Oracle wrapper , 1 DB2 wrapper , and nicknames for each database
C. 3 Oracle servers , 1 DB2 server , 3 Oracle wrappers , 1 DB2 wrapper , and nicknames for each
database
D. 3 Oracle servers , 1 DB2 server , 1 Oracle wrapper , 1 DB2 wrapper , and nicknames for each
database
Answer: D

IBM   000-544   000-544   000-544

NO.8 Given the following statements:
CREATE TABLESPACE mytblsp MANAGED BY DATABASE USING (FILE :\myfile1?1000, FILE
:\myfile2?800);
ALTER TABLESPACE mytbsp EXTEND (FILE :\myfile1?200, FILE :\myfile2?400);
How large are the containers MYFILE1 and MYFILE2?
A. MYFILE1 = 200 pages, MYFILE2 = 400 pages
B. MYFILE1 = 1200 pages, MYFILE2 = 1000 pages
C. MYFILE1 = 1400 pages, MYFILE2 = 1200 pages
D. MYFILE1 = 1200 pages, MYFILE2 = 1200 pages
Answer: D

IBM   000-544認定証   000-544認定試験

NO.9 How can you change an existing non-partitioned index for a partitioned table to a partitioned index?
A. Use the ALTER INDEX command.
B. Use the DROP INDEX and CREATE INDEX commands.
C. Use the REORG INDEX command.
D. Use the ALTER INDEX and REORG INDEX commands.
Answer: B

IBM   000-544   000-544   000-544問題集   000-544

NO.10 Which action can be performed by the ALTER TABLESPACE statement?
A. Change an SMS table space to a DMS table space on any database partition.
B. Change the size of a container in an SMS table space.
C. Change the EXTENTSIZE setting for a table space on a database partition that currently has no
containers.
D. Add a container to an SMS table space on a database partition that currently has no containers.
Answer: D

IBM   000-544認証試験   000-544認定証   000-544認定試験

NO.11 A database and a table space were created using the following commands:
CREATE DATABASE mydb AUTOMATIC STORAGE NO;
CONNECT TO mydb;
CREATE TABLESPACE tbsp1
MANAGED BY DATABASE USING (FILE '/mnt/file1' 1 M, FILE '/mnt/file2' 1 M)
AUTORESIZE YES
INCREASESIZE 2 M
MAXSIZE 100 M;
Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000
rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are
needed to convert the database?
A. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?
B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?
ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
C. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
D. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
Answer: A

IBM認定証   000-544認定資格   000-544   000-544認定証   000-544   000-544認証試験

NO.12 Given a newly created database and sufficient memory. If the following statements are successful:
CREATE BUFFERPOOL bp1 SIZE 40MB;
CREATE BUFFERPOOL bp2 PAGESIZE 16K SIZE 40000;
How much memory will be allocated for buffer pools BP1 and BP2?
A. 40MB
B. 80MB
C. 665MB
D. 680MB
Answer: C

IBM認定証   000-544   000-544   000-544認定証   000-544

NO.13 A table space has been created in the default database partition group.
What must you do to change the partition group for that table space?
A. Export the table space and reload it into the new partition group.
B. Move the table space to the new partition group as parameters.
C. Drop the table space and re-create it in the new partition group.
D. Alter the table space, specifying the new partition group.
Answer: C

IBM   000-544   000-544   000-544   000-544認定試験

NO.14 Database DB1 is defined on partitions 1 through 4, with the system catalog defined on partition 2. This
database is configured with LOGRETAIN=YES and TRACKMOD=YES. On Sunday evening, a full online
database backup completes successfully on all partitions. On Monday afternoon, a new table space is
created in a database partition group defined on partitions 3 and 4. On Monday evening a backup is
executed as follows :
BACKUP DATABASE db1 ONLINE INCREMENTAL
What are the results of this operation?
A. The backup completes successfully on the catalog partion only.
B. The backup completes successfully on database partitions 1 and 2, but fails on database partitions 3
and 4.
C. The backup completes successfully on database partitions 3 and 4, but fails on database partitions 1
and 2.
D. The backup completes successfully on all database partitions.
Answer: B

IBM練習問題   000-544問題集   000-544認定試験

NO.15 Assuming the following commands are executed in the order shown:
CREATE DATABASE mydb AUTOMATIC STORAGE NO;
CONNECT TO mydb;
CREATE TABLESPACE tbsp1
MANAGED BY DATABASE USING (FILE 'C:\file1' 1 M, FILE 'C:\file2' 1 M)
AUTORESIZE YES
INCREASESIZE 2 M
MAXSIZE 100 M;
CREATE TABLE tab_a (c1 INT, c2 CHAR(30), c3 XML) COMPRESS YES;
IMPORT FROM data.del OF DEL INSERT INTO tab_a;
If the following command is executed:
ALTER DATABASE mydb ADD STORAGE ON ?mnt/file_1? ?mnt/file_2?
Which statement is true?
A. The ALTER DATABASE command will fail because database MYDB was not created as an automatic
storage database.
B. The ALTER DATABASE command will convert database MYDB to an automatic storage database, and
table space TBSP1 will automatically be converted to an automatic storage table space.
C. Table space TBSP1 can be converted to an automatic storage table space at any time by executing the
ALTER TABLESPACE statement.
D. Table space TBSP1 will be placed in Conversion Pending?state and must be converted to an
automatic storage table space before it can be used.
Answer: C

IBM   000-544   000-544   000-544練習問題

NO.16 A DBA wants to create table space named MYTBLSP in a database with five partitions.
Which command will create the table space on all five partitions?
A. CREATE TABLESPACE mytblsp MANAGED BY DATABASE USING (FILE '/tbsp/cont1P$NODES'
5000)
B. CREATE TABLESPACE mytblsp MANAGED BY DATABASE USING (FILE '/tbsp/cont1P0' to
'/tbsp/cont1P4' 5000)
C. CREATE TABLESPACE mytblsp MANAGED BY DATABASE USING (FILE '/tbsp/cont1P[0-4]' 5000)
D. CREATE TABLESPACE mytblsp MANAGED BY DATABASE USING (FILE '/tbsp/cont1P $N' 5000)
Answer: D

IBM参考書   000-544認証試験   000-544練習問題   000-544練習問題

NO.17 You have a database with eight partitions on a single server. Immediately after executing the following
command:
CREATE BUFFERPOOL mybp DEFERRED SIZE 3000
How much memory is consumed by buffer pool MYBP on the server?
A. 0 pages
B. 3000 pages
C. 24000 pages
D. 192000 pages
Answer: A

IBM   000-544   000-544認定資格

NO.18 Which command produced the result shown below?
Tracking Memory on: 2010/02/18 at 21:18:19
Memory for database: SAMPLE
bph (2) utilh pckcacheh catcacheh bph (1) bph (S32K) bph (S16K)
4.2M 64.0K 256.0K 64.0K 288.0M 704.0K 448.0K
bph (S8K) bph (S4K) shsorth lockh dbh other
320.0K 256.0K 64.0K 10.0M 4.7M 128.0K
A. db2mtrk -i
B. db2mtrk -d
C. db2mtrk -p
D. db2mtrk -a
Answer: B

IBM   000-544   000-544

NO.19 Considering you have an OLTP workload consisting of similar queries that are repeatedly generated
and differ only in their predicate values, what can be done to reduce compilation overhead?
A. UPDATE DB CFG USING STMT_CONC LITERALS
B. UPDATE DB CFG USING SQL_CONC LITERALS
C. UPDATE DB CFG USING SQL_CONC YES
D. UPDATE DB CFG USING STMT_CONC OFF
Answer: A

IBM   000-544   000-544   000-544

NO.20 A database named MYDB was created by executing the following command:
CREATE DATABASE mydb AUTOMATIC STORAGE NO
Later, a decision is made to modify this database so that both it and its table spaces use automatic
storage.
What steps are required to make this modification?
A. Use the ALTER DATABASE command to convert the database; all existing table spaces will be
converted automatically.
B. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE
command to convert all existing table spaces.
C. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE
command to convert all existing SMS table spaces.
D. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE
command to convert all existing DMS table spaces.
Answer: D

IBM   000-544   000-544   000-544