Saved Bookmarks
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.
| 151. |
What is DBKEY? Explain. |
| Answer» | |
| 152. |
Difference between Fixed length and Variable length records. |
| Answer» | |
| 153. |
What are storage attributes of records? |
| Answer» | |
| 154. |
What is a database? |
| Answer» | |
| 155. |
What is the meaning of "Currency ????" ? |
| Answer» | |
| 156. |
What is the difference between SPUFI and QMF? |
| Answer» | |
| 157. |
What is the difference between Cursor Stability and Repeatable Read isolation levels? |
| Answer» | |
| 158. |
What does it mean if the null indicator has -1,0,2? |
| Answer» | |
| 159. |
How do you leave the cursor open after issuing a COMMIT? (For DB2 2.3 or above only) |
| Answer» | |
| 160. |
Is DECLARE TABLE in DCLGEN necessary? Why it used? |
| Answer» | |
| 161. |
How is a typical DB2 batch program executed? |
| Answer» | |
| 162. |
What is REORG? When is it used? |
| Answer» | |
| 163. |
What is COPY PENDING status? |
| Answer» | |
| 164. |
Are view updateable? |
| Answer» | |
| 165. |
What do you mean by NOT NULL WITH DEFAULT? When will you use it? |
| Answer» | |
| 166. |
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100? |
| Answer» | |
| 167. |
What is DBRM? What it contains? When it will be created? |
| Answer» | |
| 168. |
What are the advantages of using a PACKAGE? |
| Answer» | |
| 169. |
What is CHECK constraint. Explain with example. |
| Answer» | |
| 170. |
How and when does the Db2 enforces the unique key? |
| Answer» | |
| 171. |
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns? |
| Answer» | |
| 172. |
What does SQLCABC has? |
| Answer» | |
| 173. |
What is the max length of SQLCA? |
| Answer» | |
| 174. |
What is SQLCA? |
| Answer» | |
| 175. |
How to execute stored procedures? |
| Answer» | |