IBM A2090-730 問題集

質問 1：
Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?
A. Unique
B. Informational
C. Referential
D. Check
正解：D

質問 2：
Which of the following DB2 tools allows a user to set DB2 registry parameters?
A. Configuration Assistant
B. Satellite Administration Center
C. Visual Explain
D. Task Center
正解：A

質問 3：
Given the following function:
CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END
How can this function be used in an SQL statement?
A. SELECTTABLE(EMPLIST()) AS t FROM EMPLOYEE
B. SELECT id,firstname, lastname FROM TABLE(EMPLIST()) AS t
C. SELECTTABLE(EMPLIST()) FROM EMPLOYEE
D. SELECTEMPLIST(id, firstname, lastname) FROM EMPLOYEE
正解：B

質問 4：
Given the following UPDATE statement:
UPDATE employees SET workdept =
(SELECT deptno FROM department WHERE deptno = 'A01')
WHERE workdept IS NULL
Which of the following describes the result if this statement is executed?
A. The statement will fail because an UPDATE statement cannot contain asubquery.
B. The statement will only succeed if every record in the EMPLOYEES table has a null value in the WORKDEPT column.
C. The statement will only succeed if the data retrieved by thesubquery does not contain multiple records.
D. The statement will succeed; if the data retrieved by thesubquery contains multiple records, only the first record will be used to perform the update.
正解：C

質問 5：
Which of the following is the major difference between relational data and XML data?
A. Relational data must be tabular; XML data does not have to be tabular
B. Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates
C. Relational data has inherent ordering; XML data does not
D. Relational data is self-describing; XML data is not
正解：A

質問 6：
Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?
A. REVOKE SELECT FROM user2 ON TABLE org.tab1
B. REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
C. REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
D. REVOKE SELECT ON TABLE org.tab1 FROM user2
正解：D

質問 7：
Given the following table definition:
SALES
SALES_DATE DATE
SALES_PERSON CHAR(20)
REGION CHAR(20)
SALES INTEGER
Which of the following SQL statements will remove all rows that had a SALES_DATE in the year
1995?
A. DELETE FROM sales WHEREYEAR(sales_date) = 1995
B. DROP FROM sales WHEREYEAR(sales_date) = 1995
C. DELETE * FROM sales WHEREYEAR(sales_date) = 1995
D. DROP * FROM sales WHEREYEAR(sales_date) = 1995
正解：A

質問 8：
The following triggers were defined for a table named SALES in the order shown:
CREATE TRIGGER trigger_a NO CASCADE BEFORE UPDATE ON sales REFERENCING NEW AS new FOR EACH ROW SET new.commission = sale_amt * .05 WHERE invoice = n.invoice;
CREATE TRIGGER trigger_b AFTER INSERT ON sales REFERENCING NEW AS new FOR EACH ROW UPDATE sales SET bill_date = CURRENT DATE + 30 DAYS WHERE invoice = n.invoice;
CREATE TRIGGER trigger_c NO CASCADE BEFORE DELETE ON sales FOR EACH ROW SIGNAL SQLSTATE '75005' SET MESSAGE_TEXT = 'Deletes not allowed!';
Which of the following statements is NOT true?
A. Whenever a row is inserted into the SALES table, the value in the BILL_DATE column is automatically set to 30 days from today
B. Whenever a row in the SALES table is updated, all three triggers are fired but nothing happens because none of the triggers have been coded to trap update operations
C. Once a row has been added to the SALES table, it cannot be removed
D. Each time a row is inserted into the SALES table, trigger TRIGGER_A is fired first, followed by trigger TRIGGER_B
正解：B