| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is datacom db? | CSC | 2 |
| How to know the primary key of a table without defining the
primary key in the table? | Satyam | 4 |
| In terms of DB2 indexing, what is the root page? | | 1 |
| What is the difference between group by and order by? | IBM | 1 |
| how to resolve -818 error. how to see timestamp token in
load module and plan | IBM | 2 |
| Name some fields from SQLCA. | | 2 |
| I need to view the number of tables existing under one
particular Owner. Is it possible? If so, pl give the SQL
query for this? | | 3 |
| What are db2 error codes -305 and -407. What is the
difference between these 2 error codes ? | | 1 |
| Explain the use of the WHERE clause. | | 2 |
| What is the error code -803 ? | | 3 |
| Explain the use of the WHERE clause? | | 1 |
| max number of columns in a db2 table? | | 5 |
| 5 rows are inserted to a DB2 Table. Next 3 of those are
updated, then a rollback is issued. What would happen when
the rollback is issued? | | 2 |
| What are the various locking levels available? | | 2 |
| What technique is used to retrieve data from more than one
table in a single SQL statement? | CTS | 6 |
| How do you insert a record with a nullable column? | | 2 |
| AGGREGATE function support by DB2.
A) SUM & AVG
B) SUM, MIN & AVG
C) SUM, MAX, AVG , MIN &COUNT
D) NONE
| Accenture | 1 |
| insert into tablename a
column1,
column2
select column1,
column2
from tablename b
i am getting abend -104..can any one help? | Syntel | 3 |
| How to resolve SQL Code -310. The db table feild is
declared as Decimal(7,2).
| IBM | 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 |
| |
| For more DB2 Interview Questions Click Here |