Click the Exhibit button.
The table and triggers in the exhibit have been created successfully, when the statements shown below are executed.
INSERT INTO emp_hours VALUES('KAY', '9:00', '17:00');
INSERT INTO emp_hours (emp_name, starting) VALUES('BILL', '9:00');
What is the result?
A. Table EMP_HOURS will contain these rows: KAY 9:00:00 AM 5:00:00 PM BILL 9:00:00 AM
B. Table EMP_HOURS will contain this row: BILL 9:00:00 AM
C. Table EMP_HOURS will contain this row: BILL 9:00:00 AM 17:00:00 PM
D. Table EMP_HOURS will contain these rows: KAY 9:00:00 AM 5:00:00 PM BILL 9:00:00 AM 10:00:00 AM
正解:D
質問 2:
Which SQL statement is allowed in a BEFORE trigger?
A. CALL
B. INSERT
C. UPDATE
D. MERGE
正解:A
質問 3:
What is a reason to use SQL procedures in DB2?
A. to eliminate the need for testing
B. to move business logic rules into the database
C. to reduce code sharing
D. to use different programming languages
正解:B
質問 4:
Click the Exhibit button.
A trigger was created as shown in the exhibit.
The UPDATE statement shown below is executed. UPDATE dept SET sales_id = '300' WHERE sales_id = '200'
How many row(s) are updated in the EMPLOYEE table?
A. 0
B. 1
C. 3
D. 2
正解:B
質問 5:
Which statement can be used to define variable that can be shared between procedures?
A. DEFINE GLOBAL VARIABLE my_gl_var INTEGER
B. DECLARE my_gl_var INTEGER DEFAULT 1
C. CREATE OR REPLACE VARIABLE my_gl_var INTEGER
D. CREATE GLOBAL VARIABLE my_gl_var
正解:C
片冈** -
私はA2090-545試験を少なくとも一度はやり直さなければならないと思っていますが、今回は88のマークで合格したことに驚きました。よく出来ました!