A2090-730問題集、IBM実際の試験問題

質問 1

Which of the following DB2 data types CANNOT be used to create an identity column?

A. SMALLINT

B. INTEGER

C. NUMERIC

D. DOUBLE

正解: D

質問 2

Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?

A. The cursor is protected from positioned updates and deletes that reference another cursor of a different application.

B. The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application

C. The cursor is only protected from updates and deletes by concurrent applications.

D. The row is only protected from positioned updates and deletes that reference another cursor of the same application.

正解: C

質問 3

Given the following tables:
CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43
6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West
How many rows would be returned using the following statement?
SELECT location FROM continents, region

A. 9

B. 14

C. 7

D. 2

正解: B

質問 4

What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?

A. A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table

B. A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

C. A unique constraint on the EMPLOYEE table WORKDEPT column

D. A check constraint on the EMPLOYEE table

正解: B

質問 5

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

A. "<employee />"

B. "<p></p>"

C. "<name>John Doe</name>"

D. "<?xml version='1.0' encoding='UTF-8' ?>"

正解: D

質問 6

If a view named V1 is created in such a way that it references every column in a table named EMPLOYEE except a column named SALARY, which of the following is NOT an accurate statement?

A. View V1 does not have to reside in the same schema as the EMPLOYEE table

B. All data, except SALARY data that is stored in the EMPLOYEE table is copied to the physical location associated with view V1

C. View V1 can be used in the same context as the EMPLOYEE table for all data retrieval operations that do not acquire SALARY information

D. View V1 can be used as a data source for other views

正解: B

質問 7

If the following SQL statement is executed:
CREATE TABLE sales
(invoice_no NOT NULL PRIMARY KEY,
sales_date DATE,
sales_amt NUMERIC(7,2))
IN tbsp0, tbsp1, tbsp2, tbsp3
PARTITION BY RANGE (sales_date NULLS FIRST)
(STARTING '1/1/2007' ENDING '12/31/2007'
EVERY 3 MONTHS)
Which of the following statements is true?

A. Administrative tasks such as backing up, restoring, and reorganizing data stored in the SALES table must be done at the table level; not at the partition level

B. When resolving queries against the SALES table, each partition used is scanned asynchronously and the results of each partition scan are merged to produce the result data set returned

C. Data can be quickly rolled in and out of the SALES table by using the ATTACH PARTITION and DETACH PARTITION clauses of the ALTER TABLE statement

D. If an index is created for the SALES table, its data must be stored in table space TBSP0

正解: C

質問 8

What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?

A. Range

B. Check

C. Informational

D. Referential

正解: B

質問 9

Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?

A. REVOKE tom FROM CONNECT ON DATABASE BY USER bob

B. REVOKE tom FROM ACCESS ON DATABASE BY USER bob

C. REVOKE ACCESS ON DATABASE FROM USER bob

D. REVOKE CONNECT ON DATABASE FROM USER tom

正解: D

質問 10

Which of the following DB2 data types has a fixed length?

A. DBCLOB

B. XML

C. BLOB

D. DOUBLE

正解: D

質問 11

Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?

A. Unique

B. Check

C. Informational

D. Referential

正解: B

質問 12

Which of the following is NOT true about XML columns?

A. Access to any portion of an XML document can be direct, without reading the whole document.

B. Data can be retrieved by SQL.

C. XML columns must be altered to accommodate additional parent and child relationships.

D. Data can be retrieved byXQuery.

正解: C

質問 13

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?

A. ID | EMPSALARY ----------------- 10 | 60000.00 20 | 60000.00 ----------------

B. ID | EMPSALARY ----------------- 10 | 50000.00 20 | 50000.00 ----------------

C. ID | EMPSALARY ----------------- 10 | 60000 20 | 50000.00 ----------------

D. ID | EMPSALARY ----------------- 10 | 60000.00 20 | 50000.00 ----------------

正解: A

質問 14

If an application issues the same query more than once in the same Unit of Work, which isolation level will not permit this application to see additional rows inserted by other applications?

A. Read Stability (RS)

B. Uncommitted Read (UR)

C. Cursor Stability (CS)

D. Repeatable Read (RR)

正解: D

IBM Assessment: DB2 9 Family Fundamentals - A2090-730 模擬練習