| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Can I use LOCK TABLE on a view? | | 1 |
| What is the meaning of -805 SQL return code? | | 2 |
| What is the function of buffer manager? | | 1 |
| What's the Maximum Length of SQLCA and what's the content
of SQLCABC? | | 2 |
| What is the command used by TSO users to invoke DB2? | | 1 |
| What is the error code -803 ? | | 2 |
| What do you mean by NOT NULL? When will you use it? | | 2 |
| What is sqlcode -922 ? | | 1 |
| What information can you find in SYSIBM.SYSLINKS table? | TCS | 1 |
| 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 |
| How do you define a correlated name? | | 1 |
| Can you access the DB2 Directory table using SQL? | | 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 |
| Suppose I have a program which uses a dynamic SQL and it
has been performing well till now. Off late, I find that
the performance has deteriorated. What happened? | | 1 |
| I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER
DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION
AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT
TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01-
JAN-2007 TO 01-JAN-2008? | Perot-Systems | 5 |
| What is lock escalation? | | 1 |
| What happens to a tablespace when its recovery infromation
has been removed and a full recovery is no longer possible? | | 1 |
| What is the difference between a package and a plan? | | 4 |
| How to know the primary key of a table without defining the
primary key in the table? | Satyam | 1 |
| What is the purpose of the QUIESE Utility? | | 1 |
| |
| For more DB2 Interview Questions Click Here |
Site Map
