Databases | Practice Questions | Aliensbrain

Multiple choice technology databases

GET DIAGNOSTICS

Is used to obtain info about the previous executed sql statement
Analyze the db2diag error messages
Returns the user ID calling the stored proc
Gives the access plan of the packages

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

What is the Output ?

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

CREATE PROCEDURE wise.Test123 (IN VAR1 INTEGER) P1: BEGIN DECLARE C1 CURSOR WITH RETURN TO CLIENT FOR SELECT DISTINCT NO FROM (VALUES (1),(2),(3),(3),(2)) AS TEST (NO); SET VAR1= VAR1 * VAR1 +VAR1; END P1@ What happens when you call wise.Test123 (10)

Return Status = 0
3 rows returned by result-set
5 rows returned by result-set
110

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

A file rahul.db2 has following content : Drop procedure rahul ( ) @ Create procedure rahul ( ) P1: begin Declare c1 cursor with return to client for Select current date from sysibm.sysdummy1; Open c1; End P1 @ What will following command do when fired on db2 command linedb2 –td@ -f rahul.db2

NO SQL
CONTAINS SQL
READS SQL
MODIFIES SQL

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which of the following can be a user defined SQLSTATE

20000
35000
60000
71000

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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 ?

Will executes successfully
Fails as limit is 3 but only 2 opened
Executes with warning
Would not allow compiling the SP at the first place

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

What one is valid special register?

CURRENT_CLIENT_ACCT
CURRENT_SCHEMA
CURRENT_DATETIME
CURRENT_PARTITION

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

0.0
2
9
Null

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which is not a valid data type in DB2 LUW?

BIGINT
DECFLOAT
XML
DATETIME

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

DROP PROCEDURE testp; DROP PROCEDURE testp;
DROP PROCEDURE testp; DROP PROCEDURE testproc;
DROP SPECIFIC PROCEDURE testproc; DROP PROCEDURE testproc;
DROP PROCEDURE testproc(INT); DROP PROCEDURE testproc(INT);

Reveal answer Fill a bubble to check yourself

Tag: databases

Questions Related to databases