Answer / sudipta santra

Inline query :
select * from emp where empno=(select max(empno) from emp);

Co-Related sub query:

Select * from emp where dob> (select distinct dob where
deptno= 10);

Note: In the Inline subquery , The main query depends upon
the outcome value of the inline sub query which is in-lined
but in case of co-related sub query the main query and sub
query both run simultaneously then the check occurs.

Mention how deadlock can be resolved?

0 Answers  

---

What is a DATABLOCK ?

2 Answers  

---

What is rdbms architecture?

0 Answers  

---

What is tuple in dbms?

0 Answers  

---

Which factors does not affect the size of the SGA ?

3 Answers   TCS,

---

How do you create a report in a database?

0 Answers  

---

Enlist the advantages of normalizing database.

0 Answers  

---

What is an artificial (derived) primary key? When should it be used?

0 Answers  

---

What are database modules?

0 Answers  

---

What are 3 types of databases?

0 Answers  

---

How big is a big database?

0 Answers  

---

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?

0 Answers   IBM,

---