Disclaimer: The main motive to provide this solution is to help and support those who are unable to do these courses due to facing some issue and having a little bit lack of knowledge. All of the material and information contained on this Channel is for knowledge and education purposes only. Try to understand these solutions and solve your Hands-On problems. (Not encourage copy and paste these solutions) If you want solution for more TCS courses then please ping course name in the comment section. I will upload the solution for you guys. Fourth question is changed from ‘Display Dept Head for employees with Manager as Null’ to ‘Total amount of salary of each department’. Will try to upload the solution for question number four ASAP.
Hii, please upload solutions for Mini Project - CLP_Core Java_E2(course id - 62001), Machine Learning Using Scikit Learn_FP(Course ID: 56102), and Stats with Python (course id - 56416). I'm trying for a long time still facing problems in solving the hands-on. Your help will be appreciated. 😇
Thks for updating and sharing your extensive skills. Could you share the solutiond of oracle SQL certification of iz0-071 what kind of questions will come and how to prepare to achieve this. Thnks.
Hi @Bewithunk - If you have answers for the latest 1st and 3rd questions of this Frescoplay Hands-on Course then kindly requesting you to please share here in the comments section
@TechonTechTV i am getting incorrect answer while executing all the codes.For all the codes same problem even though I wrote it in a correct way like you.can you please assist me on this it is very urgent
Course Id for e2 is 62136. And competency id is 1995. So if you go on ievolve then search for 1995 and and their you will get course Id for e0 to e2. If you are on e0 level then you can directly enroll for e2 and you can complete e2
Hi TechnonTechTV I m facing issue even after copying the same solution for hackerrank. Giving me issue as Incorrect answer. My output is displayed properly as yours in video. Even I for 3rd query answer I m facing the same. Need ur urgent help
I have added code for Line no 11 and 12 below: Line 11 select 'emp_id emp_fname emp_Lname emp_HireDate emp_Status Dept_name Mgr_name' from dual; Line 12 Select A.emp_id,A.emp_fname,A.emp_lname,A.emp_hireDate,A.emp_status,D.dept_name,--A.mgr_id,C.emp_id,
Hi sir/madam in 1st code some line is missing which is not shown in the video. Coz before the edit BEGIN was at 21st line after the edit it was in 22nd line. can you please make it clear.
Hi brother, it’s a good job you’re doing here. But for me there are errors showing while running the codes. And the fourth question is also changed from ‘Display Dept Head for employees with Manager as Null’ to ‘Total amount of salary of each department’. Could you please update the answers for this course. It would be much helpful for us.
Please follow the steps correctly and write code properly. Many peoples already clear the test using this video. If you still getting error then mail me your code. I will check and let you know where you have done the mistake.
@@TechnonTechTV I have sent you the mail just now only. Please check and let me know where I am making mistakes and also please send the codes for 1st and 3rd questions by replying back via that mail
Disclaimer: The main motive to provide this solution is to help and support those who are unable to do these courses due to facing some issue and having a little bit lack of knowledge. All of the material and information contained on this Channel is for knowledge and education purposes only.
Try to understand these solutions and solve your Hands-On problems. (Not encourage copy and paste these solutions)
If you want solution for more TCS courses then please ping course name in the comment section. I will upload the solution for you guys.
Fourth question is changed from ‘Display Dept Head for employees with Manager as Null’ to ‘Total amount of salary of each department’. Will try to upload the solution for question number four ASAP.
Hii, please upload solutions for Mini Project - CLP_Core Java_E2(course id - 62001), Machine Learning Using Scikit Learn_FP(Course ID: 56102), and Stats with Python (course id - 56416). I'm trying for a long time still facing problems in solving the hands-on. Your help will be appreciated. 😇
@@sunshine_aashi yeah, sure. Soon will create video on this. 🙌
@TechnonTechTV Please upload solution video of fresco play T-factor 1.99 milestone challenge...!
62001
Thks for updating and sharing your extensive skills. Could you share the solutiond of oracle SQL certification of iz0-071 what kind of questions will come and how to prepare to achieve this. Thnks.
Thank you for explaining so easily 🙌😇
Glad to hear this. Keep Learning :)
Thanks for explaining 👍
I passed after 1 year of struggle.
Thank you so much.
Glad to hear this :)
Hey @numberless3969, can you please send the codes, I am facing errors in the codes
Can you share the codes if you have them?
@numberless3969 can you please share the code
Hi @nuberless3969, Can you please share the answers
Hi TechknTechTV team.. the course is updated, Could you please make an updated course video😊
Please share the code for Q4 as course has been updated. Its urgent
Thank you ma'am
I am not getting the output displayed. Could you please help
? I have set the server output on.
Can u pls share latest questions and Answers
And one more doubt is there any camara while writing the Assessment??
Actually I dont aware of table structure. I have a doubt about the 3rd task. Why do update mgr Id=7 where deptid=10.pls clear?
Hi @Bewithunk - If you have answers for the latest 1st and 3rd questions of this Frescoplay Hands-on Course then kindly requesting you to please share here in the comments section
@technonTechTv .. could u pls let me know .. what is this error .. no response on stdout ??
Hi we are unable to proceed with abive answer. Getting the incorect answer for the first code itself. Kindly help.
Hi mam/sir all the 4 queries are showing as incorrect answer can you provide solution file for all 4 sql queries.
Can you please help me. All the testcases are failing. I think the questions have changed.please its urgent
@TechonTechTV i am getting incorrect answer while executing all the codes.For all the codes same problem even though I wrote it in a correct way like you.can you please assist me on this it is very urgent
Hi
Does anyone have solution for the latest test cases... Unable to pass the exam
Please share the solution as I am getting error for question 1
👌👌👌
Test cases not working. Can you please update. ITS VERY URGENT
Can u please provide the plsql course I'd and competency from e0 level to e2 and also provide hands on course I'd also .
Course Id for e2 is 62136. And competency id is 1995. So if you go on ievolve then search for 1995 and and their you will get course Id for e0 to e2. If you are on e0 level then you can directly enroll for e2 and you can complete e2
@@TechnonTechTV ok i will look that thanks 😃
Hi @TechnonTechTv, please update the PLSQL E2 video with the solution to the 4th question as it got changed than what is shown in this video
Hi , if you have latest answers can you please share
Hi TechnonTechTV
I m facing issue even after copying the same solution for hackerrank. Giving me issue as Incorrect answer. My output is displayed properly as yours in video. Even I for 3rd query answer I m facing the same. Need ur urgent help
Hi hiral,
For which question you are getting error?
If not complete within the time limit what happened. How should I done this after fail in first attempt
Hi
Can anyone help me with the answers of mini project clp javascript e2?
I m not able to find it anywhere
Right upper corner part of the 4th solution code is not visible. please provide the same. Thank you 😊
Oh, Sorry my bad. Thank you for reminding me :)
I have added code for Line no 11 and 12 below:
Line 11
select 'emp_id emp_fname emp_Lname emp_HireDate emp_Status Dept_name Mgr_name' from dual;
Line 12
Select A.emp_id,A.emp_fname,A.emp_lname,A.emp_hireDate,A.emp_status,D.dept_name,--A.mgr_id,C.emp_id,
@TechnonTechTV Thank You...!!
@@chetankumar6029 bro do you have the recent solutions.?
@chetankumar6029 bro do u have 3rd solution
Hi sir/madam in 1st code some line is missing which is not shown in the video. Coz before the edit BEGIN was at 21st line after the edit it was in 22nd line. can you please make it clear.
Hi Sharath, Please check your email. I have send you my solution file.
@@TechnonTechTV I am still getting error in hidden test case
Please help me
Hello Sharath... Please provide updated code to my mail id
@sharathavs9370 ,if you have updated answers please share me bro
Hello please send the solution as I am getting error in hidden test case
Test cases are not working
Test case is not passing for first one and third one? @technontechtv
1st question itself is not working.. can anyone help me to complete the test
i'm getting ~ no response on stdout ~ on every solution
pls help
Please send your code on technontechtv@gmail.com will check and get back to you
Even I was facing the same issue
Iam also getting no response on stout on every solution can you please help me..
I am also facing the same issue.~no response on stdout~
Hello. I getting error in first question please provide the updated solution. I need to complete it ASAP @TechonTechTv
Hi need solution for TSLP t3 track two miniproject solutions
Hi can you share me the solution code i am getting error it showing the output as you got but its showing incorrect result
Also there is missing line from before after the edit can you verify what's that line
Hi brother/sister, Thanks for your efforts. I'm getting error. Could you please share the solution file with me.
Sir 4th fresco play questions was changed.
4th question is : plsql - Total amount of salary of each department. Can you please answer this question
Any reply for this
Solution for 3rd
SET SERVEROUTPUT ON;
DECLARE
v_dept_id dept.dept_id%TYPE;
v_dept_name dept.dept_name%TYPE;
v_dept_head dept.dept_head%TYPE;
v_mgr_name VARCHAR2(100);
CURSOR emp_cursor IS
SELECT emp_id, emp_fname || ' ' || emp_lname AS emp_name, emp_status
FROM emp
WHERE emp_status = 'Active' AND dept_id IS NULL;
CURSOR dept_cursor IS
SELECT dept_id, dept_name, dept_head
FROM dept
WHERE dept_id NOT IN (SELECT dept_id FROM emp WHERE dept_id IS NOT NULL);
BEGIN
OPEN dept_cursor;
FETCH dept_cursor INTO v_dept_id, v_dept_name, v_dept_head;
CLOSE dept_cursor;
IF v_dept_id IS NULL THEN
DBMS_OUTPUT.PUT_LINE('No available department without employees.');
RETURN;
END IF;
SELECT mgr_fname || ' ' || mgr_lname INTO v_mgr_name FROM mgr WHERE dept_head = v_dept_head;
DBMS_OUTPUT.PUT_LINE('Emp_id Emp_name Emp_status Dept_id Dept_name Mgr_name');
FOR emp_rec IN emp_cursor LOOP
UPDATE emp SET dept_id = v_dept_id, mgr_id = v_dept_head WHERE emp_id = emp_rec.emp_id;
DBMS_OUTPUT.PUT_LINE(emp_rec.emp_id || ' ' || emp_rec.emp_name || ' ' || emp_rec.emp_status || ' ' || v_dept_id || ' ' || v_dept_name || ' ' || v_mgr_name);
END LOOP;
COMMIT;
/*DBMS_OUTPUT.PUT_LINE('Employees have been assigned to the department.');*/
END;
/
Hello I m facing getting the incorrect answer for the first question
@TechnonTechTV
can you Please help us with
Fourth question ‘Total amount of salary of each department’. answer ?
👍👍👍
Excellent mam..
Glad to hear this. Keep Learning :)
@@TechnonTechTV I am still getting error could you pls share the code file.
Hi bro ...do you have the latest solution for this id
Please upload 62238( plsql mini project E1 )hands on answers
It’s there on my channel please check it’s the latest video
Pls post the updated answers for this courses.
Hi brother, it’s a good job you’re doing here. But for me there are errors showing while running the codes. And the fourth question is also changed from ‘Display Dept Head for employees with Manager as Null’ to ‘Total amount of salary of each department’. Could you please update the answers for this course. It would be much helpful for us.
Hi bro - Have you completed this Hands-on having updated questions?
I have typed the same answers till I get an error for answers.
Could you please help me with the correct answers
Bro is your problem resolved
@payalphade255 pls reply
@@RBhanuprakashnaidu not yet
Do you have answer for 3 and 4 ?
Please provide pdfs or video for mini-project clp javascript _E2
Hi Lakshmi, Sure will try to add them asap.
I am not able to clear questions 1 and 3 of this hands-on. Questions 2 and 4 passed
Please follow the steps correctly and write code properly. Many peoples already clear the test using this video. If you still getting error then mail me your code. I will check and let you know where you have done the mistake.
@@TechnonTechTV I have sent you the mail just now only. Please check and let me know where I am making mistakes and also please send the codes for 1st and 3rd questions by replying back via that mail
It would be helpful if you could provide solution for this!!
@@saibhanuteja7548 Hello,
Please send me codes in word file format. That will be better for me to check.
I have sent you the codes in mail. Please check and let me know where I am making mistakes and also please send me back the correct codes.
Hi techontechtv i got answers for 1 and 3 but it is showing incorrect answer. Also i dont have answer for 4th question. Can you help me
Can me mail me the answer please
@@suganyasrinivasan3867 do u have answer for 3 and 4
Getting "~ no response on stdout ~" for the solution. Can some one pls suggest !! If anyone having running code can somebody please send to me !!
Same prblm please help
Put \ at the end
Add / before exit
Same I am also facing with same error
Hi can u please send the updated answers
me also getting same error same questions 1 and 3
Hello someone paste the SQL code of this one. It's very urgent to me
Please provide missing line in 1st code...
Please provide replu
pls solve 62133 and upload
yeah, sure. Soon will create video on this🙌
Thank you and keep Learning :)
Hi Ravi,
I have uploaded solution for 62133. Please check this on my channel. Thank you and keep Learning :)
Hi @technontechtv i am not able to clear 1 can you please advice
Pls provide this course answer 60358 as soon as possible
Kindly send the code
Hey
I have mailed you with some issues
Please reply to it
It would be from Ayush Mishra
Hi Ayush,
Will check and let you know. Thank you
@@TechnonTechTV Hello
There is no reply on the mail
Please do the needful
@@TechnonTechTV Hey Brother
Please check the mail
I have sent the codes which are giving error
Please check them
@@MishraAyush19 Hi Ayush,
I have send you my solution file on email. Please check it now.
@@TechnonTechTV There are still some errors
I have sent you the mail
Check it out 👍🏼
Could you please share code?
Please send us email will send code via email.
I sent mail before 2 days back.. please reply that mail
Hello..could you please sent a code.. i already sent a mail before one week..
Hi can share thr pdf to my mail id please
Test cases are coming but getting incorrect answer for 1 and 3 questions @TechnotechTv
Please mail me I’ll send you solution there
For teat case 1 we have to modify some cursors
@@TechnonTechTV please can you send me a solution of 1st and 3rd questions solution.
@@saabkadivala3232 hi, you have 4th question answer , Please share me bro.
Hi bro can you send me the solution iam getting in correct answer
👌👌👌👍👍👍