Pass4Test offre une formation sur IBM 000-600 matériaux examen

Pass4Test a une équipe se composant des experts qui font la recherche particulièrement des exercices et des Q&As pour le test certification IBM 000-600, d'ailleurs ils peuvent vous proposer à propos de choisir l'outil de se former en ligne. Si vous avez envie d'acheter une Q&A de Pass4Test, Pass4Test vous offrira de matériaux plus détailés et plus nouveaux pour vous aider à approcher au maximum le test réel. Assurez-vous de choisir le Pass4Test, vous réussirez 100% le test IBM 000-600.

Vous aurez le service de la mise à jour gratuite pendant un an une fois que vous achetez le produit de Pass4Test. Vous pouvez recevoir les notes immédiatement à propos de aucun changement dans le test ou la nouvelle Q&A sortie. Pass4Test permet tous les clients à réussir le test IBM 000-600 à la première fois.

Les produits de Pass4Test a une bonne qualité, et la fréquence de la mise à jour est bien impressionnée. Si vous avez déjà choisi la Q&A de Pass4Test, vous n'aurez pas le problème à réussir le test IBM 000-600.

Pass4Test vous permet à réussir le test Certification sans beaucoup d'argents et de temps dépensés. La Q&A IBM 000-600 est recherchée par Pass4Test selon les résumés de test réel auparavant, laquelle est bien liée avec le test réel.

Code d'Examen: 000-600
Nom d'Examen: IBM (System z Solution Sales V4)
Questions et réponses: 57 Q&As

Peut-être vous voyez les guides d'études similaires pour le test IBM 000-600, mais nous avons la confiance que vous allez nous choisir finalement grâce à notre gravité d'état dans cette industrie et notre profession. Pass4Test se contribue à amérioler votre carrière. Vous saurez que vous êtes bien préparé à passer le test IBM 000-600 lorsque vous choisissez la Q&A de Pass4Test. De plus, un an de service gratuit en ligne après vendre est aussi disponible pour vous.

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

NO.1 The Solution edition for Data Warehousing includes which of the following components?
A. Foundational z/OS and DB2 for z/OS software to deploy a warehousing database on z/OS
B. DB2 for Linux on System z with Partitioning feature
C. Information Management software and OPTIM Data Privacy Solution
D. A pre-defined hardware configuration of 2 general processors and 2 zIIPs with 16 GByte of memory for
LPAR definitionWArialZ
Answer: A

certification IBM   000-600   certification 000-600   000-600 examen

NO.2 A prospect with a large number of Windows servers distributed across the globe is considering
migrating to single System z. The customer is very concerned with the rapid growth of his Windows
support staff, and the space used by the servers in the various locations.
Which of the following is likely to provide long term justification in this scenario?
A. Reduced Footprint size at the central location
B. Technical skill requirements
C. Power requirements
D. High AvailabilityWArialZ
Answer: B

certification IBM   certification 000-600   certification 000-600   000-600   000-600   000-600

NO.3 When discussing the flexibility of System z family of servers with a prospective customer, which of the
following is a key aspect?
A. Binary compatibility between servers
B. Hot pluggable processor and memory boards
C. Consistent CoD features with entire family
D. Ability to interchange features between systems WArialZ
Answer: A

certification IBM   000-600   certification 000-600

NO.4 A customer has selected the functionality from System z Solution Edition for Application Development
but is concerned about the financial impact of ordering the Solution Edition compared with the same
functionality as individual components.
Which of the following best describes the financial impact of System z Solution Editions for a customer?
A. Lower TCA and lower TCO
B. Lower TCA but no impact on TCO
C. Lower TCO but no impact on TCA
D. Lower TCA but higher TCOWArialZ
Answer: A

IBM   000-600   000-600   000-600 examen   certification 000-600   000-600

NO.5 What determines whether a special bid is eligible for Solution Edition pricing?
A. The bid includes incremental new workload representing growth on the platform and the business
situation requires a bottom line price.
B. The bid requires a bundled solution including hardware, software, maintenance and education.
C. The competitive context demands a bottom line price which can be met by adding the solution to an
existing LPAR.
D. The bid includes incremental new workload on a shared outsourced machine providing a lower
TCA.WArialZ
Answer: A

IBM   000-600 examen   000-600 examen   000-600   000-600 examen

NO.6 A System z10 retail customer with home written Cobol applications is considering replacement of their
older z/OS server with new technology. They do not believe a replacement would be less costly than
keeping their current server.
Which of the following factors in z10 are relevant in convincing them otherwise?
A. Application costs, z/OS maintenance, and floor space
B. MSU software savings, hardware maintenance, software efficiency
C. z/OS administration, hardware maintenance, and database costs
D. Floor space, power and cooling, z/OS maintenance, and hardware maintenanceWArialZ
Answer: B

IBM examen   000-600   certification 000-600   000-600

NO.7 The Solution Edition for Security with the System z mainframe and Centralized Identity and Access
Management provides significant benefits.
Which of the following describes those benefits?
A. Avoid the risks and exposures on System z platform and on other platforms in a business computing
environment
B. Avoid the risks and exposures on only the System z platform in a business computing environment
C. Avoid the risks and exposures on IBM servers only in a business computing environment
D. Avoid security risks for all customer installed servers in a business computing environment
Answer: A

certification IBM   000-600   000-600 examen   000-600

NO.8 What factors contribute to providing the lowest TCO for Java workloads deployed on z/OS?
A. Ease of use
B. Virtualized hardware and software
C. Availability of ISV solution software
D. IFL ICFWArialZ
Answer: B

certification IBM   000-600 examen   certification 000-600   000-600

NO.9 A prospective manufacturing customer with an existing complex environment is requesting a proposal
for a TSM data management solution. What should be the first step taken to validate the customer's
project?
A. Perform a TSM benchmark
B. Verify funding
C. Contact the IBM Software Sales Professional
D. Survey customer's current environmentWArialZ
Answer: C

IBM   000-600   000-600   000-600

NO.10 A customer has a defined policy of deploying new applications on distributed platforms. The customer
feels these platforms are "good enough" and less costly than their mainframe. A new, WebSphere-based,
mission-critical core application is under development and the customer has asked for price quotes on the
infrastructure for its deployment.
Which of the following meets these needs?
A. System z Solution Edition for WebSphere
B. System z Solution Edition for DB2 and System z Solution Edition for WebSphere
C. System z Solution Edition for Cloud Computing and System z Solution Edition for Application
Development
D. System z Solution Edition for DB2 and POWER6 servers for the application tierWArialZ
Answer: A

IBM   certification 000-600   000-600   000-600 examen   000-600 examen

Pass4Test est un bon site qui provide la façon efficace à se former à court terme pour réussir le test IBM 000-600, c'est un certificat qui peut améliorer le niveau de vie. Les gens avec le Certificat gagent beaucoup plus que les gens sans Certificat IBM 000-600. Vous aurez une space plus grande à se développer.

Pass4Test offre une formation sur IBM 000-600 matériaux examen

Pass4Test peut offrir la facilité aux candidats qui préparent le test IBM 000-600. Nombreux de candidats choisissent le Pass4Test à préparer le test et réussir finalement à la première fois. Les experts de Pass4Test sont expérimentés et spécialistes. Ils profitent leurs expériences riches et connaissances professionnelles à rechercher la Q&A IBM 000-600 selon le résumé de test réel IBM 000-600. Vous pouvez réussir le test à la première fois sans aucune doute.

Maintenant, beaucoup de professionnels IT prennent un même point de vue que le test IBM 000-600 est le tremplin à surmonter la pointe de l'Industrie IT. Beaucoup de professionnels IT mettent les yeux au test Certification IBM 000-600.

Code d'Examen: 000-600
Nom d'Examen: IBM (System z Solution Sales V4)
Questions et réponses: 57 Q&As

Le test Certification IBM 000-600 est une chance précieuse à augmenter vos connaissances de technologie informatique dans l'industrie IT. Il attire beaucoup de professionls à participer ce test. Pass4Test peut vous offrir les outils de formation particuliers à propos de test IBM 000-600. Vous réaliserez plus tôt votre rêve avec la Q&A écrite par l'équipe professionnelle de Pass4Test. Pass4Test se contribue à vous donner un coup de main pour réussir le test IBM 000-600.

Choisir le Pass4Test peut vous aider à réussir 100% le test IBM 000-600 qui change tout le temps. Pass4Test peut vous offrir les infos plus nouvelles. Dans le site de Pass4Test le servie en ligne est disponible toute la journée. Si vous ne passerez pas le test, votre argent sera tout rendu.

On peut télécharger quelques parties de Q&A gratuites dans le site Pass4Test à propos de test Certification IBM 000-600. Vous pouvez tester notre fiabilité via le démo. Choisir Pass4Test, c'est-à-dire que vous êtes proche d'un pic ensuite de l'Industrie IT.

Pour réussir le test IBM 000-600 demande beaucoup de connaissances professionnelles IT. Il n'y a que les gens qui possèdent bien les connaissances complètes à participer le test IBM 000-600. Maintenant, on a les autres façons pour se former. Bien que vous n'ayez pas une connaissance complète maintenant, vous pouvez quand même réussir le test IBM 000-600 avec l'aide de Pass4Test. En comparaison des autres façons, cette là dépense moins de temps et de l'effort. Tous les chemins mènent à Rome.

On doit faire un bon choix pour passer le test IBM 000-600. C'est une bonne affaire à choisir la Q&A de Pass4Test comme le guide d'étude, parce que vous allez obtenir la Certification IBM 000-600 en dépensant d'un petit invertissement. D'ailleur, la mise à jour gratuite pendant un an est aussi gratuite pour vous. C'est vraiment un bon choix.

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

NO.1 A prospect with a large number of Windows servers distributed across the globe is considering
migrating to single System z. The customer is very concerned with the rapid growth of his Windows
support staff, and the space used by the servers in the various locations.
Which of the following is likely to provide long term justification in this scenario?
A. Reduced Footprint size at the central location
B. Technical skill requirements
C. Power requirements
D. High AvailabilityWArialZ
Answer: B

certification IBM   000-600 examen   certification 000-600   000-600 examen

NO.2 The Solution edition for Data Warehousing includes which of the following components?
A. Foundational z/OS and DB2 for z/OS software to deploy a warehousing database on z/OS
B. DB2 for Linux on System z with Partitioning feature
C. Information Management software and OPTIM Data Privacy Solution
D. A pre-defined hardware configuration of 2 general processors and 2 zIIPs with 16 GByte of memory for
LPAR definitionWArialZ
Answer: A

certification IBM   certification 000-600   000-600 examen

NO.3 A customer has a defined policy of deploying new applications on distributed platforms. The customer
feels these platforms are "good enough" and less costly than their mainframe. A new, WebSphere-based,
mission-critical core application is under development and the customer has asked for price quotes on the
infrastructure for its deployment.
Which of the following meets these needs?
A. System z Solution Edition for WebSphere
B. System z Solution Edition for DB2 and System z Solution Edition for WebSphere
C. System z Solution Edition for Cloud Computing and System z Solution Edition for Application
Development
D. System z Solution Edition for DB2 and POWER6 servers for the application tierWArialZ
Answer: A

IBM examen   certification 000-600   000-600 examen   000-600   000-600

NO.4 A System z10 retail customer with home written Cobol applications is considering replacement of their
older z/OS server with new technology. They do not believe a replacement would be less costly than
keeping their current server.
Which of the following factors in z10 are relevant in convincing them otherwise?
A. Application costs, z/OS maintenance, and floor space
B. MSU software savings, hardware maintenance, software efficiency
C. z/OS administration, hardware maintenance, and database costs
D. Floor space, power and cooling, z/OS maintenance, and hardware maintenanceWArialZ
Answer: B

IBM   certification 000-600   000-600   certification 000-600

NO.5 A customer has selected the functionality from System z Solution Edition for Application Development
but is concerned about the financial impact of ordering the Solution Edition compared with the same
functionality as individual components.
Which of the following best describes the financial impact of System z Solution Editions for a customer?
A. Lower TCA and lower TCO
B. Lower TCA but no impact on TCO
C. Lower TCO but no impact on TCA
D. Lower TCA but higher TCOWArialZ
Answer: A

certification IBM   certification 000-600   000-600 examen   certification 000-600

NO.6 When discussing the flexibility of System z family of servers with a prospective customer, which of the
following is a key aspect?
A. Binary compatibility between servers
B. Hot pluggable processor and memory boards
C. Consistent CoD features with entire family
D. Ability to interchange features between systems WArialZ
Answer: A

IBM   certification 000-600   000-600 examen   000-600 examen

NO.7 A prospective manufacturing customer with an existing complex environment is requesting a proposal
for a TSM data management solution. What should be the first step taken to validate the customer's
project?
A. Perform a TSM benchmark
B. Verify funding
C. Contact the IBM Software Sales Professional
D. Survey customer's current environmentWArialZ
Answer: C

IBM examen   000-600   000-600 examen   000-600 examen   000-600

NO.8 What factors contribute to providing the lowest TCO for Java workloads deployed on z/OS?
A. Ease of use
B. Virtualized hardware and software
C. Availability of ISV solution software
D. IFL ICFWArialZ
Answer: B

IBM   000-600   000-600

NO.9 What determines whether a special bid is eligible for Solution Edition pricing?
A. The bid includes incremental new workload representing growth on the platform and the business
situation requires a bottom line price.
B. The bid requires a bundled solution including hardware, software, maintenance and education.
C. The competitive context demands a bottom line price which can be met by adding the solution to an
existing LPAR.
D. The bid includes incremental new workload on a shared outsourced machine providing a lower
TCA.WArialZ
Answer: A

IBM   certification 000-600   000-600

NO.10 The Solution Edition for Security with the System z mainframe and Centralized Identity and Access
Management provides significant benefits.
Which of the following describes those benefits?
A. Avoid the risks and exposures on System z platform and on other platforms in a business computing
environment
B. Avoid the risks and exposures on only the System z platform in a business computing environment
C. Avoid the risks and exposures on IBM servers only in a business computing environment
D. Avoid security risks for all customer installed servers in a business computing environment
Answer: A

IBM   certification 000-600   certification 000-600   000-600 examen   000-600

Pass4Test a une grande équipe composée des experts d'expérience dans l'industrie IT. Leurs connaissances professionnelles et les recherches font une bonne Q&A, qui vous permet à passer le test IBM 000-600. Dans Pass4Test, vous pouvez trouver une façon plus convenable à se former. Les resources de Pass4Test sont bien fiable. Choisissez Pass4Test, choisissez un raccourci à réussir le test IBM 000-600.

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