Tag: technology

Questions Related to technology

Which of the following can be a user defined SQLSTATE
technology databases

  1. 20000

  2. 35000

  3. 60000

  4. 71000

Show answer
Correct Option: D

A Simple stored procedure is created with Dynamic Result sets 3 However only 2 cursors with return to client are defined within the source code. What will happen when you call the SP ?
technology databases

  1. Will executes successfully

  2. Fails as limit is 3 but only 2 opened

  3. Executes with warning

  4. Would not allow compiling the SP at the first place

Show answer
Correct Option: A

What one is valid special register?
technology databases

  1. CURRENT_CLIENT_ACCT

  2. CURRENT_SCHEMA

  3. CURRENT_DATETIME

  4. CURRENT_PARTITION

Show answer
Correct Option: B

What will be the initial value of V_MAX in the declaration statement shown below? DECLARE v_max DECIMAL(9,2);
technology databases

  1. 0.0

  2. 2

  3. 9

  4. Null

Show answer
Correct Option: D

Which is not a valid data type in DB2 LUW?
technology databases

  1. BIGINT

  2. DECFLOAT

  3. XML

  4. DATETIME

Show answer
Correct Option: D

CREATE PROCEDURE testproc( IN i1 INT, INOUT i3 INT) SPECIFIC testproc BEGIN SET i3 = i1; END @ CREATE PROCEDURE testproc( IN i1 INT, INOUT i2 INT, INOUT i3 INT) SPECIFIC testp BEGIN SET i3 = i1 * i2; END @ Given that the statements in the exhibits have executed successfully, which solution contains the complete set of commands that could be used to drop both procedures in the order presented?
technology databases

  1. DROP PROCEDURE testp; DROP PROCEDURE testp;

  2. DROP PROCEDURE testp; DROP PROCEDURE testproc;

  3. DROP SPECIFIC PROCEDURE testproc; DROP PROCEDURE testproc;

  4. DROP PROCEDURE testproc(INT); DROP PROCEDURE testproc(INT);

Show answer
Correct Option: C

CREATE PROCEDURE p1() BEGIN CREATE TABLE T1 (C1 CHAR); INSERT INTO T1 VALUES ('A'); SAVEPOINT SAVEPOINT1 ON ROLLBACK RETAIN CURSORS; INSERT INTO T1 VALUES ('B'); SAVEPOINT SAVEPOINT2 ON ROLLBACK RETAIN CURSORS; INSERT INTO T1 VALUES ('C'); SAVEPOINT SAVEPOINT3 ON ROLLBACK RETAIN CURSORS; INSERT INTO T1 VALUES ('D'); ROLLBACK TO SAVEPOINT SAVEPOINT3; ROLLBACK TO SAVEPOINT SAVEPOINT1; COMMIT WORK; INSERT INTO T1 VALUES ('E'); END@ Call p1() @ How many rows will be present in Table T1
technology databases

  1. 0

  2. 1 (A)

  3. 5 (A,B,C,D,E)

  4. 2 (A,E)

Show answer
Correct Option: D

Which IBM tool can you use to debug stored procedure?
technology databases

  1. Control centre

  2. IBM Data studio

  3. Visual Explain

  4. Command editor

Show answer
Correct Option: B

What is the Output ?
technology databases

  1. Returns current date

  2. Generate the access plan

  3. Suggests performance hints that can be implemented

  4. Drop and create the stored procedure

Show answer
Correct Option: D

Which statement is true about a method?
technology programming languages

  1. A method is an implementation of an abstraction

  2. A method is an attribute defining the property of a particular abstraction

  3. A method is an operation defining the behavior for a particular abstraction

  4. A method is a blueprint for making operations

Show answer
Correct Option: C