| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Can we declare DB2 HOST variable in COBOL COPY book? | | 1 |
| What is isolation level? | | 1 |
| Say CUST Table contains records like:
CUSTNO CUSTNAME CUSTLOC
100 ABC SSS
200 XYZ
300 PQR
400 MNO WWW
500 CVV
-------------
-------------
Now write a query to retrieve all records with CUSTLOC no
data.
| IBM | 2 |
| What is the syntax required for the creation of a cursor? | | 1 |
| Which DB2 catalog tables are used to produce a list of
table column by table for all tables in a database? | | 1 |
| which SQL comment successfully removes uncommitted changes
from a DB2 database
A) rollback
B) delete
C) drop
D) decommit
| Accenture | 1 |
| Usually, which is more important for DB2 system
performance - CPU processing or I/O access? | | 1 |
| Where besides the DB2 catalog is database object
information stored by DB2? | | 1 |
| What is a composite index and how does it differ from a
multiple index? | | 1 |
| How many buffer pools are there in DB2? | | 2 |
| What is the error code -803 ? | | 2 |
| 4. A DB2 application is bound with uncommitted Read
isolation level.It issues a request that retrieves 20 rows
out of 200000 in the table.
Which of the following descrbes the rows that are locked
as a result of this request?
a. None of the rows are locked.
B.The retrieved rows are locked.
C.The last row of the result set is locked.
D.The rows not previously updated by another application
are locked.
| Wipro | 3 |
| which authority can be granted to group of users using the
GRANT stmt?
A) SYSCTRL
B) SYSADM
C) DBCTRL
D) DB ADM
| Accenture | 2 |
| How to resolve the -305 error code in DB2?
And also please let me know, how to resolve the db2 error
codes. | TCS | 5 |
| What else is there in the PLAN apart from the access path? | | 1 |
| I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP! | Tech-Mahindra | 10 |
| What is the STOSPACE Utility used for? | | 1 |
| What is the significance of DB2 free space and what
parameters control it? | | 1 |
| What DB2 Catalog column tell you when an index needs table
reorganized ? | | 1 |
| Give the COBOL definition of a VARCHAR field. | | 1 |
| |
| For more DB2 Interview Questions Click Here |
Site Map
