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.
| 1. |
How many clustering index we can have for a single table? |
| Answer» | |
| 2. |
Suppose a table A has an Alias named AL1. Which of the query is correct to drop the AL1 alias? |
| Answer» | |
| 3. |
Which index must be present for partitioned table space? |
| Answer» | |
| 4. |
In which format index in stored? |
| Answer» | |
| 5. |
What does SPUFI stands for? |
| Answer» | |
| 6. |
What is the maximum size of a VARCHAR data type in DB2? |
| Answer» | |
| 7. |
What is the maximum size of a CHAR data type in DB2? |
| Answer» | |
| 8. |
Write the query to delete all the rows from a table. |
| Answer» | |
| 9. |
Write a query to delete a table from database. |
| Answer» | |
| 10. |
How many primary keys can be declared on a table? |
| Answer» | |
| 11. |
In which statement you can define primary key? |
| Answer» | |
| 12. |
Which statement is used to authorize access on database tables? |
| Answer» | |
| 13. |
Which statement is used to revoke the access from a database? |
| Answer» | |
| 14. |
What does a positive SQL code indicates? |
| Answer» | |
| 15. |
What happens in BIND step in a DB2 program? |
| Answer» | |
| 16. |
Suppose a Plan contains 4 Packages & we modified one of the DBRM which is present in one of the Package. Then for normal functionality of application what should we do? |
| Answer» | |
| 17. |
What does application plan contains? |
| Answer» | |
| 18. |
When you will face SQLCODE -803? |
| Answer» | |
| 19. |
When you will face SQLCODE -911? |
| Answer» | |
| 20. |
When you will face SQLCODE -922? |
| Answer» | |
| 21. |
When you will face SQLCODE -818? |
| Answer» | |
| 22. |
In a COBOL-DB2 program where can we declare a cursor? |
| Answer» | |
| 23. |
Suppose we added a new column by using ALTER statement, where the column will be added? |
| Answer» | |
| 24. |
How you will count the number of rows from a table TAB? |
| Answer» | |
| 25. |
What is the input to the bind process? |
| Answer» | |
| 26. |
If a transaction has an exclusive lock on some data, then what are the other types of lock which can be applied on it? |
| Answer» | |
| 27. |
Which isolation level ensures highest data integrity? |
| Answer» | |
| 28. |
Which isolation level provides maximum concurrency? |
| Answer» | |
| 29. |
Which command is used to commit a transaction in CICS program? |
| Answer» | |
| 30. |
Which utility provides statistical information such as the number of pages and rows and stores them in Catalog tables? |
| Answer» | |
| 31. |
Which utility reclaims space from pages when some rows were deleted? |
| Answer» | |
| 32. |
Which utility is used to load data into a table from a sequential file? |
| Answer» | |
| 33. |
How the locks can be classified? |
| Answer» | |
| 34. |
If a transaction takes a Shared lock on some data, then other transactions can get what type of lock? |
| Answer» | |
| 35. |
If a transaction takes a Update lock on some data, then other transactions can get what type of lock? |
| Answer» | |
| 36. |
What action DB2 takes when a program abends? |
| Answer» | |
| 37. |
When a table is dropped all the alias get dropped automatically. State whether true or false? |
| Answer» | |
| 38. |
Host variables cannot be group items but they may be grouped together in host structure. They can be Renamed or Redefined. State whether true or false? |
| Answer» | |
| 39. |
Cursors are used to handle single row selections at a time. They are data structure which hold all the results of a query. State whether true or false? |
| Answer» | |
| 40. |
In a COBOL-DB2 program all SQL statements must be coded in Area A. State whether true or false? |
| Answer» | |
| 41. |
Which component is used to processes SQL statements and selects the access paths? |
| Answer» | |
| 42. |
What is the physical storage length of DATE data type? |
| Answer» | |
| 43. |
What is the physical storage length of TIMESTAMP data type? |
| Answer» | |
| 44. |
Which field in SQLCA shows the number of updated rows after update statement? |
| Answer» | |
| 45. |
In which step we specify the isolation level? |
| Answer» | |
| 46. |
On which level we can apply the locks? |
| Answer» | |
| 47. |
Which component handles DB2 startup and shutdown? |
| Answer» | |
| 48. |
Which component is responsible for execution of SQL statements? |
| Answer» | |
| 49. |
Which component checks DB2 deadlocks? |
| Answer» | |
| 50. |
What is the picture clause of Null Indicator variable? |
| Answer» | |