test4actual help you pass any IT certification

Exam : IBM 000-374
Title : IBM WebSphere MQ V7.0 SystemAdministration
Version : DEMO

1. A legacy application uses MQPUT to send messages to a queue INV.
Which set of MQSC commands below will successfully configure the queue manager so that a number of JMS applications can receive these messages by subscribing to topic Inventory/CurrentItems?
A. DEFINE TOPIC(INV_TOPIC) + TOPICSTR(Inventory/CurrentItems)DEFINE QALIAS(INV) TARGET(INV_TOPIC) TARGTYPE(TOPIC)
B. DEFINE TOPIC(INV_TOPIC) + TOPICSTR(Inventory/CurrentItems)DEFINE TALIAS(INV) TARGET(INV_TOPIC) TARGTYPE(TOPIC)
C. DEFINE TOPIC (INV_TOPIC) + TOPICSTR(Inventory/CurrentItems) QALIAS(INV)
D. DEFINE QALIAS(INV) TARGET(Inventory/CurrentItems) + TARGTYPE(TOPIC)
Answer: A
2. An administrator wants to prevent the channel initiator process from starting when a queue manager QMA on AIX is started.
Which action(s) will accomplish this?
A. Restart the queue manager using strmqm ns QMA.
B. Restart the queue manager using strmqm chinit no QMA.
C. Issue the command ALTER QMGR SCHINIT(DISABLED), then restart the queue manager using strmqm QMA.
D. Edit the file qm.ini for QMA and add an entry ChannelInitiator = No in the CHANNELS stanza, then restart the
queue manager using strmqm QMA
Answer: A
3. An administrator has been asked to create a queue manager alias for QM1 to be used for communication between remote queue managers.
What MQSC command will create the queue manager alias?
A. DEF QR(QM1.ALIAS) RNAME(’Q1′) RQMNAME(’ ‘) XMITQ(QM1)
B. DEF QR(QM1.ALIAS) RNAME(’ ‘) RQMNAME(QM1) XMITQ(QM1)
C. DEF QR(QM1.ALIAS) RNAME(’Q1′) RQMNAME(QM1) XMITQ(’ ‘)
D. DEF QL(QM1.ALIAS) RQMNAME(QM1)
Answer: B
4. An administrator has created the following MQ objects on two systems:
SYSTEM A
crtmqm -C “VEGGIE QUEUE MANAGER” -LL -Q -D POTATO VEGGIE
DEFINE QR(APPLE) RQMNAME(FRUIT) RNAME(PEACH)
DEFINE QL(DLQ)
DEFINE QL(POTATO) USAGE(XMITQ)
DEF CHL(’VEGGIE. FRUIT’) CHLTYPE(SDR) TRPTYPE(TCP) CONNAME(’9.84.100.7(1414)’) +
XMITQ(’POTATO’)
SYSTEM B
crtmqm -C “FRUIT QUEUE MANAGER” -LL -Q -D GRAPE FRUIT
DEFINE QL(GRAPE) USAGE(XMITQ)
DEFINE QL(PEACH)
DEF CHL(’VEGGIE. FRUIT’) CHLTYPE(RCVR) TRPTYPE(TCP)
An application connects to queue manager VEGGIE and puts a message to queue APPLE. On which queue does the message get delivered before it gets picked up by the sender channel?
A. POTATO
B. APPLE
C. GRAPE
D. PEACH
Answer: A
5. An application deployed on z/OS was causing frequent abends.
Which of the following options from the IPCS Dump Component Panel can an administrator use to analyze the problem?
A. CSQWDMP
B. ASMCHECK
C. DIVDATA
D. DAEDATA
Answer: A
6. What are the four predefined message types?
A. Request, response, publication, datagram
B. Publication, subscription, request, response
C. Request, reply, report, datagram
D. Request, broadcast, acknowledgment, response
Answer: C
7. Which features of IBM WebSphere MQ specifically provide robust message transport?
A. Data integrity, security, parallel processing
B. Asynchronous delivery, once and once-only delivery, persistent messaging
C. Time independence, no duplicate delivery, synchronous processing
D. Assured delivery, application parallelism, time dependent applications
Answer: B
8. Which of the following are performance enhancements to the Java Message Service provider implementation in IBM WebSphere MQ V7.0?
A. Read Ahead
B. Support for channel exits written in C/C++
C. Asynchronous Put
D. Message selection performed by Queue Manager
E. Ability to access all MQMD fields for IBM WebSphere MQ messages.
Answer: ACD

http://www.test4actual.com/000-374.html

9. Which of the following statements are true, regarding applications that communicate via IBM WebSphere MQ?IBM WebSphere MQ applications have to agree upon:
A. the platforms they are running on
B. the name(s) of the queue(s) used
C. the maximum number of messages sent within a given time period
D. the layout of the message data exchanged
E. the network protocol used
Answer: BD
10. A company running IBM WebSphere MQ V5.3 on UNIX upgraded to IBM WebSphere MQ V7.0.Immediately after the migration, what is the administrator expected to do?
Start the:
A. MQSeries service
B. queue manager and listener simultaneously
C. queue manager before starting the listener
D. listener before starting the queue manager
Answer: C
11. An administrator using WebSphere MQ Explorer is unable to connect to queue manager PROD after it has been migrated, and receives error message SYSTEM.MQEXPLORER.REPLY.MODEL not defined.
Which command will refresh the existing system objects to resolve this issue?
A. strmqm c PROD
B. strmqm a PROD
C. strmqm ss PROD
D. strmqm si PROD
Answer: A
12. What are the advantages of using queue-sharing groups in IBM WebSphere MQ?
A. workload balancing, remote administration
B. improved performance, ease of monitoring
C. scalability, end-to-end security, data integrity
D. scalability, high availability, workload balancing
Answer: D
13. Which two user profiles are mandatory to correctly run IBM WebSphere MQ on i5/OS?
A. QMQM, QMQMADM
B. QMQMADIM, mqm
C. mqm, QMQM
D. mqm, MUSR_MQADMIN
Answer: A
14. Which Eclipse version is a prerequisite to use MQ Explorer to administer IBM WebSphere MQ V7.0 on Windows?
A. 3.3
B. 3.2
C. 3.1
D. 3.0
Answer: A
15. For the Solaris platform, which databases are supported as a resource manager in transactions coordinated by IBM WebSphere MQ V7.0?
A. Oracle, Derby, My SQL
B. DB2, Derby, Teradata
C. DB2, Oracle, Informix, Sybase
D. DB2, SQL Server, Sybase, Informix
Answer: C

With the complete collection of questions and answers, Test4actual has assembled to take you through 112 Q&A to your 000-374 exam preparation. In the 000-374 exam resources, you will cover every field and category in WebSphere helping to ready you for your successful IBM Certification.

Free 000-374 Demo Download
Test4actual offers free demo for WebSphere 000-374 exam (IBM WebSphere MQ V7.0 System Administration). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.

Product Description
Exam Number/Code: 000-374
Exam Name: IBM WebSphere MQ V7.0 System Administration Questions and Answers:112Q&A
Update Time:2010-3-11
Price:$119.00
Exam Details
The WebSphere exam is the qualifying exam available to candidates pursuing a single-exam option for the IBM Certified Network Associate WebSphere certification. The WebSphere (000-374) exam will test materials from the new Interconnection IBM Network Devices (ICND) course as well as the new Introduction to IBM Networking Technologies (INTRO) course. The exam will certify that the successful candidate has important knowledge and skills necessary to select, connect, configure, and troubleshoot the various IBM networking devices. The exam covers topics on Extending Switched Networks with VLANS, Determining IP Routes, Managing IP traffic with Access Lists, Establishing Point-to-Point connections, and Establishing Frame Relay Connections.

1. Which of the following is NOT true about XML columns?
A.Data can be retrieved by SQL.
B.Data can be retrieved by XQuery.
C.XML columns must be altered to accommodate additional parent and child relationships.
D.Access to any portion of an XML document can be direct, without reading the whole document.
Answer: C
2. A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the following commands is required to update the local node directory so that a DB2 client can access this DRDA database?
A.CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446
B.CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446
C.CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1
D.CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1
Answer: B
3. The following SQL statements were executed in sequence:
What is the current content of the staffsalary table?
A.ID | EMPSALARY —————– 10 | 60000 20 | 50000.00 —————–
B.ID | EMPSALARY —————– 10 | 50000.00 20 | 50000.00 —————–
C.ID | EMPSALARY —————– 10 | 60000.00 20 | 60000.00 —————–
D.ID | EMPSALARY —————– 10 | 60000.00 20 | 50000.00 —————–
Answer: C
4. Which of the following queries will correctly return the manager information sorted by the manager’s last name, department and project name?
A.SELECT lastname, dept, projname, manager, startdate FROM (SELECT name, dept, proj AS projname, manager, startdate FROM employee, project WHERE empno = empno) AS empproj ORDER BY name, dept, projname B.SELECT lastname, dept, projname, manager, startdate FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate FROM employee, project WHERE empno = mgrno) AS empproj SORT BY lastname, firstname, dept, projname
C.SELECT lastname, dept, projname, manager, startdate FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate FROM employee, project WHERE empno = mgrno) AS empproj ORDER BY lastname ASC SORT BY dept, projname DESC
D.SELECT lastname, dept, projname, manager, startdate FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate FROM employee, project WHERE empno = mgrno) AS empproj ORDER BY lastname, dept, projname
Answer: D
5. Which of the following strings can be inserted into an XML column using XMLPARSE?
A.”"
B.”"
C.”"
D.”"
Answer: A
6. When defining a referential constraint between the parent table T2 and the dependent table T1,which of the following is true?
A.The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.
B.The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
C.The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.
D.The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
Answer: C
7. Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?
A.DB2 Express Edition
B.DB2 Personal Edition
C.DB2 Workgroup Server Edition
D.DB2 Enterprise Server Edition
Answer: D
8. Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?
A.DB2 Express Edition
B.DB2 Personal Edition
C.DB2 Workgroup Server Edition
D.DB2 Enterprise Server Edition
Answer: C

http://www.test4actual.com/000-730.html

9. Which of the following DB2 products are required on an iSeries or System i server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?
A.DB2 for i5/OS
B.DB2 Runtime Client
C.DB2 Connect Enterprise Edition
D.DB2 for i5/OS SQL Development Kit
Answer: A
10. Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?
A.DB2 for z/OS
B.DB2 Run-Time Client for z/OS
C.DB2 Connect Enterprise Edition for z/OS
D.z/OS Application Connectivity to DB2 for z/OS and OS/390
Answer: A
11. Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?
A.Design Advisor
B.Visual Explain
C.Performance Advisor
D.Configuration Assistant
Answer: A
12. Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?
A.Task Center
B.Command Editor
C.Developer Workbench
D.Command Line Processor
Answer: B
13. Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?
A.Visual Explain
B.Activity Monitor
C.SQL Performance Monitor
D.DB2 Performance Monitor
Answer: C
14. Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?
A.Control Center
B.Development Center
C.Developer Workbench
D.Stored Procedure Builder
Answer: C
15. Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?
A.Journal
B.Task Center
C.Activity Monitor
D.Command Line Processor
Answer: B

With the complete collection of questions and answers, Test4actual has assembled to take you through 128 Q&A to your 000-730 exam preparation. In the 000-730 exam resources, you will cover every field and category in DB2 helping to ready you for your successful IBM Certification.

Free 000-730 Demo Download
Test4actual offers free demo for DB2 000-730 exam (DB2 9 Fundamentals). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.

Product Description
Exam Number/Code: 000-730
Exam Name: DB2 9 Fundamentals Questions and Answers:128Q&A
Update Time:2010-3-11
Price:$119.00
Exam Details
The DB2 exam is the qualifying exam available to candidates pursuing a single-exam option for the IBM Certified Network Associate DB2 certification. The DB2 (000-730) exam will test materials from the new Interconnection IBM Network Devices (ICND) course as well as the new Introduction to IBM Networking Technologies (INTRO) course. The exam will certify that the successful candidate has important knowledge and skills necessary to select, connect, configure, and troubleshoot the various IBM networking devices. The exam covers topics on Extending Switched Networks with VLANS, Determining IP Routes, Managing IP traffic with Access Lists, Establishing Point-to-Point connections, and Establishing Frame Relay Connections.