Answer / hraju.mr

Hi Naresh,
DB2 is a relational database from IBM and mainly used for
applications like any othr database products from
Oracle.the Procedure here is similar to work with
almost.There are 2 different platforms that you can go
ahead with this technology....as application programmer and
DataBase Architecture.here the second one is the one which
includes the responsibilities of designing
database,Tablespaces ..taking backups running the
Utitlities both Online and Offline..ofcourse this is an
intersting subject that u can always rely upon..

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

What does coalescing a tablespace do?

1 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

---

what is meant by gateway

1 Answers   IBM,

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---