Thank you so much brother, with help of Video 1: ua-cam.com/video/7dthpgDtJTY/v-deo.htmlsi=48yDM1uZLJpyoVLU AND Video 2: ua-cam.com/video/foEr57-bi-I/v-deo.htmlsi=0eN-nOazj-n5Pr9N , I solved 2 SQL questions in Cognizant technical assessment.
@@qwscape6871 I solved 2 SQL + Few test cases in coding + tasks 1.html ,2.css NOT task3. JavaScript , So is there any possibility to enter into INTERVIEW ?
For que1 select t.train_id,t.train_name from train_details t join train_stations s on t.train_id = s.station_id where t.train_name like 'M%' and t.train_to = 'pune';
Sir for 2nd question can we write like Select ei.EMPID,el.LEAVE_TYPE,el.TOTAL_LEAVES FROM employee_info ei JOIN emp_leave_info el ON ei.EMPID=el.EMPID WHERE el.TOTAL_LEAVES>10 AND el.LEAVE_TYPE IN ('CL','ML');...........IS this correct SIR?
There will be 2 Sql queries, you can switch only those. If you want to switch to coding section questions then first you need to complete the SQL queries section.
I did 1 sql, 2 java codes in whicj out 10 9 test cases were passed in both code, so overall i solved 2.8/5 in cluster 1 will i be shortlisted for further rounds? Please let me know
😢 so sad that congnizant camed to my college and also we completed communication round but for technical round we didn't get any mails from them all colleges got mails but my clg not ,pls what will be the reason for that ols bro just ping me one line word
No, you can't. First you have to complete the SQL queries and after the coding section will start. Even you can't switch the questions in the section also
In just half an hour going to upload detailed video on how to write SQL queries tricks, in that I covered that 1st question in detail. So please subscribe and press the bell icon you will get notification
You need to perform well in aptitude and technical assessment both. At least if you score 50-70% then you will be a shortlist for the genc interview. If you score 70-90% then you will be shortlisted for genc pro. If you scored 90% above then you will be shortlisted for a gencnext interview.
Thank you so much brother, with help of Video 1: ua-cam.com/video/7dthpgDtJTY/v-deo.htmlsi=48yDM1uZLJpyoVLU AND Video 2: ua-cam.com/video/foEr57-bi-I/v-deo.htmlsi=0eN-nOazj-n5Pr9N , I solved 2 SQL questions in Cognizant technical assessment.
Woww superb, best of luck for your interview ♥️
@@qwscape6871 I solved 2 SQL + Few test cases in coding + tasks 1.html ,2.css NOT task3. JavaScript , So is there any possibility to enter into INTERVIEW ?
Great you have given an idea that these kinda questions we can aspect from cognizant which gonna appear .The question 4th appeared in my examination
For que1 select t.train_id,t.train_name from train_details t join train_stations s on t.train_id = s.station_id where t.train_name like 'M%' and t.train_to = 'pune';
Sir, done 2 SQL Ques, 2 Coding Ques+ 50% Web UI, for which package I would be selected?
Thanks for the effort, really appreciate it.
Check this video part 2 for SQL, you will love it 👇
ua-cam.com/video/foEr57-bi-I/v-deo.html
super explanation 😇😇
Thank you, please watch out part 2 👇
ua-cam.com/video/foEr57-bi-I/v-deo.htmlsi=w5rZPrxnp0fCxNWq
I have completed 1 SQL and 2 python code and cloud computing mcq is there any chance to get a interview call?
what if both the code of sql didn't run
Thank you so much ❤❤❤❤❤
Subscribed for your valuable videos please give for coding section as well
Sir for 2nd question can we write like Select ei.EMPID,el.LEAVE_TYPE,el.TOTAL_LEAVES FROM employee_info ei JOIN emp_leave_info el ON ei.EMPID=el.EMPID WHERE el.TOTAL_LEAVES>10 AND el.LEAVE_TYPE IN ('CL','ML');...........IS this correct SIR?
yes
For question - 2 ..
Can we use ANY keyword in place of IN??
Please solve more queries for CTS exam
Check out our recent part 2 video on SQL queries 👇
ua-cam.com/video/foEr57-bi-I/v-deo.htmlsi=cZKzAQvCGsLdhfbn
Very good information 👌
Hlo bro
Meru chape questions a set chapthara
can u also share the cluster 1 java questions?
in assessment do we have to write this much only as answer on anything else like database or create etc?????? @Qw ScApe
We are just fetching the data, tables already created. So we don't need to create table
YOUR ENGLISH IS MAKING IT EVEN MORE DIFFICULT TO UNDERSTAND. Please do lectures in HINDI.
Check out part 2 👇
ua-cam.com/video/foEr57-bi-I/v-deo.htmlsi=-vwdEjUSeuOL2h5Z
Thank you so much sir
Check out part 2 👇
ua-cam.com/video/foEr57-bi-I/v-deo.html
can you tell me which version of sql you use in this question?
you can use any MySQL version
Can we switch between the sections ?
It will be very helpful if you reply
There will be 2 Sql queries, you can switch only those. If you want to switch to coding section questions then first you need to complete the SQL queries section.
@@qwscape6871 thanks a lot
Sir
I executed 2 coding questions and none of the remaining.
Same bro
I did 1 sql, 2 java codes in whicj out 10 9 test cases were passed in both code, so overall i solved 2.8/5 in cluster 1 will i be shortlisted for further rounds? Please let me know
were you shortlisted? which gen c ,gen pro or gen next?
What if we write the column name different does this affect the test cases
Yes, the test case will fail.
Check out SQL queries part 2 👇
ua-cam.com/video/foEr57-bi-I/v-deo.html
😢 so sad that congnizant camed to my college and also we completed communication round but for technical round we didn't get any mails from them all colleges got mails but my clg not ,pls what will be the reason for that ols bro just ping me one line word
dont overthink
Maybe they will be a bit late for your college just wait and keep on checking with the placement incharge
@@qwscape6871 thanks brother
@@g.v.snitin8825 I am not overthinking about it just confirming what would be the reason for the delays 😕
@@g.v.snitin8825 may know what you are currently doing job or pursuing?
is able to switch any sections
No, you can't. First you have to complete the SQL queries and after the coding section will start. Even you can't switch the questions in the section also
Plz provide first que ans in comment
In just half an hour going to upload detailed video on how to write SQL queries tricks, in that I covered that 1st question in detail. So please subscribe and press the bell icon you will get notification
I have exam tomorrow 30 sept 2024
Best of luck 🤞, check out part 2 of SQL 👇
ua-cam.com/video/foEr57-bi-I/v-deo.html
what is the cut off rquired to proceed to next round of interview process
You need to perform well in aptitude and technical assessment both. At least if you score 50-70% then you will be a shortlist for the genc interview. If you score 70-90% then you will be shortlisted for genc pro. If you scored 90% above then you will be shortlisted for a gencnext interview.
Is it percent or percentile?@@qwscape6871
@@qwscape6871this 50%-70% cutoff is from both aptitude and coding assessment combined or individual we need to achieve 50%-70%??
Which sql we need to select first?
Check out part 2 👇
ua-cam.com/video/foEr57-bi-I/v-deo.html