Cognizant actual SQL Queries with detailed explanation | Clusters exam pattern technical test

[@vinaychand7744]

Thank you so much brother, with help of Video 1: th-cam.com/video/7dthpgDtJTY/w-d-xo.htmlsi=48yDM1uZLJpyoVLU AND Video 2: th-cam.com/video/foEr57-bi-I/w-d-xo.htmlsi=0eN-nOazj-n5Pr9N , I solved 2 SQL questions in Cognizant technical assessment.

[@qwscape6871]

Woww superb, best of luck for your interview ♥️

[@vinaychand7744]

@@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 ?

[@Sruthi9]

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';

[@shiv01212]

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

[@adityaranjan8473]

Sir, done 2 SQL Ques, 2 Coding Ques+ 50% Web UI, for which package I would be selected?

[@AbhinavKumar-tg4il]

Thanks for the effort, really appreciate it.

[@qwscape6871]

Check this video part 2 for SQL, you will love it 👇
th-cam.com/video/foEr57-bi-I/w-d-xo.html

[@Mahi_arpan]

I have completed 1 SQL and 2 python code and cloud computing mcq is there any chance to get a interview call?

[@aryanrohan4528]

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?

[@Sruthi9]

yes

[@mayurlad9830]

Thank you so much ❤❤❤❤❤

[@parkaviparkavi0606]

super explanation 😇😇

[@qwscape6871]

Thank you, please watch out part 2 👇
th-cam.com/video/foEr57-bi-I/w-d-xo.htmlsi=w5rZPrxnp0fCxNWq

[@abhirambemini]

For question - 2 ..
Can we use ANY keyword in place of IN??

[@vidulainamdar911]

what if both the code of sql didn't run

[@vloggerbuddy24]

Subscribed for your valuable videos please give for coding section as well

[@sivaperiyasamy975]

Very good information 👌

[@chandanpaul8851]

YOUR ENGLISH IS MAKING IT EVEN MORE DIFFICULT TO UNDERSTAND. Please do lectures in HINDI.

[@qwscape6871]

Check out part 2 👇
th-cam.com/video/foEr57-bi-I/w-d-xo.htmlsi=-vwdEjUSeuOL2h5Z

[@MUSICWORLD-zh6uk]

Please solve more queries for CTS exam

[@qwscape6871]

Check out our recent part 2 video on SQL queries 👇
th-cam.com/video/foEr57-bi-I/w-d-xo.htmlsi=cZKzAQvCGsLdhfbn

[@KHIRODHKUMARCHOUDHARY]

Thank you so much sir

[@qwscape6871]

Check out part 2 👇
th-cam.com/video/foEr57-bi-I/w-d-xo.html

[@preerj6646]

can you tell me which version of sql you use in this question?

[@qwscape6871]

you can use any MySQL version

[@vishalthegupta]

Can we switch between the sections ?
It will be very helpful if you reply

[@qwscape6871]

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.

[@vishalthegupta]

@@qwscape6871 thanks a lot

[@srushtipinjarkar1299]

in assessment do we have to write this much only as answer on anything else like database or create etc?????? @Qw ScApe

[@qwscape6871]

We are just fetching the data, tables already created. So we don't need to create table

[@kurasreeja8739]

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

[@udaysingh2929]

were you shortlisted? which gen c ,gen pro or gen next?

[@vikasiniravi5361]

can u also share the cluster 1 java questions?

[@Ria-lw5nt]

Sir
I executed 2 coding questions and none of the remaining.

[@parthibmondal311]

Same bro

[@kondrapoojitha2528]

Hlo bro
Meru chape questions a set chapthara

[@_IT_SoumiGhosh]

What if we write the column name different does this affect the test cases

[@qwscape6871]

Yes, the test case will fail.
Check out SQL queries part 2 👇
th-cam.com/video/foEr57-bi-I/w-d-xo.html

[@Ammuvis]

😢 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

[@g.v.snitin8825]

dont overthink

[@qwscape6871]

Maybe they will be a bit late for your college just wait and keep on checking with the placement incharge

[@Ammuvis]

@@qwscape6871 thanks brother

[@Ammuvis]

@@g.v.snitin8825 I am not overthinking about it just confirming what would be the reason for the delays 😕

[@Ammuvis]

@@g.v.snitin8825 may know what you are currently doing job or pursuing?

[@aarishfaiz7880]

I have exam tomorrow 30 sept 2024

[@qwscape6871]

Best of luck 🤞, check out part 2 of SQL 👇
th-cam.com/video/foEr57-bi-I/w-d-xo.html

[@rajkumarr613]

is able to switch any sections

[@qwscape6871]

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

[@5435-quz]

Plz provide first que ans in comment

[@qwscape6871]

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

[@manojkumar-mc3zw]

what is the cut off rquired to proceed to next round of interview process

[@qwscape6871]

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.

[@lorddemiurge2905]

Is it percent or percentile?​@@qwscape6871

[@l.s.radhika9909]

​@@qwscape6871this 50%-70% cutoff is from both aptitude and coding assessment combined or individual we need to achieve 50%-70%??

[@Ritikakhaire]

Which sql we need to select first?

[@qwscape6871]

Check out part 2 👇
th-cam.com/video/foEr57-bi-I/w-d-xo.html