IBM C2090-545 Online Practice Questions and Exam Preparation

IBM C2090-545 Online Questions & Answers

• Question 41:

  Click the Exhibit button.

  

  The table and triggers in the exhibit have been createdsuccessfully, 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 10:00:00 AM
  B. Table EMP_HOURS will contain this row: BILL 9:00:00 AM
  C. Table EMP_HOURS will contain these rows: KAY 9:00:00 AM 5:00:00 PM BILL 9:00:00 AM
  D. Table EMP_HOURS will contain this row: BILL 9:00:00 AM 17:00:00 PM
  A. 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

• Question 42:

  In which type of table space must global temporary tables be created?

  A. REGULAR
  B. LONG
  C. SYSTEM TEMPORARY
  D. USER TEMPORARY
  D. USER TEMPORARY

• Question 43:

  Which of the following CURSOR declare statement is incorrect?

  A. DECLARE c1 CURSOR WITHOUT RETURN FOR SELECT * FROM tab1
  B. DECLARE c1 ASENSITIVE 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 SENSITIVE CURSOR WITH RETURN TO CLIENT FOR SELECT * FROM tab1
  D. DECLARE c1 SENSITIVE CURSOR WITH RETURN TO CLIENT FOR SELECT * FROM tab1

• Question 44:

  The cursor BASEINFO was defined as follow:

  

  Which statement would be used to create a local variable named BASEINFOROW that can be used to store results from the BASEINFO cursor?

  A. DEFINE ROW baseinforow FOR CURSOR baseinfo
  B. DECLARE ROW baseinforow ASSOCIATED WITH CURSOR baseinfo
  C. DECLARE baseinforow ANCHOR ROW baseinfo
  D. CREATE VARIABLE baseinforow ASSOCIATED WITH baseinfo
  C. DECLARE baseinforow ANCHOR ROW baseinfo

• Question 45:

  Which of the following statements is true for declared global temporary tables(DGTT)?

  A. The value of the USER special register is the implicit schema name of the DGTT
  B. B. The DGTT must be stored in a system temporary table space
  C. SESSION is the implicit schema name of the DGTT
  D. The data in a DGTT cannot be compressed.
  C. SESSION is the implicit schema name of the DGTT

• Question 46:

  Which statement will create a scalar function named FCN1?

  A. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3)
  B. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) ?CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)
  C. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)
  D. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE FUNCTIONfcn1(v1 CHAR(3)) RETURNS CHAR(3)
  D. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE FUNCTIONfcn1(v1 CHAR(3)) RETURNS CHAR(3)

• Question 47:

  Given the following DDL:

  

  What will the SALARY be?

  A. salary * 1.03
  B. salary * 1.05
  C. salary * 1.10
  D. salary * 1.50
  D. salary * 1.50

• Question 48:

  A developer wants to code the following statements in an SQL procedure:

  

  What order must thesestatements be coded in?

  A. 1, 2, 3, 4
  B. 2, 4, 3, 1
  C. 3, 4, 2, 1
  D. 4, 3, 2, 1
  B. 2, 4, 3, 1

• Question 49:

  In the code segment shown below:

  

  Which statement accurately describes the result?

  A. 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.
  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 tableboth have ACTIVITY as a primary key.
  C. 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.
  D. The statement will fail since MERGE is not a supported operator.
  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 tableboth have ACTIVITY as a primary key.

• Question 50:

  Which of the following can be used to assign multiple values to a row data type variable?

  A. A SELECT * statement, a VALUES * statement, or a FETCH * statement.
  B. A SELECT INTO statement, a VALUES INTO statement, or a FETCH INTO statement.
  C. A DIRECT ASSIGNMENT statement.
  D. D. A VARIABLE VALUES statement.
  B. A SELECT INTO statement, a VALUES INTO statement, or a FETCH INTO statement.