Which of the following create index statements will meet this criteria and require the least amount of storage
Given the following DDL for the PARTS table:
CREATE TABLE parts
(part_no INT(9) NOT NULL,
part_name VARCHAR(24),
part_remain INT(9));
All part numbers entered will be different and all rows should be displayed in order of increasing
part numbers whenever the table is queried. Which of the following create index statements will
meet this criteria and require the least amount of storage for the index object?
which have been applied to the HMC?
Which of these HMC commands will display fixes which have been applied to the HMC?
Which of the following is a characteristic of a sequence?
Which of the following is a characteristic of a sequence?
what is the most likely cause of the failed paths?
A system administrator is updating the VIO Server levels in a frame supported by a dual VIO
Server pair. After applying the latest fixpack to the first VIO Server and rebooting the
administrator notices some of the VIO Server clients have failed paths to the storage as
reported by Ispath. After confirming the upgraded VIO Server is presenting all disks without
any errors what is the most likely cause of the failed paths?
What is the current value of the :con1hvar host variable?
A sequence was created with the DDL statement shown below:
CREATE SEQUENCE my_sequence CACHE 10 ORDER
The following statements are successfully executed in sequence through separate database
connections:
CONNECTION1 – VALUES NEXT VALUE FOR my_sequence INTO :con1hvar
CONNECTION2 – VALUES NEXT VALUE FOR my_sequence INTO :con2hvar
CONNECTION1 – VALUES NEXT VALUE FOR my_sequence INTO :con1hvar
What is the current value of the :con1hvar host variable?
How can the customer minimize expenses while increasing memory for the web and database applications?
A customer with a Power 780 has 2 LPARs supporting database servers, and 4 LPARs
supporting web servers. The web servers are very busy during the daytime, and the
database servers have heavy night time activity. More memory is needed to make
applications process more quickly. How can the customer minimize expenses while
increasing memory for the web and database applications?
Which value will be returned by the query?
A sequence was created with the DDL statement shown below:
CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5
User1 successfully executes the following statements in Connection1:
VALUES NEXT VALUE FOR my_seq INTO :con1hvar
VALUES NEXT VALUE FOR my_seq INTO :con1hvar
User2 successfully executes the following statement in Connection2:
VALUES NEXT VALUE FOR my_seq INTO :con2hvar
After User1 & User2 are finished, User3 executes the following statement in Connection3:
SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1
Which value will be returned by the query?
what is the most likely cause of the problem?
An administrator notices that an AIX partition can’t ping its default gateway. The LPAR is
connected to the network using Shared Ethernet Adapter (SEA).
A partial output from the entstat command displays:
Based on the output, what is the most likely cause of the problem?
which DB2 object?
An Alias can be an alternate name for which DB2 object?
What command is used to identify dynamically reconfigurable PCI adapters currently available in a machine?
What command is used to identify dynamically reconfigurable PCI adapters currently
available in a machine?