Answer Posted / karthik

whenerver you start the database you try to startup ..open
the databse
1. you startup using the startup nomount with the parameter
file that you have .
2. mount the db using startup mount which will read the
control file .
3. startup open is the process to open the data base.

What is the sql 'in' clause?

1002

---

Define phantom deadlock.

1094

---

what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

2093

---

define aggregate functions.

987

---

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1890

---

What is the maximum line size that dbms_output can handle?

1249

---

Explain the advantages and disadvantages of a hierarchical database?

1124

---

What is pcbs (program communication blocks)?

1060

---

What do you mean by entity type?

1125

---

Enlist the advantages of dbms.

1018

---

Explain the term entity type in dbms?

1087

---

Explain ddl interpreter?

1261

---

Explain the difference between a dynamic and materialized view.

950

---

Is sql a database?

977

---

What do database languages do?

1000

---