How many of these INSERT statements will be successful?
Given the following DDL and INSERT statements:
CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10;
CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION;
CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100;
INSERT INTO v1 VALUES(5);
INSERT INTO v2 VALUES(5);
INSERT INTO v3 VALUES(20);
INSERT INTO v3 VALUES(100);
How many of these INSERT statements will be successful?
Why does pmcycles report a slower clock speed than isattr?
Given the output from the following commands:
Why does pmcycles report a slower clock speed than isattr?
what happens?
When a client using the SERVER_ENCRYPT authentication type connects to a server using the
SERVER authentication type, what happens?
which of the following hdisk attributes must be set to a specific value?
An administrator is preparing fibre-channel attached LUNs to be presented to an LPAR using
virtual SCSI. In a dual VIO Server configuration, which of the following hdisk attributes must
be set to a specific value?
Which DB2 object can be referenced by an INSERT statement to meet this requirement?
A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID
column values need to be incremented by 1000 for each new expense report added to the
EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet this
requirement?
Which of the following metrics would help the administrator determine the minimum RAM required to host the RDB
An administrator is evaluating consolidating Power servers running relational database
management systems (RDBMS). After reviewing the collection of nmon andtopas data for
the candidate systems, the administrator is concerned by the total amount of RAM that the
consolidation seems to require, based on the RAM allocated to each candidate system. The
administrator reviews the memory sections of thetopas data to see if reducing total RAM
required is possible. None of the systems indicate any activity to the paging spaces. Which
of the following metrics would help the administrator determine the minimum RAM required
to host the RDBMS partitions in the consolidated environment?
What is the current content of the staffsalary table?
The following SQL statements were executed in sequence:
CREATE DISTINCT TYPE salary AS decimal(7,2) WITH COMPARISONS;
CREATE TABLE staffsalary(empid INT, empsalary salary);
INSERT INTO staffsalary VALUES (10, 50000), (20, 50000.00);
UPDATE staffsalary SET empsalary = 60000
WHERE salary(50000) = empsalary;
What is the current content of the staffsalary table?
What is the most likely reason this is occurring?
An administrator is asked to issue the following command on the system:
vmo-o lgpg_size=16777216-0 lgpg_regions=512
The administrator issues ‘svmon -G1 and notices that almost all of the memory in the system
is used even though the primary application is not started.
What is the most likely reason this is occurring?
Which of the following provides a logical grouping of database objects?
Which of the following provides a logical grouping of database objects?
Which of the following recording approaches supports the requirement?
A system administrator wants to use topasrec to collect processor performance data for all
AIX LPARs on one Power 795. Seven days of data will be collected, with one data file
created per day. Which of the following recording approaches supports the requirement?