Answer / siva

let us consider we have a database with no of tables and one table name is ComputerScienceAndEngineering_Departement
if any one want to access this table they should use full name
ex: select * from ComputerScienceAndEngineering_Departement ;
it may be difficult to someone and sometimes to us also .
so if we creating alias like csedept then it will become simple to access it.
An alias is simply an alternate name for a table or view. Like tables and views, an alias can be created, dropped, and have comments associated with it.

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

---

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

What are some characteristics of columns that benefit from indexes?

1 Answers  

---

What does it mean if the null indicator has -1, 0, -2?

1 Answers  

---

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  

---

wht is d/f between union and joins ?

2 Answers  

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

What is the significance of DB2 free space and what parameters control it?

1 Answers  

---

how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,

---