最新的IBM Assessment: DB2 9 Family Fundamentals - A2090-730免費考試真題
Which of the following actions may cause a trigger to be fired?
正確答案: C
Application A issues the following SQL statements within a single transaction using the
Uncommitted Read isolation level:
SELECT * FROM department WHERE deptno = 'A00';
UPDATE department SET mgrno = '000100' WHERE deptno = 'A00';
As long as the transaction is not committed, which of the following statements is FALSE?
Uncommitted Read isolation level:
SELECT * FROM department WHERE deptno = 'A00';
UPDATE department SET mgrno = '000100' WHERE deptno = 'A00';
As long as the transaction is not committed, which of the following statements is FALSE?
正確答案: D
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?
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?
正確答案: B
Assuming table TAB1 contains 100 rows, which of the following queries will return only half of the rows available?
正確答案: A
Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?
正確答案: A
When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens?
正確答案: B
Which of the following are all valid DB2 data types?
正確答案: B
Which of the following tools can be used to automate table reorganization operations?
正確答案: B
Given the following expression:
SELECT QUANTITY,
CASE WHEN ITEMCODE = '099' THEN "SILVER"
WHEN ITEMCODE = '788' THEN "GOLD"
WHEN ITEMCODE = '899' THEN "PLATINUM"
ELSE ERROR
END
FROM SUPPLIER
What will be the result of the query if the following data is evaluated by the CASE expression?
QUANTITY ITEMCODE
3 099 4 099 1 788 1 899 5 009 3 788 1 899
SELECT QUANTITY,
CASE WHEN ITEMCODE = '099' THEN "SILVER"
WHEN ITEMCODE = '788' THEN "GOLD"
WHEN ITEMCODE = '899' THEN "PLATINUM"
ELSE ERROR
END
FROM SUPPLIER
What will be the result of the query if the following data is evaluated by the CASE expression?
QUANTITY ITEMCODE
3 099 4 099 1 788 1 899 5 009 3 788 1 899
正確答案: D
Which of the following are types of routine objects?
正確答案: B
Which of the following products is used to shred extensible markup language documents?
正確答案: C
Which two of the following allow you to perform administrative tasks against database objects?
正確答案: A,D