Question 1

Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?

Accepted Answer

TIME

Question 2

A solution developer needs to configure the HTTP listener of an Integration Server on a Linux Server. Which operating system privileges does the developer need to modify Integration node properties and properties of integration node resources?

Accepted Answer

root user

Question 3

which of the following represents a set of properties that guarantee that database transactions are processed reliably in computer science ?

Accepted Answer

ACID means (Atomicity, Consistency, Isolation, Durability) is a set of properties of database transactions intended to guarantee validity even in the event of errors, power failures, etc. In the context of databases, a sequence of database operations that satisfies the ACID properties and, thus, can be perceived as single logical operation on the data, is called a transaction. For example, a transfer of funds from one bank account to another, even involving multiple changes such as debiting one account and crediting another, is a single transaction.

Question 4

Proxy servers have two main purposes : 1. Improve Performance (and) 2. is ______ ?

Accepted Answer

Filter Requests

Question 5

Which of the following extenders allows data to be presented in a three dimensional format?

Accepted Answer

DB2 Spatial Extender

Question 6

The DBA can set the registry variable DB2_HASH_JOIN on or off because:

Accepted Answer

hash joins may require more resources to run.

Question 7

With database logging, where are transaction records first placed?

Accepted Answer

in the logical log buffer

Question 8

Suppose an installed z/OS customer also has Power6 Servers. They are investigating consolidation of both types of servers to z/OS.Which of the following will establish the capacity for a new z/OS server?

Accepted Answer

Estimate the AIX load and add to CP3000 results.

Question 9

Which statement fragments a table as round robin?

Accepted Answer

FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2

Question 10

Which statement correctly changes the next extent size?

Accepted Answer

ALTER TABLE customer MODIFY NEXT SIZE 300

Question 11

Suppose a System z customer has a new CIO. The CIO is concerned about continuing operations and recovery following a catastrophe.Which of the following addresses this issue?

Accepted Answer

GDPS

Question 12

Suppose a customer is attempting to determine what failed during the last boot sequence of the Linux partition. Which of the following can be used to determine the error condition?

Accepted Answer

/var/log/messages

Question 13

What are the advantages of fragmentation?

Accepted Answer

higher availability

Question 14

Explain Given the following SQL statement: GRANT REFERENCES ON TABLE tab1 TO USER usera.Which of the following describes what USERA is allowed to do?

Accepted Answer

Define a dependent table where TAB1 is the parent.

Question 15

What help ensure that the XIV Systems cache does not become a bottleneck?

Accepted Answer

each module is responsible for caching the data in that module

Question 16

Which of the following can be kept in memory when the DB2 configuration parameter KEEPFENCED is enabled?

Accepted Answer

Stored procedure processes after they are run.

Question 17

Which of the following commands will allow a Linux on iSeries administrator to quickly scan backup tapes for files saved via a tar command on a Linux system?

Accepted Answer

The Linux command cpio

Question 18

What is a requirement to connect a V6R1 IBM i host to an XIV Storage System?

Accepted Answer

Virtual I/O Server (VIOS) V2.1.1

Question 19

A VM/VSE customer wants to implement a WAS on an existing zSeries server. On which of the following operating environments would WAS best be implemented?

Accepted Answer

Linux

Question 20

How To improve system redundancy using its grid architecture, where in the XIV System can a partition be mirrored?

Accepted Answer

on disks in other modules

IBM Certification Questions