InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
How Many Subqueries Can You Combine Together ? |
|
Answer» TOTAL 16 QUERIES and SUBQUERIES are 15 Total 16 queries and subqueries are 15 |
|
| 2. |
What Is Join And Different Types Of Join? |
|
Answer» The ABILITY to JOIN ROWS and combaine DATA from two or more tables is one of the most powerful FEATURES of relational system.Three type of joins:
The ability to join rows and combaine data from two or more tables is one of the most powerful features of relational system.Three type of joins: |
|
| 3. |
How Many Bufferpools Are There In Db2 And What Are They? |
|
Answer» There are 4 Bufferpools.They are BP0,BP1,BP2 and BP32. There are 4 Bufferpools.They are BP0,BP1,BP2 and BP32. |
|
| 4. |
B37 Abend During Spufi? |
|
Answer» The b37 ABEND in the spufi is because of space REQUIREMENTS , the query has resulted in so many rows that the spufi.out file is not large enough to HANDLE it, INCREASE the space allocation of spufi.out file. The b37 abend in the spufi is because of space requirements , the query has resulted in so many rows that the spufi.out file is not large enough to handle it, increase the space allocation of spufi.out file. |
|
| 6. |
What Should Be Specified Along With A Cursor In Order To Continue Updating Process After Commit? |
|
Answer» With Hold option. |
|
| 7. |
What Is The Name Of The Default Db2 Catalog Database? |
|
Answer» DSNDB06 DSNDB06 |
|
| 8. |
When Can You Be Sure That A Query Will Return Only One Row? |
|
Answer» When you USE the PRIMARY KEY and only the primary key in the where CLAUSE. When you use the primary key and only the primary key in the where clause. |
|
| 9. |
What Is The Difference Between Join And Union? |
|
Answer» JOIN is USED to retrive data from DIFFERENT TABLES using a single sql statement.union is used to combine the results of TWO or more sql querries. join is used to retrive data from different tables using a single sql statement.union is used to combine the results of two or more sql querries. |
|
| 10. |
What Is A Corelated Subquerry? |
|
Answer» In a subquerry, if the outer querry reffers BACK to the outcome of innerquerry it is called corelated subquerry. That's why the outer querry is EVALUATED first unlike an ordinary subquerry. In a subquerry, if the outer querry reffers back to the outcome of innerquerry it is called corelated subquerry. That's why the outer querry is evaluated first unlike an ordinary subquerry. |
|
| 11. |
What Are The Functions Of Bind? |
|
Answer» BIND mainly PERFORMS TWO things syntax checking and authorization checking.It binds together all packages into an APPLICATION plan hence the name BIND.Apart from this bind has optimiser as a subcomponent.Its function is to determine the OPTIMUM access STRATEGY. BIND mainly performs two things syntax checking and authorization checking.It binds together all packages into an application plan hence the name BIND.Apart from this bind has optimiser as a subcomponent.Its function is to determine the optimum access strategy. |
|
| 12. |
Max. No Of Rows Per Page? |
|
Answer» 127 127 |
|
| 14. |
Can All Users Have The Privilage To Use The Sql Statement Select * (dml)? |
|
Answer» NO THE USER SHOULD BE GRANTED PRIVILAGE TO USE IT. NO THE USER SHOULD BE GRANTED PRIVILAGE TO USE IT. |
|
| 16. |
What's The Best Locksize That You Could Use When You Create A Tablespace? |
|
Answer» The answer is Locksize = ANY.Unless you are Sure what's the PURPOSE of tablespace ie.,Read-only or R/W.If you USE lock size =any, Db2 would automatically DETERMINE what TYPE of locks it should use. The answer is Locksize = ANY.Unless you are Sure what's the Purpose of tablespace ie.,Read-only or R/W.If you use lock size =any, Db2 would automatically determine what type of locks it should use. |
|
| 17. |
What's The Error Code For Unique Index Voilation? |
|
Answer» -803 -803 |
|
| 18. |
What's The Percentage Free Space ? |
|
Answer» ZERO ZERO |
|
| 19. |
Can You Define An Index If The Table Size Less Than 10 Pages? |
|
Answer» NO NO |
|
| 20. |
What's The Maximum Number Of Volumes That Can Be Added To A Stogroup? |
|
Answer» The answer is 133.Usually it will be DIFFICULT monitor more than 3 or 4 VOLUMES to a STOGROUP. The answer is 133.Usually it will be difficult monitor more than 3 or 4 volumes to a Stogroup. |
|
| 21. |
When Does The Sql Statement Gets Executed When You Use Cursor In The Application Programming ? |
|
Answer» sql STATEMENT gets EXECUTED when we open CURSOR. sql statement gets executed when we open cursor. |
|
| 22. |
What Does Currentdata Option In Bind Indicate? |
|
Answer» CURRENTDATA option ensures block fetch while selecting rows from a table. In DB2V4 the default has been CHANGED to NO. Therefore it is NECESSARY to CHANGE all the bind cards with CURRENTDATA(YES) which is default in DB2V3 & earlier to CURRENTDATA(NO). CURRENTDATA option ensures block fetch while selecting rows from a table. In DB2V4 the default has been changed to NO. Therefore it is necessary to change all the bind cards with CURRENTDATA(YES) which is default in DB2V3 & earlier to CURRENTDATA(NO). |
|
| 23. |
What Is The Difference Between Type 1 Index & Type 2 Index? |
|
Answer» TYPE 1 & TYPE 2 are specified when an INDEX is created on the table. TYPE 2 index is the OPTION which comes with DB2V4. With TYPE 2 index data can be retreived faster as only the data pages are locked and not the index pages. Hence TYPE 2 index is recommended. TYPE 1 & TYPE 2 are specified when an index is created on the table. TYPE 2 index is the option which comes with DB2V4. With TYPE 2 index data can be retreived faster as only the data pages are locked and not the index pages. Hence TYPE 2 index is recommended. |
|
| 24. |
What Are The Levels Of Isolation Available With Db2v4? |
|
Answer» CS RR UR( ADDED new for DB2V4 which stands for uncommited read which allows to retreive RECORDS from the space which has EXCLUSIVE locks also but data integrity will be affected if this OPTION is USED )The best available option for data integrity & data concurrency is CS. CS RR UR( added new for DB2V4 which stands for uncommited read which allows to retreive records from the space which has exclusive locks also but data integrity will be affected if this option is used )The best available option for data integrity & data concurrency is CS. |
|
| 25. |
How Do U Achieve Record Level Locking In Db2 Versions When Record Level Locking Is Not Allowed? |
|
Answer» By having the LENGTH of the RECORD GREATER than that of a PAGE! By having the length of the record greater than that of a page! |
|
| 26. |
In A Db2-cics Program Which Is Acts As Co-ordinator And Which Is Participant? |
|
Answer» DB2 - PARTICIPANT CICS- COORDINATOR DB2 - participant CICS- coordinator |
|
| 27. |
What Does Dml Stand For And What Are Some Examples Of It? |
|
Answer» Data MANIPULATION LANGUAGE. Some EXAMPLES are SELECT, INSERT, DELETE, REPLACE. Data Manipulation Language. Some examples are SELECT, INSERT, DELETE, REPLACE. |
|
| 28. |
What Is The Difference Between Where And Having Clause? |
|
Answer» WHERE is for ROWS and HAVING is for GROUPS WHERE is for Rows and HAVING is for Groups |
|
| 30. |
How Do You Declare A Host Variable (in Cobol) For An Attribute Named Emp-name Of Type Varchar(25) ? |
|
Answer» 01 EMP-GRP. 49 E-LEN PIC S9(4) COMP. 49 E-NAME PIC X(25). 01 EMP-GRP. 49 E-LEN PIC S9(4) COMP. 49 E-NAME PIC X(25). |
|
| 31. |
What Is The Maximum Number Of Tables That Can Be Stored On A Partitioned Table Space ? |
|
Answer» ONE ONE |
|
| 32. |
Name The Different Types Of Table Spaces? |
|
Answer» 1. Simple Table SPACE2. SEGMENTED Table Space and3. PARTITIONED Table Space 1. Simple Table Space2. Segmented Table Space and3. Partitioned Table Space |
|
| 33. |
What Are The Max. & Min. No. Of Partitions Allowed In A Partition Tablespace? |
|
Answer» minimum is 4.maximum is 64. |
|
| 34. |
What Is The Maximum Number Of Tables That Can Be Joined ? |
|
Answer» fifteen fifteen |
|
| 35. |
What Technique Is Used To Retrieve Data From More Than One Table In A Single Sql Statement? |
|
Answer» The JOIN STATEMENT COMBINES data from more that TWO tables. The Join statement combines data from more that two tables. |
|
| 36. |
Explain The Use Of The Where Clause? |
|
Answer» It directs DB2 to EXTRACT data from rows where the VALUE of the COLUMN is the same as the CURRENT value of the host VARIABLE. It directs DB2 to extract data from rows where the value of the column is the same as the current value of the host variable. |
|
| 37. |
Maxx Number Of Columns In A Db2 Table? |
|
Answer» 224 224 |
|
| 38. |
Where Could You Look If You Had A Question About Whether A Column Has Been Defined As An Index? |
|
Answer» This INFORMATION can be FOUND in SYSIBM.SYSINDEXES. This information can be found in SYSIBM.SYSINDEXES. |
|