which of the following is NOT an accurate statement?
If a view named V1 is created in such a way that it references every column in a table named
EMPLOYEE except a column named SALARY, which of the following is NOT an accurate
statement?
Which of the following statements is correct?
A companywide time server has been established and the AIX administrator has been asked
to configure all HMCs to connect to this time server. Which of the following statements is
correct?
Which of the following would NOT provide access to data stored in table TABLE1 using the name T1?
Which of the following would NOT provide access to data stored in table TABLE1 using the name
T1?
Which of the following commands describes the supported method to delete unneeded key from the authorized_keys
The root user in an LPAR has the ability to remotely execute CLI commands on an HMC
without being prompted for a password. That capability must be removed in order to comply
with security rules. Which of the following commands describes the supported method to
delete unneeded key from the authorized_keys2 file?
Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?
Which of the following DB2 objects can be referenced by an INSERT statement to generate values
for a column?
What is the most likely cause of this error?
An administrator suspects that an Ethernet adapter on the VIO server is down. Running
“entstat-all ent2” he received the following error message:
entstat: 0909-003 Unable to connect to device ent2, errno = 19
What is the most likely cause of this error?
What value will be returned by the query?
A sequence was created with the DDL statement shown below:
CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10
User USER1 successfully executes the following statements in the order shown:
VALUES NEXT VALUE FOR my_seq INTO :hvar;
VALUES NEXT VALUE FOR my_seq INTO :hvar;
User USER2 successfully executes the following statements in the order shown:
ALTER SEQUENCE my_seq RESTART WITH 5 INCREMENT BY 5 CACHE 5;
VALUES NEXT VALUE FOR my_seq INTO :hvar;
After users USER1 and USER2 are finished, user USER3 executes the following query:
SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1
What value will be returned by the query?
What will be the operational impact of hosting a Power 795 at an altitude in excess of 2134 meters (7000 feet)
What will be the operational impact of hosting a Power 795 at an altitude in excess of 2134
meters (7000 feet)?
Which of the following INSERT statements will fail to execute?
Given the following statements:
CREATE TABLE tab1 (c1 INTEGER, c2 CHAR(5));
CREATE VIEW view1 AS SELECT c1, c2 FROM tab1 WHERE c1 < 100;
CREATE VIEW view2 AS SELECT c1, c2 FROM view1
WITH CASCADED CHECK OPTION;
Which of the following INSERT statements will fail to execute?
What is the correct number of System Power Control Network (SPCN) cables required for maximum availability?
A system administrator is asked to review a proposed configuration for a 64 core Power 780
server that will have four 12X PCIe I/O Drawers. The intent is to ensure that the
configuration will support the ability to take any single enclosure (CEC) offline for
maintenance without isolating any of the 12X PCIe I/O Drawers from an SPCN segment
attached to an active Power 780 enclosure. What is the correct number of System Power
Control Network (SPCN) cables required for maximum availability?