Python Tutorials

Search This Blog

TCS Java Hackthons

May 21, 2020

Get link
Facebook
X
Pinterest
Email
Other Apps

TCS Java Hackthons

Java Handson

SQL Handson

UNIX Handson

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

TCS Java Hackathon - Java Hands-on

TCS Java Hackathon - Java Hands-on Q1 . Find interest value Create a class Account with below attributes: int id double balance double interestRate Class should have getters, setters and constructor with parameters in above sequence of attributes. Create a class Solution with main method. Read one integer and two double values using Scanner object and create object of Account class. These values should be mapped to id, balance and interestRate attributes. Read one more integer value and store it in variable noOfYears. Write a method calculateInterest which will take account object and no of years as input parameters and return the interest amount Consider below logic to calculate the interest value: For specified no of years, first find out the percentage value those no of years based on specified interestRate. E.g. if no of years is 5 and specified interestRate is 4%, then 4% of 5 is 0.2. This percentage should be added to original interstRate for calculating the fin

TCS Java Hackathon - Sql Hands-on

TCS Java Hackathon - Sql Hands-on Q1. Employee Count select Departments.deptName,COUNT(Employees.eDeptId) From departments LEFT Join Employees on Departments.deptId=Employees.eDeptId Group By Departments.deptId,Departments.deptName Order by count(Employees.eDeptId) Desc, departments.deptName; Q2. Display Department Details select Dept_Id,Dept_Name from Department where Dept_Location='Ground Floor'; Q3. Display non-Programmer Department name select distinct Dept_name from Departments,Employees where Dept_ID=Emp_Dept_Id and Dept_name not in (select distinct Dept_name from Departments,Employees where Dept_id=Emp_Dept_Id and Emp_Skill like'Programmer'); Q4. Department wise Skill select distinct Dept_name,Emp_skill from Departments,Employees where Dept_ID=Emp_Dept_Id order by Dept_Name desc,Emp_Skill; Q5. Find items not ordered select distinct Item_Name from Items where Item_id not in(select distinct Item_Id from orders);

TCS PA UI MCQs

TCS PA UI MCQs 1.Syntax of background image in CSS ? background-image 2.All html tags have closing tags ? false 3.what is command for ordered list with roman number ? <oltype='I'> 4.Which is not CSS unit ? 1.em 2.ut 3.% 4.px 5.p{ color: green } xyz Paragraph is printed in which color 1.Green 2.Red 3.Blue 4.Error 6.Emphasing the text in html ... ? 7.Tag which is not for formatting text ? 1. 2. 3. 4. 8.which is the invalid field in HTML5 ? 1.Day 2.Date 3.Datetime 4.Month 9.Which is invalid escape sequence in JavaScript ? 1./r 2./b 3./f 4./e 10.you have created a shell script and wants to run the script . what should you do before try to run the script ? 1.No action required 2.Compile the script.......... 3.Update the execute permission of the script 11.Caption tag is used with ... 1.Image 2.Table 3.Both 4.None 12.Text-align:justify... ?

Powered by Blogger

TCS Java Hackthons

TCS Java Hackthons

Java Handson

Comments

Post a Comment