DB2 Interview Questions, Answers and Explanations: DB2 Database Certification Review

Question 1: Finding Out The Total Number of Rows in A Db2 Table Question 2: Eliminating Duplicate Values in Db2 Select Question 3: Selecting A Row Using indexes in Db2 Question 4: Finding The Maximum Value in A Column Question 5: Retrieving The First 5 Characters of Firstname Column Question 6: Aggregate Functions Question 7: Max on a Char Column Question 8: SQL Statement Yields inaccurate Results Question 9: Concatenate The Firstname and Lastname Question 10: The Use of Value Function Question 11: Union and Union All Question 12: Restriction on Using Union in SQL Question 13: Between and in in The Where Clause Question 14: Between Is inclusive of The Range Values Question 15: Use of Like and Its Wildcard Characters in Where Clause Question 16: Use of Like Statement Question 17: Meaning of Underscore in The Like Statement Question 18: Group By and Having Clause Question 19: List of Employees Who Are Not Assigned To Any Project Question 20: Result of Query If No Rows Are Selected Question 21: Select Is Not Preferred in SQL Programs Question 22: Ways To See The Table Definitions Question 23: Cursor and Its Use Question 24: Retrieve Rows From A Db2 Table in SQL Question 25: Meaning of Dedicated and Pool Threads Question 26: Specify and Use A Cursor in Cobol Program Question 27: Function of Open Cursor Question 28: Declare Cursor Question 29: More Than One Cursor Open in A Program Question 30: Commit and The Cursor Question 31: Leaving The Cursor Open After Issuing A Commit Question 32: Definition of A Varchar Field Question 33: The Physical Storage Length of Db2 Data Types Question 34: Cobol Picture Clause of Db2 Data Types Question 35: Cobol Picture Clause For Db2 Column Question 36: Meaning of Dclgen Question 37: Contents of A Dclgen Question 38: Use of Dclgen Question 39: Use of Declare Table in Dclgen Question 40: Pre Compile of Db2-Cobol Program Question 41: Typical Db2 Batch Program Executed Question 42: SQLca Fields Question 43: Updated Rows After Update Statement Question 44: Meaning of Explain Question 45: Things Needed To Do Explain Question 46: Storage Location of Explain Question 47: Meaning of Explain With Matchcols = 0 Question 48: Explain in SQL Statement Question 49: Simulate The Explain in SQL Statement in Spufi/Qmf Question 50: Possible Isolation Levels Question 51: Difference Between CS and RR Isolation Levels Question 52: Isolation Level Question 53: Use of Isolation Level Question 54: Locking Levels Question 55: Determining Lock Size in Db2 Question 56: Disadvantages of Page Level Lock Question 57: Lock Table on A View Question 58: Lock Escalation Question 59: Locks Available Question 60: Function of Alter Question 61: Meaning of DBRM and Plan Question 62: Use of Acquire/Release in Bind Question 63: The Access Path Question 64: Dropped index in Plan Question 65: Content of Packages Question 66: The Advantages of Using A Package Question 67: Meaning of Collection Question 68: The SQL Codes Question 69: Printing The Output of An SQL Statement From Spufi Question 70: Retrieving Nth Row Question 71: Command To Reorganize indexes Question 72: Meaning of Dynamic SQL Question 73: Determining The Access Path For Dynamic SQL Question 74: Causes of Deteriorating Performance in Dynamic SQL Question 75: Db2 Store Null Physically Question 76: Retrieval of Data From A Null Column Question 77: Picture Clause of The Null indicator Variable Question 78: Meaning of Null indicator With Value –1, 0, and -2 Question 79: inserting A Record in A Null Column Question 80: Function of RUNSTATS Question 81: Function of RUNSTATS Question 82: Example of Statistics Collected During RUNSTATS Question 83: Meaning and Function of REORG Question 84: Meaning of IMAGECOPY Question 85: Function of IMAGECOPY Question 86: Meaning of Copy Pending Question 87: Meaning of Check Pending Question 88: Function of Quiesce Question 89: Clustering Index Question 90: Number of Clustering indexes Defined For a Table Question 91: Diff. Between Primary Key & Unique index Question 92: SQL Code -922 Question 93: SQL Code -811 Question 94: SQL Code of -818 Question 95: Updating Views Question 96: Updating A View of Two Or More Tables Question 97: 4 Environments To Access Db2 Question 98: Meaning of Inner and Outer Joins Question 99: Meaning of Freepage and Pctfree Question 100: Function of Simple, Segmented and Partitioned Table Spaces Question 101: Meaning of Filter Factor Question 102: Meaning of index Cardinality Question 103: Meaning of Synonym Question 104: Difference Between Synonym and Alias Question 105: Meaning and Function of Not Null With Default Question 106: Function NOT NULL Question 107: Function of VARCHAR Question 108: Disadvantages in Using VARCHAR Question 109: Creating A Table Where Manager is a Foreign Key Question 110: Auditing Question 111: Function of Mainframe Testing Question 112: Collection ID Question 113: Sending Data From a COBOL File To Db2 Table Question 114: Using Group By and Ordered By in A Single Query Question 115: Maximum Number of Columns That Can Be Created in A Table Question 116: Role of index Question 117: Loading Data To A Table Question 118: Browsing A Particular Record in File Id Question 119: The Difference Between Qmf and Spufi Question 120: Function of Select Statement Question 121: Function of From Statement Question 122: Function of Where Statement Question 123: Function of Cursor With Hold Option Question 124: Status of The Table Question 125: Seeing S9(4)Comp3 Data Question 126: Knowing Other Person’s Job Status Question 127: Number of Clustering indexes Passing For A Table Question 128: Reading The Last Record Question 129: Low and High Values Question 130: Function of intent Lock Question 131: Meaning and Types of indexes Question 132: Displaying The index Question 133: Stage Where Db2 Must Be Up Question 134: Using Subroutines Question 135: initial Position of Cursor Question 136: File Opening Modes in Cobol Question 137: Effect of File Opened in Extend Mode Question 138: Usage of Subprogram More Than Once Question 139: Entering Xpediter Question 140: Compiling Two Programs Question 141: Pass Return Codes From Cobol To Jcl Question 142: Difference Between Check Pending and Copy Pending Question 143: Severity One Error in Production Support Question 144: Meaning of index Set and Sequence Set in Vsam Ksds Question 145: Reading Records From 500 To 900 From 1000 Records in Vsam Question 146: Running A Cobol-Db2 Program Question 147: Amend A Program Question 148: Meaning of Auditing Question 149: Testing Question 150: Meaning of Packed Decimal Question 151: Dumping Db2 Table Information to a File Using a SQL Statement Question 152: Meaning of -904 Question 153: Reasons Why A Program Runs So Long Question 154: Db2 Track and Record Changes at The Field Level Question 155: Specific Dataset Allocation Question 156: Listing The Detail Privileges of An individual Db2 Racf Resource Class Question 157: Verify That IMS is Connected To Db2 Question 158: Plan To Execute in An IMS Transaction Question 159: Regarding IMS DL/I Batch Backout and Db2 Question 160: Display The Number of PAVS on a Given Shark Volume Question 161: Faster Way To Minimize The Outage To The Customer Question 162: Biggest Difference in Db2 Storage Management Between OS/390 and Unix/Windows Question 163: Optimum Value For SEGSIZE in a Segmented Table Space Question 164: Illustration of Db2 Triggers To Maintain An Audit Log Table Question 165: -104 SQLcode When Creating Db2 Triggers Question 166: Table Check Constraints, User Defined Default Values, and Triggers Question 167: Dynamic Prefetch Or Sequential Detection Question 168: Partitioned Table Space Question 169: Creating a Federated Server Question 170: Dropped Tablespace Question 171: String Manipulation (PATRIAL Field Extract) Question 172: Creating A Dclgen Question 173: Spooling Results of Db2 SQL Via Qmf Question 174: String Reading Question 175: Decimal Functions Question 176: Case With Sum? Question 177: How To Select Year On Char, Iso Date Question 178: Oracle’s “Rowid Pseudocolumn”; Anything Like That in Db2? Question 179: Get Record Number Added To Query Question 180: Get Specified Number of Rows From A Db2 Table Question 181: Setting The Permissions On A User-Defined Function Question 182: Select With Group By Question 183: F6 and Reorgchk Question 184: Create A VIEW Question 185: Database Size Check Question 186: System/Catalog Tables Show User Privileges Question 187: Length of Numeric Field Question 188: Control Center Doesn’t Work Properly Question 189: Purging Data Useful Db2 Links and Websites Index