A2090-730最も有効な質問と解答で勉強

2026年にIBM Assessment: DB2 9 Family Fundamentalsへ挑戦するなら、再受験にかかる費用負担はできるだけ避けたいところです。Tech4ExamのA2090-730練習問題で本番形式の問い方に慣れておけば、一度で結果を出すための土台づくりが進みます。

IBM A2090-730 試験概要:

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

IBM Assessment: DB2 9 Family Fundamentalsに関するよくあるご質問

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

問題 #1

Given the following table definition:
SALES INVOICE_NO CHAR(20) NOT NULL SALES_DATE DATE SALES_PERSON CHAR(20) REGION CHAR(20) SALES INTEGER
If the following SELECT statement is executed, which of the following describes the order of the rows in the result data set produced? SELECT * FROM sales

A. The rows are not sorted in any particular order.
B. The rows are sorted by INVOICE_NO in ascending order.
C. The rows are sorted by INVOICE_NO in descending order.
D. The rows are ordered based on when they were inserted into the table.

問題 #2

Which of the following is used to create and debug user-defined functions?

A. SQL Assist
B. Command Editor
C. Developer Workbench
D. Control Center

問題 #3

If the following SQL statements are executed:
CREATE TABLE make (makeid SMALLINT NOT NULL PRIMARY KEY,
make VARCHAR(25));
CREATE TABLE model (modelid SMALLINT,
model VARCHAR(25),
makeid SMALLINT,
CONSTRAINT const1 FOREIGN KEY (makeid)
REFERENCES make(makeid) ON DELETE RESTRICT);
And each table created is populated as follows:
MAKE
MAKEID MAKE
1 Ford 2 Chevrolet 3 Toyota
MODEL
MODELID MODEL MAKEID
1 Mustang 1 2 Escort 1 3 Malibu 2 4 Camry 3
If the following SQL statement is executed:
DELETE FROM make WHERE makeid = 1
What is the total number of rows that will be deleted?

A. 0
B. 2
C. 1
D. 3

問題 #4

Which of the following DB2 UDB isolation levels will only lock rows during read processing if another transaction tries to drop the table the rows are being read from?

A. Repeatable Read
B. Cursor Stability
C. Read Stability
D. Uncommitted Read

問題 #5

Given the following insert statement:
INSERT INTO product ( pid, description ) VALUES ( '100-100-01', XMLPARSE ( DOCUMENT '<product xmlns="http://posample.org" pid=''100-100-01'' > <description> <name>Snow Shovel, Basic 22in</name> <details>Basic Snow Shovel, 22in wide, straight handle with D-Grip</details> <price>9.99</price> <weight>1 kg</weight> </description> </product>' PRESERVE WHITESPACE ) );
Which of the following table definitions will support the insert statement above?

A. CREATE TABLE product
( pid VARCHAR(10) NOT NULL PRIMARY KEY,
name VARCHAR(128),
price DECIMAL(30,2),
promoprice DECIMAL(30,2),
promostart DATE, promoend DATE, description XML);
B. CREATE TABLE product
( pid XML NOT NULL PRIMARY KEY,
name VARCHAR(128),
price DECIMAL(30,2),
promoprice DECIMAL(30,2),
promostart DATE,
promoend DATE,
description XML);
C. CREATE TABLE product
( pid XML NOT NULL PRIMARY KEY,
name VARCHAR(128),
price DECIMAL(30,2),
promoprice DECIMAL(30,2),
promostart DATE,
promoend DATE,
description VARCHAR(1000));
D. CREATE TABLE product
( pid VARCHAR(10) NOT NULL PRIMARY KEY,
name VARCHAR(128),
price DECIMAL(30,2),
promoprice DECIMAL(30,2),
promostart DATE,
promoend DATE,
description VARCHAR(1000));

解説：