Online Access Free 000-545 Exam Questions

Given the variable declaration shown below: DECLARE v_mydate DATE; Which statement will assign a value to the variable V_MYDATE?

• A.SELECT CURRENT TIMESTAMP INTO v_mydate FROM SYSIBM.SYSDUMMY1;
• B.VALUES CURRENT TIMESTAMP INTO v_mydate;
• C.VALUES (08262010) INTO v_mydate;
• D.SELECT CURRENT DATE INTO v_mydate FROM SYSIBM.SYSDUMMY1;

Which of the following CURSOR declare statement is incorrect?

• A.DECLARE c1 CURSOR WITHOUT RETURN FOR SELECT * FROM tab1
• B.DECLARE c1 SENSITIVE CURSOR WITH RETURN TO CLIENT FOR SELECT * FROM tab1
• C.DECLARE c1 INSENSITIVE CURSOR WITH RETURN TO CLIENT FOR SELECT * FROM tab1
• D.DECLARE c1 ASENSITIVE CURSOR WITH RETURN TO CLIENT FOR SELECT * FROM tab1

In the code segment shown below: Which statement accurately describes the result?

• A.For activities whose description has changed, update the description in the ACTIVITY table. For new activities, insert into the ACTIVITIES table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.
• B.For activities whose description has changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.
• C.For activities whose description has not changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.
• D.The statement will fail since MERGE is not a supported operator.

A trigger was created using the CREATE TRIGGER statement shown below.

Which statement is true about the INCRS_COMM trigger?

• A.The trigger will be executed before a row is inserted into the STAFF table.
• B.The trigger will be executed if the STAFF table is populated by a load operation.
• C.This trigger will increase the COMM value of a newly inserted row by 10 percent.
• D.This trigger will be executed after a row is inserted into the STAFF table.

Click the Exhibit button.

An SQL function was created using the statement shown in the exhibit. Assume this function is invoked by executing the SQL statement shown below:
VALUES e_degree(SMALLINT(17))
What will be returned?

• A.1
  MASTER 1 record(s) selected.
• B.1
  UNKNOWN 1 record(s) selected.
• C.1
  BACHELOR 1 record(s) selected.
• D.SQL0440N No authorized routine named "E_DEGREE" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884