Which of the following objects contains control structures that are considered the bound form of SQL statement
Which of the following objects contains control structures that are considered the bound form of
SQL statements?
which can be run simultaneously?
A customer bought a Power 770 for AIX and IBM i applications. After some time, they also
decided to move existing Linux workloads which can take advantage of a large number of
multi-threaded processes on a POWER7 processor. Which Linux distribution maximizes the
number of threads which can be run simultaneously?
Which of the following commands is used to retrieve database names from the local catalog for DRDA host databa
Which of the following commands is used to retrieve database names from the local catalog for
DRDA host databases on System i and System z?
How many private network connections are needed between a four-enclosure Power 770 and the HMC?
How many private network connections are needed between a four-enclosure Power 770
and the HMC?
Which of the following are types of routine objects?
Which of the following are types of routine objects?
Which ioscli command show the disks currently available for allocation?
An administrator needs to allocate a new disk to a virtual client from a VIO Server partition.
Which ioscli command show the disks currently available for allocation?
which DB2 object?
A stored procedure object is created into which DB2 object?
What is the most likely cause of the problem?
An administrator configured Shared Ethernet Adapter with failover and VLAN tagging. After
some time network administrators noticed a broadcast storm in the network. They traced the
problem and detected that one of the VIO servers is flooding the network. What is the most
likely cause of the problem?
How many rows will be deleted by the following DELETE statement?
The following statements:
CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY (col1));
CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2),
FOREIGN KEY (col1) REFERENCES t1 (col1)
ON DELETE CASCADE ON UPDATE RESTRICT);
CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),
FOREIGN KEY (col1) REFERENCES t1 (col1)
ON DELETE NO ACTION ON UPDATE RESTRICT);
INSERT INTO t1 VALUES (1), (2);
INSERT INTO t2 VALUES (1, ‘a’), (1, ‘b’), (2,’c’);
INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);
How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE
col1 = 1;
Which tool, when used on the Power 570 LPAR, will provide the data necessary for the administrators to estimat
A system administrator and application administrator are considering moving a production
application running in an AIX 6 LPAR from a Power 570 server to a Power 770 server. Due
to resource constraints the LPAR would employ Active Memory Expansion on the Power
770. Both administrators are hesitant to employ a new function in a production LPAR without
some analysis beforehand. Which tool, when used on the Power 570 LPAR, will provide the
data necessary for the administrators to estimate the consequences of moving the
application and invoking Active Memory Expansion?