Answer Posted / krishnaalluu

insert, update,delete,merge (on 9i) .

What are some of the important security features of a dbms?

929

---

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?

1891

---

What are the various kinds of interactions catered by dbms?

2178

---

How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?

1041

---

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

2299

---

What is record in a database?

916

---

What are the 4 types of database?

1067

---

Define denormalization.

1249

---

What is a distributed database system?

995

---

What is an advantage of a database?

1111

---

What is a field in database?

960

---

What is the data in a database?

954

---

What is the purpose of normalisation?

1034

---

What is 3 level architecture dbms?

1056

---

Define "correlated subqueries".

996

---