000-971 덤프 IBM 인증 시험

멋진 IT전문가로 거듭나는 것이 꿈이라구요? 국제적으로 승인받는 IT인증시험에 도전하여 자격증을 취득해보세요. IT전문가로 되는 꿈에 더 가까이 갈수 있습니다. IBM인증 000-971시험이 어렵다고 알려져있는건 사실입니다. 하지만ITExamDump의IBM인증 000-971덤프로 시험준비공부를 하시면 어려운 시험도 간단하게 패스할수 있는것도 부정할수 없는 사실입니다. ITExamDump의IBM인증 000-971덤프는 실제시험문제의 출제방형을 철저하게 연구해낸 말 그대로 시험대비공부자료입니다. 덤프에 있는 내용만 마스터하시면 시험패스는 물론 멋진 IT전문가로 거듭날수 있습니다.

우리ITExamDump 는 많은IT전문가들로 구성되었습니다. 우리의 문제와 답들은 모두 엘리트한 전문가들이 만들어낸 만큼 시험문제의 적중률은 아주 높습니다. 거이 100%의 정확도를 자랑하고 있습니다. 아마 많은 유사한 사이트들도 많습니다. 이러한 사이트에서 학습가이드와 온라인서비스도 지원되고 있습니다만 우리ITExamDump는 이미 이러한 사이트를 뛰어넘은 실력으로 업계에서는 우리만의 이미지를 지키고 있습니다. 우리는 정확한 문제와답만 제공하고 또한 그 어느 사이트보다도 빠른 업데이트로 여러분의 인증시험을 안전하게 패스하도록합니다.IBM 000-971인증시험을 응시하려는 분들은 저희 문제와 답으로 안심하시고 자신 있게 응시하시면 됩니다. 우리ITExamDump 는 여러분이 100%IBM 000-971인증시험을 패스할 수 있다는 것을 보장합니다.

만약IBM인증000-971시험을 통과하고 싶다면, Pass4Tes의 선택을 추천합니다. Pass4Tes선택은 가장 적은 투자로 많은 이익을 가져올 수 있죠, Pass4Tes에서 제공하는IBM인증000-971시험덤프로 시험패스는 문제없스니다. ITExamDump는 전문적으로 it인증시험관련문제와 답을 만들어내는 제작팀이 있으며, Pass4Tes 이미지 또한 업계에서도 이름이 있답니다

ITExamDump는 유일하게 여러분이 원하는IBM인증000-971시험관련자료를 해결해드릴 수 잇는 사이트입니다. ITExamDump에서 제공하는 자료로 응시는 문제없습니다, 여러분은 고득점으로 시험을 통과할 것입니다.

ITExamDump의 연구팀에서는IBM 000-971인증덤프만 위하여 지금까지 노력해왔고 ITExamDump 학습가이드IBM 000-971덤프로 시험이 어렵지 않아졌습니다. ITExamDump는 100%한번에IBM 000-971이장시험을 패스할 것을 보장하며 우리가 제공하는 문제와 답을 시험에서 백프로 나올 것입니다.여러분이IBM 000-971시험에 응시하여 우리의 도움을 받는다면 ITExamDump에서는 꼭 완벽한 자료를 드릴 것을 약속합니다. 또한 일년무료 업데이트서비스를 제공합니다.즉 문제와 답이 갱신이 되었을 경우 우리는 여러분들한테 최신버전의 문제와 답을 다시 보내드립니다.

시험 번호/코드: 000-971
시험 이름: IBM (System i Administrator V5.07.11)

000-971 덤프무료샘플다운로드하기: http://www.itexamdump.com/000-971.html

NO.1 The system attention light is illuminated on the front panel of a non-partitioned system but the
system is still operating. Where should the administrator go to find the source of the problem and
turn the attention light off?
A.Use WRKHDWRSC *ERROR
B.Use DSPMSG QSYSOPR and use F16
C.Use the Hardware Service Manager in SST.
D.Use WRKPRB and use F16, Report Prepared Problems
Correct:C

IBM   000-971덤프   000-971 dumps

NO.2 A system has the following backup strategy implemented: - A full system backup, including data
queue and output queue entries, is run weekly. - A daily backup is run on the remaining days of
the week using SAVCHGOBJ to capture all changed objects. Which of the following objects will be
omitted from the daily save?
A.Spooled files added since the full backup.
B.Data queues created since the full backup.
C.Output queues created since the full backup.
D.Data queue entries added since the full backup.
Correct:A

IBM   000-971덤프   000-971 dumps

NO.3 Database operations are slower on Monday mornings and speed up throughout the week. The
system is IPLed every Sunday evening. Which of the following is the most likely explanation for
this behavior?
A.The system's IPL attribute CHKJOBTBL is set to *ALL.
B.The system is performing periodic data integrity checks after each IPL.
C.The system builds temporary indexes during first access of files after each IPL.
D.The files being accessed must be converted to the system's defined CCSID after each IPL.
Correct:C

IBM   000-971덤프   000-971 dumps

NO.4 A customer has a System i model 520, serial number 65-47BFD. It is one of several systems
managed by an HMC running Version 7 firmware at TCP/IP address 10.0.0.100. Which of the
following describes how to produce a system plan for this system in file MYPLAN.sysplan?
A.Select system plans from left panel, then select Create System Plan. In the pop-up window, fill in
system plan name and description, click OK.
B.Select "Service Applications" on the HMC and click the Create System Plan option. In the pop-up
window, click the line with 9406-520*6547BFD, and specify file MYPLAN in the file name prompt.
C.Launch SPT and click "Create New Plan." On the next panel, click the "Open an Existing System Plan."
In the file prompt, specify https://10.0.0.100/sysplan. After the system plan is loaded from the HMC, save
to file MYPLAN.
D.Select "System Plans" on the HMC, and then click the "Import button. On the pop-up window, click the
line with 9406-520*6547BFD. When the import completes, click the "Export? button and specify file
MYPLAN in the file name prompt.
Correct:A

IBM   000-971덤프   000-971 dumps

NO.5 Which of the following will ensure that parent/foreign key relationships are maintained?
A.Primary key constraint
B.Database index
C.Commitment control
D.Referential constraint
Correct:D

IBM   000-971덤프   000-971 dumps

NO.6 The administrator needs to configure the system to send messages when % System ASP Used
reaches 90%. Which of the following will accomplish the task?
A.Set QSTGLOWLMT to 10% and QSTGLOWACN to *MSG.
B.Set QASPMAXLMT to 90% and the QASPMAXACN to *SNDMSG.
C.Set QSTGMAXLMT to 90% and register the QIBM_QWC_QSTGMAXACN exit program to *SNDMSG.
D.Set QSTGMINLMT to 10% and register the QIBM_QWC_QSTGLMINACN exit program to *SNDMSG.
Correct:A

IBM   000-971덤프   000-971 dumps

NO.7 Which of the following describes a PTF that can be applied without a system IPL?
A.A Standard PTF
B.A Permament PTF
C.A Temporary PTF
D.An Immediate PTF
Correct:D

IBM   000-971덤프   000-971 dumps

NO.8 An administrator has accidentally disabled the QSECOFR service profile for SST. What is
required to re-enable the service profile?
A.Re-install the base SLIC (microcode) from tape.
B.Sign onto the system as QSECOFR and use the CHGDSTPWD command with *ENABLE.
C.Sign into SST with the 11111111 profile. Re-enable the QSECOFR service profile.
D.Force DST from the control panel. Sign into DST as QSECOFR and re-enable the profile.
Correct:D

IBM   000-971덤프   000-971 dumps

NO.9 An i5/OS system has two fibre channel adapters connected to two tape drives in a 3584 tape
library. Work with Media Library Media shows the same tape volumes in each of two tape libraries.
A backup fails indicating no expired media is available. Which of the following is the most likely
cause of the problem?
A.The media is in category *SHARE400.
B.The media is assigned to the wrong library name.
C.The media library name used in the backup is not varied on.
D.The logical tape library has not been assigned to both tape drives.
Correct:B

IBM   000-971덤프   000-971 dumps

NO.10 A system has high database disk activity and low CPU utilization. Which of the following is the
least disruptive approach to improving the overall system performance?
A.Activate Expert Cache.
B.Run RCLSTG SELECT(*DBXREF).
C.Set System value QPFRADJ to 2.
D.Install additional disk drives.
Correct:A

IBM   000-971덤프   000-971 dumps

NO.11 Users are complaining that their PC-based application, which connects to the System i using
JDBC, has gotten progressively slower when initially connecting to the System i. The number of
users for this application has been increasing recently. The PC and Network support departments
report no problems. How can the time required for the users' JDBC jobs to start be decreased?
A.Change the duplex setting on the line description from *HALF to *FULL.
B.Move the QZOSIGNON prestart jobs from the QUSRWRK subsystem to the QCMN subsystem.
C.Increase the amount of memory and the maximum number of active jobs for the QSYSWRK subsystem.
D.Increase the "Initial number of jobs" and the "Additional number of jobs" for the QZDASOINIT prestart
job.
Correct:D

IBM   000-971덤프   000-971 dumps

NO.12 The job tables must be compressed at the next IPL. Which of the following will accomplish this?
A.CHGIPLA CPRJOBTBL(*IPL)
B.CHGIPLA CPRJOBTBL(*NEXT)
C.PWRDWNSYS CPRJOBTBL(*ALL)
D.PWRDWNSYS CPRJOBTBL(*NEXT)
Correct:B

IBM   000-971덤프   000-971 dumps

NO.13 An administrator has set up the backup strategy as follows: Each weekend a SAVSYS and
SAVLIB *NONSYS are performed. Each night during the week the command SAVCHGOBJ
OBJ(*ALL) LIB(*ALLUSR) DEV(TAP01) REFDATE(*SAVLIB) is run. If on Wednesday a new library is
created but not saved, what will happen on that night's SAVCHGOBJ for the new library?
A.The library and the objects will be saved.
B.The library and the objects will be skipped.
C.Only the objects in the library will be saved and not the library.
D.Only the Library will be saved, unless OBJTYPE(*OBJ) is added to the command.
Correct:C

IBM   000-971덤프   000-971 dumps

NO.14 An administrator has created a hosted Linux partition on their System i. There are no available
physical Ethernet adapters to dedicate to the Linux partition. Which of the following actions will
establish an Ethernet connection without purchasing a NIC?
A.Place an existing NIC on a switched bus and uncap the resource.
B.Use virtual Ethernet and the "Packet Rules" function in System i Navigator.
C.Attach a bridge to an existing NIC and assign a port to the Linux partition.
D.Implement IPv6 to allow for multi-host communication on a non-shared resource.
Correct:B

IBM   000-971덤프   000-971 dumps

NO.15 Which of the following lists potential job status values when using the WRKUSRJOB command?
A.JOBQ, ACTIVE, OUTQ
B.JOBQ, SUBSYSTEM, ACTIVE-TO-INELIGIBLE
C.JOB INITIALIZATION, PRESTART, AUTOSTART
D.WAIT-TO-ACTIVE, ACTIVE, ACTIVE-TO-INELIGIBLE
Correct:A

IBM   000-971덤프   000-971 dumps

NO.16 A 550 with two active processors has two partitions. Each partition has one capped, shared
processor with one virtual processor. The first partition runs Domino and Apache while the
second runs Websphere and PHP. Performance in both partitions is not what was expected.
Which of the following configuration changes will improve performance?
A.Change the processors to be uncapped.
B.Change the processors to be dedicated.
C.Change the memory allocation to *Dynamic.
D.Increase the virtual processors for each partition.
Correct:B

IBM   000-971덤프   000-971 dumps

NO.17 A System i customer is running DNS on their i5. What must be included in the backup to ensure
the DNS tables are saved?
A.Files QATOC* in library QUSRSYS
B.IFS Directory /QIBM/UserData/OS400/DNS
C.File QDNS[name_of_dns_server] in library QUSRSYS
D.IFS Directory /QIBM/UserData/[name_of_dns_server]
Correct:B

IBM   000-971덤프   000-971 dumps

NO.18 Internal audit is planning a security audit next month. The system administrator has been given
the task to prepare the system for the audit. Which of the following commands is used to set
security features to the IBM recommended values?
A.SETSYSSEC
B.CFGSYSSEC
C.WRKSYSAUD
D.STRSYSSEC
Correct:B

IBM   000-971덤프   000-971 dumps

NO.19 A customer has a single partition i525. The system administrator has been asked to implement
WebSphere Application Server Express in order to implement additional functionality of an
installed ERP package. Which of the following must be done to ensure proper performance of the
WAS server?
A.Verify the Query Optimization (QQRYDEGREE) is set to *OPTIMIZE.
B.Review the shared pool memory allocation with an emphasis on the *BASE pool.
C.Verify the system value QMLTTHDACN is set to option 3, "Do not perform the function."
D.Review the shared pool paging sizes to optimize them for WebSphere Application Server Express.
Correct:B

IBM   000-971덤프   000-971 dumps

NO.20 An Administrator wants to change the configuration of the telnet server using System i
Navigator. After expanding My Connections -> Server, which of the following procedures
accomplish this?
A.Network -> Servers -> TCP/IP. Right-click the TELNET server and select Properties from the drop down
window.
B.Remote Access Services -> Servers. Right-click the TELNET server and select Properties from the
drop down window.
C.Configuration and Service -> Servers. Right-click the TELNET server and select Properties from the
drop down window.
D.Network -> TCP/IP Configuration -> Servers. Right-click the TELNET server and select Properties from
the drop down window.
Correct:A

IBM   000-971덤프   000-971 dumps

ITExamDump이 바로 아주 좋은IBM 000-971인증시험덤프를 제공할 수 있는 사이트입니다. ITExamDump 의 덤프자료는 IT관련지식이 없는 혹은 적은 분들이 고난의도인IBM 000-971인증시험을 패스할 수 있습니다. 만약ITExamDump에서 제공하는IBM 000-971인증시험덤프를 장바구니에 넣는다면 여러분은 많은 시간과 정신력을 절약하실 수 있습니다. 우리ITExamDump 의IBM 000-971인증시험덤프는 ITExamDump전문적으로IBM 000-971인증시험대비로 만들어진 최고의 자료입니다.

000-600 000-543 000-971 LOT-983 LOT-953 덤프 IBM 자격증

자신을 부단히 업그레이드하려면 많은 노력이 필요합니다. IT업종 종사자라면 국제승인 IT인증자격증을 취득하는것이 자신을 업그레이드하는것과 같습니다. IBM인증 000-600 000-543 000-971 LOT-983 LOT-953시험을 패스하여 원하는 자격증을 취득하려면ITExamDump의IBM인증 000-600 000-543 000-971 LOT-983 LOT-953덤프를 추천해드립니다. 하루빨리 덤프를 공부하여 자격증 부자가 되세요.

네트워크 전성기에 있는 지금 인터넷에서IBM 인증000-600 000-543 000-971 LOT-983 LOT-953시험자료를 많이 검색할수 있습니다. 하지만 왜ITExamDump덤프자료만을 믿어야 할가요? ITExamDump덤프자료는 실제시험문제의 모든 유형에 근거하여 예상문제를 묶어둔 문제은행입니다.시험적중율이 거의 100%에 달하여IBM 인증000-600 000-543 000-971 LOT-983 LOT-953시험을 한방에 통과하도록 도와드립니다.

ITExamDump에서 최고최신버전의IBM인증000-600 000-543 000-971 LOT-983 LOT-953시험덤프 즉 문제와 답을 받으실 수 있습니다. 빨리 소지한다면 좋겠죠. 그래야 여러분은 빨리 한번에IBM인증000-600 000-543 000-971 LOT-983 LOT-953시험을 패스하실 수 있습니다.IBM인증000-600 000-543 000-971 LOT-983 LOT-953관련 최고의 자료는 현재까지는ITExamDump덤프가 최고라고 자신 있습니다.

시험 번호/코드: 000-600

시험 이름: IBM (System z Solution Sales V4)

시험 번호/코드: 000-543

시험 이름: IBM (DB2 9.7 Application Development)

시험 번호/코드: 000-971

시험 이름: IBM (System i Administrator V5.07.11)

시험 번호/코드: LOT-983

시험 이름: IBM (IBM Lotus Notes Domino 8.5 Managing Servers and Users)

시험 번호/코드: LOT-953

시험 이름: IBM (IBM Lotus Notes Domino 8.5 Application Development Intermediate Skills)

우리ITExamDump에는 아주 엘리트한 전문가들로 구성된 팀입니다. 우리는 아주 정확하게 또한 아주 신속히IBM 000-600 000-543 000-971 LOT-983 LOT-953관한 자료를 제공하며, 업데이트될경우 또한 아주 빠르게 뉴버전을 여러분한테 보내드립니다. ITExamDump는 관련업계에서도 우리만의 브랜드이미지를 지니고 있으며 많은 고객들의 찬사를 받았습니다. 현재IBM 000-600 000-543 000-971 LOT-983 LOT-953인증시험패스는 아주 어렵습니다, 하지만 ITExamDump의 자료로 충분히 시험 패스할 수 있습니다.

ITExamDump의 IBM 000-600 000-543 000-971 LOT-983 LOT-953덤프를 구매하기전 우선 pdf버전 덤프샘플을 다운받아 덤프문제를 공부해보시면ITExamDump덤프품질에 신뢰가 느껴질것입니다. ITExamDump의 IBM 000-600 000-543 000-971 LOT-983 LOT-953덤프가 고객님의 시험패스테 조금이나마 도움이 되신다면 행복으로 느끼겠습니다.

IBM인증 000-600 000-543 000-971 LOT-983 LOT-953시험을 패스하여 자격증을 취득하는게 꿈이라구요? ITExamDump에서 고객님의IBM인증 000-600 000-543 000-971 LOT-983 LOT-953시험패스꿈을 이루어지게 지켜드립니다. ITExamDump의 IBM인증 000-600 000-543 000-971 LOT-983 LOT-953덤프는 가장 최신시험에 대비하여 만들어진 공부자료로서 시험패스는 한방에 끝내줍니다.

000-543 덤프무료샘플다운로드하기: http://www.itexamdump.com/000-543.html

NO.1 A database contains two tables with the same definition and authorities: PRODUCTION.SALESDATA
and TEST.SALESDATA. The PRODUCTION.SALESDATA table contains business-critical information
that is constantly changing; the TEST.SALESDATA table contains a snapshot of the
PRODUCTION.SALESDATA table. Business rules require that applications under development access
the TEST.SALESDATA table until ready for deployment. Once an application is deployed, it accesses the
PRODUCTION.SALESDATA table.
Which object can be used to simplify switching between the TEST.SALESDATA and
PRODUCTION.SALESDATA tables without having to re-code the application?
A. trigger
B. procedure
C. alias
D. sequence
Answer: C

IBM덤프   000-543 dump   000-543자격증   000-543   000-543

NO.2 The table shown below contains a large number of financial transactions:
CREATE TABLE webstore.transactions (
transaction_id INTEGER NOT NULL PRIMARY KEY,
order_date TIMESTAMP NOT NULL,
shipped_date TIMESTAMP,
customer_id INTEGER NOT NULL,
shipping_info XML NOT NULL,
billing_info XML NOT NULL,
invoice XML NOT NULL )
Only members of the AUDIT_TEAM group have SELECT privilege on the WEBSTORE.TRANSACTIONS
table. For appropriate supply-chain management, members of the INVENTORY_CONTROL group need
to see the INVOICE document for each transaction that has a NULL SHIPPED_DATE, but are restricted
from seeing any shipping or billing information.
Which database object can a member of the AUDIT_TEAM group create to enable the
INVENTORY_CONTROL group to access the information needed from WEBSTORE.TRANSACTIONS?
A. alias
B. sequence
C. trigger
D. view
Answer: D

IBM   000-543   000-543   000-543   000-543

NO.3 Click the Exhibit button.
CREATE FUNCTION deptemployees (idept VARCHAR(3))
RETURNS TABLE (empno CHAR(6),
firstname VARCHAR(12),
lastname VARCHAR(15))
LANGUAGE SQL
READS SQL DATA
NO EXTERNAL ACTION
DETERMINISTIC
RETURN
SELECT empno, firstnme, lastname
FROM employee
WHERE workdept = deptemployees.idept;
Referring to the exhibit, what contains the proper way to invoke the DEPTEMPLOYEES() user-defined
function to return all of the employees that work in department D11?
A. SELECT * FROM TABLE(deptemployees('D11'))
B. SELECT * FROM deptemployees('D11')
C. SELECT * FROM deptemployees('D11') AS D11dept
D. SELECT * FROM TABLE(deptemployees('D11')) AS D11dept
Answer: D

IBM기출문제   000-543   000-543   000-543자료   000-543   000-543최신덤프

NO.4 Which object can be created to group together related procedures and user-defined functions that are
used for tax calculations?
A. collection
B. module
C. routine
D. routine space
Answer: B

IBM   000-543 pdf   000-543   000-543

NO.5 You have created a stored procedure (MULTIRESULTS()) on the server which will return multiple result
sets. While developing a PHP application using the IBM_DB2 extension, you want to call the stored
procedure. The code shown below will execute the stored procedure:
$stmt = db2_exec($conn, 'CALL multiResults()');
How can you fetch all of the result sets from $stmt?
A. Call db2_fetch_object($stmt) for the first result set; call db2_next_result($stmt) for more result sets.
B. Call db2_next_result($stmt) for each result set.
C. Call db2_fetch_object($stmt) for each result set.
D. Call db2_next_result($stmt) for each result set; call db2_fetch_object($stmt) for each row in the result
set.
Answer: A

IBM   000-543   000-543기출문제   000-543   000-543   000-543 dump

NO.6 Which SQL procedure will retrieve all the rows from table T1 and make those rows available to the
invoker as a result set?
A. CREATE PROCEDURE proc1()
DYNAMIC RESULTS SET 1
LANGUAGE SQL
SELECT * FROM t1
B. CREATE PROCEDURE proc1()
DYNAMIC RESULTS SET 1
LANGUAGE SQL
BEGIN
DECLARE c1 CURSOR WITH RETURN FOR SELECT * FROM t1;
OPEN c1;
END
C. CREATE PROCEDURE proc1()
DYNAMIC RESULTS SET 1
LANGUAGE SQL
RETURN (SELECT * FROM t1)
D. CREATE PROCEDURE proc1()
DYNAMIC RESULTS SET 1
LANGUAGE SQL
BEGIN
DECLARE c1 CURSOR FOR SELECT * FROM t1;
RETURN c1;
END
Answer: B

IBM   000-543   000-543   000-543

NO.7 In a query, which clause can reference a CLOB data type?
A. an ORDER BY clause
B. a GROUP BY clause
C. a WHERE clause
D. a DISTINCT clause
Answer: C

IBM덤프   000-543   000-543 dumps   000-543 pdf   000-543

NO.8 Which object can be invoked on a single invocation to return both output parameters and a result set
back to the invoking application?
A. procedure
B. module
C. table function
D. method
Answer: A

IBM   000-543   000-543최신덤프   000-543

NO.9 The statement below was used to create a cursor named CSR1:
DECLARE csr1 DYNAMIC SCROLL CURSOR FOR
SELECT * FROM employee;
After fetching all of the rows in the result set associated with cursor CSR1, which two statements can be
used to fetch the data starting at the end of the result set? (Choose two.)
A. FETCH LAST
B. FETCH PRIOR
C. FETCH RELATIVE
D. FETCH OFFSET
Answer: BC

IBM   000-543   000-543   000-543   000-543기출문제

NO.10 You have set your data types as CHAR(10), VARCHAR(20). Given the operation shown below:
CHAR(10) UNION VARCHAR(20)
What will be the final data type?
A. CHAR(200)
B. VARCHAR(30)
C. VARCHAR(20)
D. CHAR(30)
Answer: C

IBM   000-543덤프   000-543   000-543   000-543시험문제

NO.11 User USER1 successfully creates a table USER1.TABLE1 and successfully creates a package
USER1.PKG1 for an application containing the SQL shown below:
EXEC SQL UPDATE user1.table1 SET col1 = :hvar1 WHERE col1 IS NULL
Assuming user USER2 can connect to the database, but has no other relevant authorities, which
command must user USER1 issue to permit user USER2 to run the application?
A. GRANT ALTER ON TABLE user1.table1 TO USER user2
B. GRANT EXECUTE ON PACKAGE user1.pkg1 TO USER user2
C. GRANT UPDATE ON TABLE user1.table1 TO USER user2
D. GRANT BIND ON PACKAGE user1.pkg1 TO USER user2
Answer: B

IBM   000-543   000-543 dumps   000-543

NO.12 The table shown below exists in the database:
CREATE TABLE team.workitems ( priority INTEGER, last_update TIMESTAMP, details XML )
User USER1 has CREATEIN authority on the TEAM schema and can SELECT from the
TEAM.WORKITEMS table. An SQL routine is created that performs a positioned update using a cursor
declared as shown below:
DECLARE c_workitem CURSOR FOR SELECT priority, last_update FROM team.workitems FOR
UPDATE;
Which additional privilege is required?
A. EXECUTE privilege on TEAM schema
B. ALTER privilege on TEAM.WORKITEMS table
C. BINDADD privilege on TEAM schema
D. UPDATE privilege on TEAM.WORKITEMS table
Answer: D

IBM자료   000-543   000-543인증

NO.13 An existing table has the definition shown below:
CREATE TABLE hr.employees (
empid INTEGER NOT NULL PRIMARY KEY,
deptno INTEGER,
authid VARCHAR(255),
salary DECIMAL (10,2),
commission DECIMAL (5,3) DEFAULT 0,
benefits XML )
Only members of the HR_ADMIN group have privilege to SELECT, INSERT, UPDATE, or DELETE from
the HR.EMPLOYEES table. A Web-based application is under development that connects to the
database with a user's AUTHID and enables a user to see their record. No other records are visible.
Which type of database object can be created by a member of the HR_ADMIN that provides the
necessary information without changing the privileges on the HR.EMPLOYEES table?
A. trigger
B. view
C. alias
D. index
Answer: B

IBM   000-543 dump   000-543인증   000-543

NO.14 For which two database objects can an ALIAS be created? (Choose two.)
A. schema
B. trigger
C. sequence
D. module
Answer: CD

IBM   000-543 dump   000-543시험문제

NO.15 Click the Exhibit button.
CREATE TABLE store(sid INTEGER, info XML);
INSERT INTO store VALUES (1,
'<storeinfo sid="1">
<name>Grocery A</name>
<items>
<fruit><name>Mango</name><price>1.20</price></fruit>
<fruit><name>Apple</name><price>0.50</price></fruit>
<dessert><name>Ice Cream</name><price>6.00</price></dessert>
</items>
</storeinfo>');
Given the statements shown in the exhibit, a user executes the query shown below:
XQUERY for $store in db2-fn:xmlcolumn('STORE.INFO')/storeinfo
let $items := $store/items/fruit, $count := fn:count($items)
return <itemcount>$count</itemcount>
What is the output?
A. 2
B. <itemcount>2</itemcount>
C. <itemcount>1</itemcount>
D. <itemcount>$count</itemcount>
Answer: D

IBM인증   000-543자격증   000-543

NO.16 An application must insert values into a column that has a TIMESTAMP data type.
What is a valid string representation of a TIMESTAMP?
A. 2009.08.07.12.22.22.0000
B. 2009-08-07 12:22:22.0000
C. 07/08/2009-12:22:22:0000
D. 07-08-2009 12.22.22.0000
Answer: B

IBM   000-543   000-543

NO.17 Which statement is true of an application that only uses static SQL?
A. The authorization ID of program creator is used to qualify explicitly qualified table references on a
DROP statement.
B. Static SQL uses SQLDA to determine the number of rows successfully fetched on a FETCH statement.
C. The authorization ID of application creator is used to qualify implicitly qualified view references on an
UPDATE statement.
D. The authorization ID of application invoker used by DB2 to perform authorization checking of an
embedded OPEN statement during execution.
Answer: C

IBM   000-543자격증   000-543

NO.18 A database contains a table and a view declared as shown below:
CREATE TABLE s1.t1 ( c1 INTEGER, c2 CHAR(20) );
CREATE VIEW s1.v1 AS SELECT * FROM s1.t1;
A system administrator successfully executes the following code:
GRANT CONNECT, IMPLICIT_SCHEMA ON DATABASE TO user1;
GRANT INSERT ON TABLE s1.t1 TO user1;
GRANT CONTROL ON s1.v1 TO user1;
Which SQL statement does user USER1 have privileges to execute?
A. UPDATE s1.t1 SET c1 = 2 WHERE c1 IS NULL
B. CREATE VIEW user1.v2 AS SELECT * FROM s1.v1
C. CREATE PUBLIC ALIAS a1 FOR s1.v1
D. SELECT * FROM s1.t1 WHERE c2 < 100
Answer: B

IBM   000-543   000-543   000-543자격증   000-543자료

NO.19 Which condition will prevent a developer from using the DB2 Call Level Interface in an application?
A. The developer must control the cursor names to comply with company naming standards.
B. An SQL precompiler is not available to the developer.
C. The application must create an external scalar function with the CREATE FUNCTION statement.
D. The DECLARE CURSOR statement needs to be used.
Answer: D

IBM   000-543기출문제   000-543   000-543   000-543인증

NO.20 Click the Exhibit button.
CREATE TABLE s1.mytab (
col1 INTEGER GENERATED ALWAYS AS IDENTITY,
col2 INTEGER,
col3 INTEGER,
CHECK (col1+col3 < 500)
)
CREATE VARIABLE s1.var1 INTEGER DEFAULT (99)
CREATE FUNCTION s1.add100 (p1 INT, p2 INT)
RETURNS INTEGER
LANGUAGE SQL
DETERMINISTIC
NOT FENCED
BEGIN
SET p1= p2+100;
RETURN p1;
END
Given the table, variable, and function definitions shown in the exhibit, which two statements contain a
valid invocation of the add100 function? (Choose two.)
A. SELECT col1, outcol=add100(col2,col3) FROM mytab
B. SET var1 = ABS(add100(1,99))
C. SELECT col1, add100(col2,col3) AS outcol FROM mytab
D. SELECT outcol.* FROM TABLE(add100(col2,col3)) AS outcol
Answer: BC

IBM   000-543   000-543기출문제   000-543   000-543