How many new records will be written to the database?
Given the following statements:
CREATE TABLE t1 (c1 INTEGER, c2 CHAR(5));
CREATE TABLE t1audit (user VARCHAR(20), date DATE, action
VARCHAR(20));
CREATE TRIGGER trig1 AFTER INSERT ON t1
FOR EACH ROW
MODE DB2SQL
INSERT INTO t1audit VALUES (CURRENT USER, CURRENT DATE,
‘Insert’);
If user USER1 executes the following statements:
INSERT INTO t1 VALUES (1, ‘abc’);
INSERT INTO t1 (c1) VALUES (2);
UPDATE t1 SET c2 = ‘ghi’ WHERE c1 = 1;
How many new records will be written to the database?
What is the maximum possible number of logical ports supported per physical IVE port?
An administrator is planning to use the Integrated Virtual Ethernet (IVE) feature of a new
Power 770 to support the network connectivity requirement for the hosted LPARs, What is
the maximum possible number of logical ports supported per physical IVE port?
Which of the following is NOT an attribute of Declared Global Temporary Tables (DGTTs)?
Which of the following is NOT an attribute of Declared Global Temporary Tables (DGTTs)?
Which method is appropriate to compare system performance?
A customer would like to replace their POWER5 595 with a new POWER7 server. Which
method is appropriate to compare system performance?
Which of the following is an accurate statement about packages?
Which of the following is an accurate statement about packages?
What is a mandatory requirement to allow take-over should disruption occur?
A new release of a business-critical application is to be hosted in a customer’s home office
location. To reduce concerns regarding availability for the application, the customer will
deploy a second application instance into their Disaster Recovery (DR) location. If the home
office location becomes unavailable the DR location will take over hosting the application.
What is a mandatory requirement to allow take-over should disruption occur?
Which of the following will allow a client to access the database stored on the server?
Given the following information:
Protocol: TCP/IP
Port Number: 5000
Host Name: DB_SERVER
Database Name: TEST_DB
Database Server Platform: Linux
Which of the following will allow a client to access the database stored on the server?
Which option would meet the networking requirements while minimizing expenses?
A customer application deployment consists of two LPARs hosted on the same physical
system; one hosting a back-end database, the other hosting a customer-facing web
application. Since the hardware was ordered, the application design was updated to list a
requirement of a dedicated network link between the two LPARs. Which option would meet
the networking requirements while minimizing expenses?
Which object may be used during query optimization to improve the performance for a subset of SELECT queries?
Which object may be used during query optimization to improve the performance for a subset of
SELECT queries?
Which of the following is the most likely cause for this problem?
A customer is trying to configure a Shared Ethernet Adapter on a Logical Host Ethernet port
using the following command:
mkvdev -sea ent0 -vadapter ent2 -default ent2 -defaultid 1
The following response is received:
0514-040 error initializing a device into the kernel
Which of the following is the most likely cause for this problem?