CSC India Hiring System Administration

Company        CSC India Pvt Ltd

Website          www.csc.com

Eligibility        Any Graduate/PG

Experience     2-4 Years

Location         Hyderabad

CSC India Pvt Ltd

Job Role: Engineer - System Administration With 2-4 years Exp

Job Summary :

Manages and documents system events to ensure the integrity of the system.

Upgrades system hardware and software components as required. Manages and maintains backups.

Installs upgrades and configures system files and services.

Monitors and improves system performance through kernel and file system tuning.

Assists with system troubleshooting to isolate and diagnose common system problems.

Analyzes, logs, tracks, and resolves hardware/softwa re matters pertaining to networking, connectivity issues, printers, servers, and applications to meet business needs.

How to find out Max Salary from each department

You can find maximum salary for each department by grouping all records by DeptId and then using MAX() function to calculate maximum salary in each group or each department. SQL Query: SELECT DeptID, MAX(Salary) FROM Employee GROUP BY DeptID. This questions become more interesting if Interviewer will ask you to print department name instead of department id, in that case you need to join Employee table with Department using foreign key DeptID, make sure you do LEFT or RIGHT OUTER JOIN to include departments without any employee as well. Here is the query

List the emps who joined before 1981.

Answer: select * from emp where hiredate < (’01-jan-81’);

SQL Info

Search This Blog