Tag: technology

Questions Related to technology

Which of the following is used by assemblies to find each other?
technology web technology

  1. Searching directory paths

  2. Cannot find each other by any method

  3. By pointers

  4. None of the Above

Show answer
Correct Option: A

Which of the following concepts can be used to prevent a .NET web applet from formatting the hard disk?
technology web technology

  1. CLR

  2. CAS

  3. Both A) and B)

  4. None of the Above

Show answer
Correct Option: B

Which of the following denote the method used for compatible type conversions?
technology web technology

  1. TypeCov()

  2. Type()

  3. CTyp()

  4. CType()

Show answer
Correct Option: D

Constants are declared using the keyword
technology web technology

  1. Constant

  2. Const

  3. Consta

  4. Fixed

Show answer
Correct Option: B

To use Global temporary tables in a compound statement you require which type of tablespace to be present
technology databases

  1. User temporary

  2. Large

  3. System

  4. Regular

Show answer
Correct Option: A

Which of the following is not true for Stored Procedures?
technology databases

  1. Simplifies code reuse, code standardization and code maintenance

  2. Controlled access to other database objects

  3. Improving application performance

  4. DB2 Stored Procedures can be written only in SQL.

Show answer
Correct Option: D

GET DIAGNOSTICS
technology databases

  1. Is used to obtain info about the previous executed sql statement

  2. Analyze the db2diag error messages

  3. Returns the user ID calling the stored proc

  4. Gives the access plan of the packages

Show answer
Correct Option: A

What is the Output ?
technology databases

  1. 1

  2. 0

  3. 10

  4. 11

Show answer
Correct Option: A

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)
technology databases

  1. Return Status = 0

  2. 3 rows returned by result-set

  3. 5 rows returned by result-set

  4. 110

Show answer
Correct Option: A

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
technology databases

  1. NO SQL

  2. CONTAINS SQL

  3. READS SQL

  4. MODIFIES SQL

Show answer
Correct Option: D