Which of the following actions will NOT cause a trigger to be fired?
A. INSERT
B. UPDATE
C. ALTER
D. DELETE
正解:C
質問 2:
Given the following stored procedure:
CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6),
OUT p_sum DECIMAL(9,2) )
SET p_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);
How can this stored procedure be called from the Command Line Processor?
A. VALUESincrease_salary('A00', ?)
B. CALLincrease_salary('A00', ?)
C. CALLincrease_salary('A00')
D. VALUESincrease_salary('A00')
正解:C
質問 3:
While attempting to connect to a database stored on an iSeries server from a Windows client, the
following message was displayed:
SQL1013N The database alias name or database name "TEST_DB" could not be found.
Which of the following actions can be used to help determine why this message was displayed?
A. Execute the LIST REMOTE DATABASES command on the server; look for an entry for the TEST_DB database
B. Execute the LIST REMOTE DATABASES command on the client; look for an entry for the TEST_DB database
C. Execute the LIST DCS DIRECTORY command on the server; look for an entry for the TEST_DB database
D. Execute the LIST DCS DIRECTORY command on the client; look for an entry for the TEST_DB database
正解:D
質問 4:
Which of the following is used to indicate a column will not accept NULL values and can be referenced in another table's foreign key specification?
A. Check constraint
B. Informational constraint
C. Unique constraint
D. Default constraint
正解:C
質問 5:
If the following SQL statements are executed in the order shown:
CREATE TABLE orders (order_num INTEGER NOT NULL, buyer_name VARCHAR(35), amount NUMERIC(5,2));
CREATE UNIQUE INDEX idx_orderno ON orders (order_num);
Which of the following describes the resulting behavior?
A. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows should be displayed in order of increasing ORDER_NUM values
B. Every ORDER_NUM value entered must be unique; no other index can be created for the ORDERS table that reference the ORDER_NUM column
C. Duplicate ORDER_NUM values are allowed; no other index can be created for the ORDERS table that reference the ORDER_NUM column
D. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows will be displayed in no particular order
正解:A
質問 6:
Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?
A. "<?xml version='1.0' encoding='UTF-8' ?>"
B. "<p></p>"
C. "<name>John Doe</name>"
D. "<employee />"
正解:A
質問 7:
Which two of the following allow you to perform administrative tasks against database objects?
A. Command Line Processor
B. Health Center
C. Task Center
D. Journal
E. Control Center
正解:A,E
Fujimoto -
A2090-730試験は独学で学習して合格出来ました。素人でもこれだけで十分だと思います。
ちゃんと問題集の内容を覚えれば本番は大丈夫です。オススメの教本です。