How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

How do you add a data file to a tablespace?

3 Answers  

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

---

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

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

3 Answers  

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---