Answer Posted / vijay

Dual is like a dummy table which consists of one row and one column

select sysdate from dual;

Which autogrowth database setting is good? : sql server DBA

1058

---

What is fill factor? : sql server DBA

1181

---

What are the operating modes in which database mirroring runs? : sql server DBA

1106

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2365

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2482

---

What are the different types of indexes available in sql server? : sql server DBA

1109

---

how can you connect from 10g user to 11g user??

2062

---

. 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?

2399

---

how can you schedule a job in database?

1043

---

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

1077

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1043

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1920

---

What authentication modes does sql server support? : sql server DBA

1137

---

What would you do with an "in-doubt" distributed transaction?

1831

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1920

---