NCR SQL Unix interview Questions,Teradata

NCR SQL Unix interview Questions,Teradata
SQL:
1.Write a query to display average salary of all employees in EMP department number wise?
2.Write a query to display average salary of all employees in EMP department name wise?
3.Write a query to delete a row from a parent table if no related row is present in corresponding child table? Take example of EMP and DEPT tables?
UNIX:
1.Tell about virtual memory and paging?
2.What is fragmentation?
3.Do you know UNIX internals?
4.What are makefiles?
5.Write a small sample makefile?
6.Which debugger did you use?

No comments: