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
一戸** -
最初は試しの態度でPass4TestのA2090-545の問題集を購入してみたんだが、A2090-545問題集を所有する価値があります! 3日前に合格しました。