显示标签为“000-971”的博文。显示所有博文
显示标签为“000-971”的博文。显示所有博文

2014年3月21日星期五

Les meilleures IBM 000-971 examen pratique questions et réponses

Selon les feedbacks les professionnels bien réputés dans l'Industrie IT, Pass4Test est un bon catalyseur de leurs succès. L'outil de formation offert par Pass4Test leur aide d'économiser le temps et l'argent, le plus important est qu'ils aient passé le test IBM 000-971 avec succès. Pass4Test est un fournissur fiable. Vous allez réaliser votre rêve avec l'aide de Pass4Test.

Pass4Test est un site web qui vous donne plus de chances à passer le test de Certification IBM 000-971. Le résultat de recherche sortis par les experts de Pass4Test peut assurer que ce sera vous ensuite qui réussirez le test IBM 000-971. Choisissez Pass4Test, choisissez le succès. L'outil de se former de Pass4Test est bien efficace. Parmi les gens qui ont déjà passé le test, la majorité a préparé le test avec la Q&A de Pass4Test.

C'est sûr que le Certificat IBM 000-971 puisse améliorer le lendemain de votre carrière. Parce que si vous pouvez passer le test IBM 000-971, c'est une meilleure preuve de vos connaissances professionnelles et de votre bonne capacité à être qualifié d'un bon boulot. Le Certificat IBM 000-971 peut bien tester la professionnalité de IT.

Le programme de formation IBM 000-971 offert par Pass4Test comprend les exercices et les test simulation. Vous voyez aussi les autres sites d'offrir l'outil de formation, mais c'est pas difficile à découvrir une grand écart de la qualité entre Pass4Test et les autres fournisseurs. Celui de Pass4Test est plus complet et convenable pour la préparation dans une courte terme.

Finalement, la Q&A IBM 000-971 plus nouvelle est lancé avec tous efforts des experts de Pass4Test. Aujourd'hui, dans l'Industrie de IT, si on veut se renforcer sa place, il faut se preuve la professionnalité aux les autres. Le test IBM 000-971 est une bonne examination des connaissances professionnelles. Avec le passport de la Certification IBM, vous aurez un meilleur salaire et une plus grande space à se développer.

Code d'Examen: 000-971
Nom d'Examen: IBM (System i Administrator V5.07.11)
Questions et réponses: 138 Q&As

En quelques années, le test de certification de IBM 000-971 faisait un grand impact sur la vie quotidienne pour pas mal de gens. Voilà le problème, comme on peut réussir facilement le test de IBM 000-971? Notre Pass4Test peut vous aider à tout moment à résourdre ce problème rapidement. Pass4Test peut vous offrir une bonne formation particulière à propos du test de certification 000-971. Notre outil de test formation est apporté par les IT experts. Chez Pass4Test, vous pouvez toujours trouver une formations à propos du test Certification 000-971, plus nouvelle et plus proche d'un test réel. Tu choisis le Pass4Test aujourd'hui, tu choisis le succès de test Certification demain.

000-971 Démo gratuit à télécharger: http://www.pass4test.fr/000-971.html

NO.1 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 examen   certification 000-971   000-971

NO.2 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 examen   certification 000-971   000-971

NO.3 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 examen   certification 000-971   000-971

NO.4 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 examen   certification 000-971   000-971

NO.5 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 examen   certification 000-971   000-971

NO.6 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 examen   certification 000-971   000-971

NO.7 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 examen   certification 000-971   000-971

NO.8 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 examen   certification 000-971   000-971

NO.9 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 examen   certification 000-971   000-971

NO.10 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 examen   certification 000-971   000-971

NO.11 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 examen   certification 000-971   000-971

NO.12 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 examen   certification 000-971   000-971

NO.13 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 examen   certification 000-971   000-971

NO.14 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 examen   certification 000-971   000-971

NO.15 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 examen   certification 000-971   000-971

NO.16 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 examen   certification 000-971   000-971

NO.17 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 examen   certification 000-971   000-971

NO.18 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 examen   certification 000-971   000-971

NO.19 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 examen   certification 000-971   000-971

NO.20 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 examen   certification 000-971   000-971

Le Pass4Past possède une équipe d'élite qui peut vous offrir à temps les matériaux de test Certification IBM 000-971. En même temps, nos experts font l'accent à mettre rapidement à jour les Questions de test Certification IT. L'important est que Pass4Test a une très bonne réputation dans l'industrie IT. Bien que l'on n'ait pas beaucoup de chances à réussir le test de 000-971, Pass4Test vous assure à passer ce test par une fois grâce à nos documentations avec une bonne précision et une grande couverture.

2013年7月31日星期三

Pass4Test offre de IBM LOT-702 000-670 000-600 000-543 000-971 matériaux d'essai

Dans cette société de plus en plus intense, nous vous proposons à choisir une façon de se former plus efficace : moins de temps et d'argent dépensé. Pass4Test peut vous offrir une bonne solution avec une plus grande space à développer.


Le test IBM LOT-702 000-670 000-600 000-543 000-971 est très important dans l'Industrie IT, tous les professionnels le connaîssent ce fait. D'ailleur, c'est difficile à réussir ce test, toutefois le test IBM LOT-702 000-670 000-600 000-543 000-971 est une bonne façon à examiner les connaissances professionnelles. Un gens avec le Certificat IBM LOT-702 000-670 000-600 000-543 000-971 sera apprécié par beaucoup d'entreprises. Pass4Test est un fournisseur très important parce que beaucoup de candidats qui ont déjà réussi le test preuvent que le produit de Pass4Test est effectif. Vous pouvez réussir 100% le test IBM LOT-702 000-670 000-600 000-543 000-971 avec l'aide de Pass4Test.


Le Pass4Past possède une équipe d'élite qui peut vous offrir à temps les matériaux de test Certification IBM LOT-702 000-670 000-600 000-543 000-971. En même temps, nos experts font l'accent à mettre rapidement à jour les Questions de test Certification IT. L'important est que Pass4Test a une très bonne réputation dans l'industrie IT. Bien que l'on n'ait pas beaucoup de chances à réussir le test de LOT-702 000-670 000-600 000-543 000-971, Pass4Test vous assure à passer ce test par une fois grâce à nos documentations avec une bonne précision et une grande couverture.


Pass4Test est un seul site web qui peut offrir toutes les documentations de test IBM LOT-702 000-670 000-600 000-543 000-971. Ce ne sera pas un problème à réussir le test IBM LOT-702 000-670 000-600 000-543 000-971 si vous préparez le test avec notre guide d'étude.


Pass4Test possède un l'outil de formation particulier à propos de test IBM LOT-702 000-670 000-600 000-543 000-971. Vous pouvez améliorer les techniques et connaissances professionnelles en coûtant un peu d'argent à courte terme, et vous preuver la professionnalité dans le future proche. L'outil de formation IBM LOT-702 000-670 000-600 000-543 000-971 offert par Pass4Test est recherché par les experts de Pass4Test en profitant les expériences et les connaissances riches.


Code d'Examen: LOT-702

Nom d'Examen: IBM (IBM Lotus Notes Domino 7 System Administration Update)

Questions et réponses: 90 Q&As

Code d'Examen: 000-670

Nom d'Examen: IBM (IBM Systems Networking Technical Support V1)

Questions et réponses: 139 Q&As

Code d'Examen: 000-600

Nom d'Examen: IBM (System z Solution Sales V4)

Questions et réponses: 57 Q&As

Code d'Examen: 000-543

Nom d'Examen: IBM (DB2 9.7 Application Development)

Questions et réponses: 100 Q&As

Code d'Examen: 000-971

Nom d'Examen: IBM (System i Administrator V5.07.11)

Questions et réponses: 138 Q&As

000-543 Démo gratuit à télécharger: http://www.pass4test.fr/000-543.html


NO.1 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   000-543   000-543   000-543 examen

NO.2 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

certification IBM   000-543 examen   000-543 examen   000-543 examen

NO.3 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   certification 000-543   000-543   000-543 examen

NO.4 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 examen   000-543 examen   000-543   000-543

NO.5 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

certification IBM   certification 000-543   000-543 examen   000-543   certification 000-543

NO.6 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 examen   000-543 examen

NO.7 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 examen   000-543

NO.8 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 examen   000-543 examen   000-543 examen

NO.9 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   certification 000-543   certification 000-543

NO.10 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   certification 000-543   000-543   000-543

NO.11 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   certification 000-543   000-543   000-543 examen   000-543 examen

NO.12 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   000-543   000-543

NO.13 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

certification IBM   000-543   000-543 examen

NO.14 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 examen   000-543

NO.15 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

certification IBM   certification 000-543   000-543 examen   000-543

NO.16 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 examen   000-543   000-543

NO.17 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 examen   000-543   certification 000-543   certification 000-543   certification 000-543

NO.18 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 examen   000-543 examen   000-543 examen   000-543

NO.19 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 examen   certification 000-543   certification 000-543   000-543 examen   certification 000-543

NO.20 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

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