最新のA2090-730問題集で試験を準備する

IBM A2090-730 試験概要:

IBM A2090-730 試験シラバストピック:

IBM Assessment: DB2 9 Family Fundamentals 認定 A2090-730 試験問題：

1. Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?

A) "<p></p>"
B) "<name>John Doe</name>"
C) "<?xml version='1.0' encoding='UTF-8' ?>"
D) "<employee />"

2. Given the following table definitions:
EMPLOYEE ID NAME DEPTID
01 Smith 10 02 Bossy 20 03 Peterson 20 04 Goss 30 05 Pape 40 06 Avery 50 07 O'Neal 60 08 Carter 50 DEPARTMENT ID DEPTNAME
05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and the following query:
SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4
Which of the following queries will produce the same result set as the query above?

A) SELECT e.id,d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id > 4
B) SELECT e.id,d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4
C) SELECT e.id,d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4 UNION ALL SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4
D) SELECT e.id,d.deptname FROM employee e, department d WHERE e.id > 4

3. A table named DEPARTMENT has the following columns:
DEPT_ID DEPT_NAME MANAGER AVG_SALARY
Which of the following is the best way to prevent most users from viewing AVG_SALARY data?

A) Encrypt the table's data
B) Revoke SELECT access for the AVG_SALARY column from users who should not see AVG_SALARY data
C) Create a view that does not contain the AVG_SALARY column
D) Store AVG_SALARY data in a separate table and grant SELECT privilege for that table to the appropriate users

4. Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?

A) DB2 Workgroup Server Edition
B) DB2 Express Edition
C) DB2Enterprise Server Edition
D) DB2 Personal Edition

5. Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?

A) When inserting a row in TABLE2, DB2 will only allow foreign values forIDCOL2, that is values which do not exist in IDCOL1.
B) DB2 will no longer allow updating the value of IDCOL1 in TABLE1.
C) When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.
D) When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.

質問と回答：