-
DB2 transactions
Two or more transactions in a simultaneous wait state, each waiting for other to release before it can proceed, is calleda.Lost Updateuncommitted dependencyinfinite loopd.Deadlocke.With holdDeadlock
-
DB2 Index and Table Space
I) Index Space are created automatically when Index are created. II) Table Space are created automatically when Tables are created. Of the above statementBoth are True( I ) is Only True( II) is only TrueBoth are False( I ) is Only True
sumanthvm
- May 27th, 2009
You need tablespace created when you want to create index or Table.We cant create the table/Index in the table Spaces, thus both are false
-
DB2 Index Storate Format
Indexes is Stored in 1 B - Tree format2 Hash Table3 AVL Tree4 Red Black Tree
B - Tree format -
Db2 pre-compiler
What is a db2 precompiler?
veluvpv
- Apr 16th, 2009
I would like to add few points to it, during pre-compilation process it creates an consistency token (not time-stamp) between bind package and load module.
-
Which statements are executable in cursor syntax?
sethy.pradeep
- Nov 19th, 2008
Fetching cursor is the executeble statement in cursor syntax.Regards,pradeep
-
Exec sql and End exec
why do we declare include in between exec sql and end exec and why cant we declare copybook in place of include. Is their any reason why we declare include only
ABSS1981
- Sep 18th, 2009
In addition to the answers posted one of the additional things to have an INCLUDE between EXEC SQL and END-EXEC is that:You INCLUDE most likely will be a DCLGEN and it is going to have non COBOL langu...
memays
- Apr 30th, 2009
It all has to do with the sequence of compiling a program with imbedded SQL. It is important to understand that a COBOL program with SQL statements will actually go through 2 steps in the ...
-
What is an alias and how does it differ from a synonym?
An alias is an alternative to a synonym, designed for a distributed environment to avoid having to use the location qualifier of a table or view. The alias is not dropped when the table is dropped.
greeshmavarghese
- Oct 7th, 2009
Sysnonym can be used for the user who created it. But alias can be used for any users. Synonym is dropped when base table got dropped but alias will not get dropped.? Synonym is recorded in the sys.synonym table and alias is recorded in sys.tables.
sithusithu
- Jan 27th, 2006
An alias is a logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. In some cases, more than one alias may be necessary for a given table.Cheers,Sithu
-
What is a cursor and what is its function?
An embedded sql statement may return a number of rows while the programming language can only access one row at a time. The programming device called a cursor controls the position of the row.
nnina
- Oct 12th, 2009
Cursor is a programming device. If you want to fetch more than one record from DB2 table it can be easily done with the help of cursor because single DB2 query fetch at a time one record if it find more than one records (Duplicate) it will gives -811 (trying to retrieve more than one row).
-
What is the difference between DB2 and DB2 UDB?
SspSsp
- Oct 28th, 2009
The main difference between DB2 and DB2 UDB is that DB2 UDB has open DBMS connectivity to other open systems. I.e., though on a mainframe system, it can connect to Java, Unix and a variety of other op...
-
A table called EMPLOYEE has the following columns: name, department, and phone_number. Which can limit read access to the phone_number column?
-
How to increase table space in db2?
Raghunathan Asari
- Jul 23rd, 2007
User ALTER command to change the PRIQTY and SECQTY of the Tablespace.Eg. ALTER TABLESPACE db.ts PRIQTY 50 SECQTY 50.Here PRIQTY => primary quantity in 50 KB and ...
-
A stored procedure has been built and deployed on the DB2 UDB server machine. What is the minimum software that must be installed to allow an application on the client to execute the stored procedure?
A stored procedure has been built and deployed on the DB2 UDB server machine. What is the minimum software that must be installed to allow an application on the client to execute the stored procedure? A. DB2 Runtime Client B. DB2 Personal Edition C. DB2 Administration Client D. DB2 Application Development Client
mkumarshashi
- Jan 21st, 2010
DB2 Application Development is required on the client machine to run the stored procedure.
-
DB2 Index Space
A index space contains: Multiple indexesSingle index onlyIndexes for a single tableThere is no concept of index space
Single index only -
DB2 Table Delete Question
Target table T1 is getting deleted. Table T2 has the foreign key. We require that whenever a row from T1 is deleted, the corresponding row from T2 also be deleted. Which option can be used? a.ON DELETE RESTRICTb.ON DELETE CASCADEc.ON DELETE SET NULLd.ON DELETE CHILDe.ON DELETE MATCHON DELETE CASCADE
kalone
- Jan 31st, 2010
ON DELETE CASCADE: If a row in the parent table is deleted, all the corresponding row in child tables will automatically be deleted.ON DELETE RESTRICT: The delete operation on parent table is restricted if there is a matching row in child table.So, ans to the above query should be ON DELETE CASCADE.
-
What are db2 pre compilers?
kalone
- Jan 31st, 2010
DB2 pre-compiler extracts all the SQL stmnts from the appln prg and keeps them in DBRM and comments those SQL stmnts (in the appln prg) and replaces them with a CALL.
-
How to retrieve n-th row ie n-th record of any table irrespective of the columns and the values present in the table without using ROWID(As it is not supported in DB@)?
dyury
- Mar 8th, 2010
We can use scrollable cursor ( with DB2 V8 and higher).FETCH FIRST ROWSET STARTING AT ABSOLUTE N FROM CURSOR1 FOR 1 ROW.
kaviarasu
- Jun 23rd, 2006
SELECT * FROM TABLE_NAME AAWHERE 5 = (SELECT COUNT (FIRST_FIELD) FROM TABLE_NAME WHERE FIRST_FIELD <= AA.FIRST_FIELD )WITH UR;
-
DB2 View Purpose
Which of the following is not a purpose of a View ?a.To simplify the appearance of data to different usersb.To control access to a tablec.To show more meaningful data, such as summaryd.To store data separately for user copye.To get data from multiple tables To store data separately for user copy
ambareeshtss
- Oct 19th, 2008
DB2 table may have many fields, All the users are not intended to see some fields. To customise this, Views are created for DB2 tables. A single DB2 tables can have any no.of views.
-
Which of the following is not true about Bind ?
a.Programs bound to packages must still be designated in a plan.b.SQL statements are validated during Bind.c.Authorization is verified during bind.d.SQL statements cannot be executed unless bind is performed.e.The program should determine the db2 access path before the bind is performed.The program should determine the db2 access path before the bind is performed.
yuvaevergreen
- Mar 26th, 2010
The program should determine the db2 access path before the bind is performed.
-
DB2 Synonyms
i) Synonyms can refer to local and remote table ii) Alias can refer only to local tables Of the Statement 1 Both are TRUE2 Both Are False3 i) is Only True4 ii) is Only True Both Are False
-
DB2 Storage groups
Select the correct statement 1 Storage groups can be altered2 Database can be altered3 Tablespace can be altered4 All of the Choices
All of the Choices
DB2 Interview Questions
Ans