🔥Cognizant SQL Questions asked on 18/09/2024 | Cognizant Technical Assessment🔥

[@shiprashanker8140]

Was stuck in this question, thankyou for the detailed explanation 😢

[@mdasadalihaidar1920]

Hey what was the first question?

[@shabaparween1551]

I got the same coding question, and the way you explained the code was great-very detailed😃

[@layathal7460]

echnical assessment only after clearing this aptitude test? or both are in same test?

[@akashbhoothalingam]

@@layathal7460 After Aptitude

[@mdasadalihaidar1920]

Hey can you share the total timing and how the sections were distributed

[@midhunyentrapati8039]

nee bonda ra

[@swarnavopramanik1701]

@@mdasadalihaidar1920 Cluster 1 exam pattern 👇 2 coding questions of java - 60 min. 2 Sql queries - 35 min. 1 web page making (by help of Html, css, js) - 25 min Cluster 2 exam pattern 👇 2 SQL queries - 35 minutes 2 coding questions - 70 minutes 10 questions from Cloud fundamentals - 15 minutes Cluster 3 exam pattern 👇 2 coding questions of c# - 60 minutes 2 Sql queries - 35 min. 1 web page making (by help of Html, css, js) - 25 min

[@gedelasivakrishna]

hats off mam 👏👏 For you paitence to dry run for every test case. Thanks a lot for all the efforts and they will definitely add value in our life

[@RimjhimKumari-i6l]

I'm really glad to hear that you find the videos helpful. Thank you for your encouraging words. If you have any questions or topics you’d like me to cover, just let me know!

[@akhilsrivastava3560]

Nice explanation

[@kartiknagrale1479]

Prefix sum and binary search can help to reduce time complexity

[@mgworld3342]

Good Explanation

[@Sudharsanr0412]

Sir, I wrote Cognizant aptitude assessment on 18.9.24 and technical assessment on 19.9.24. When do we expect the online assessment result, sir?

[@pratikshaw7381]

Thank you mam ...it was really very helpful 🙏

[@poojabiradar5192]

What type ask in CSS and HTML

[@mehwishkiwish7585]

The second question of sql is from joints so please explain it well I couldn't get your concept please put full answer along with the schema given.. so that its clear

[@RimjhimKumari-i6l]

These questions were received from students, however they didn't shared schema. Since ans in video doesn't involve joining table. It's basic question. If you can share schema, I'll be happy to assist you with answer.

[@monismomin6759]

Ma'am can you provide us video on specific cluster, like we don't know what they are going to ask in AWS, or Web

[@RimjhimKumari-i6l]

sure, I’ll definitely consider creating a video focused on those topics to help clarify what to expect

[@amogu_07]

When will be the results announced ?

[@e2_04_abhijeetkumarsingh6]

ma'am can we write the coding ques in any of the programming language ??

[@ratnatejapoyhuraju3868]

Hi Dude , how many test cases need to be passed for each program ? And how many programs are there for assessment ?

[@satyasankarbera1916]

How to find main table name when Many tables and subtable are given ...??

[@surajpawar9601]

Sir I did 1sql and 1 java completely and 50% of html and good aptitude ..will i be selected in genc next? Plz reply

[@activist-cole]

In cluster 2 how many questions will be asked ?

[@abdulkareemshaik3267]

Solved 4 out if 5 will i get qualified for next round

[@RamRam-hz9em]

@@abdulkareemshaik3267 sure you will

[@AbhishekShelar-ih5dg]

on which basis the cluster is given out of 2 clusters selected

[@themoongirl07]

Did you get any message about the qualification for the next round till today?

[@vishalram4937]

I have got 2.5 correct out of 5 in technical assessment what is the chance of getting shortlisted?

[@RamRam-hz9em]

@@vishalram4937 may be there a chance

[@themoongirl07]

Can you share what type of questions you had for coding...?

[@vishalram4937]

I got 2 questions from array one is gaze in a garden,and other one is car pooling,In html,css part they asked to add a button and change the border radius and add functionality to it I tried but it is giving error in js for functionality even though my syntax and approach was correct

[@themoongirl07]

@@vishalram4937 Thank you

[@khushh.i]

@@vishalram4937 Hey! can u pls tell we have to just write functions? or complete code?

[@ujjawalagupta3844]

In how many days result will declare?

[@shubhajitchatterjee311]

Input: nums = [1,1,1], k = 2 Output: 2 for this test case this code is shows wrong

[@akshatyadav01]

yes this test case will not work. this edge case is difficult

[@lavanyaparitala1910]

Can we take free mock test for this?

[@kyaswanth4584]

2nd sql query wrong mam. in tha schema all the attributes not in the same table we have to join the tables. after that we have to put the condition

[@RimjhimKumari-i6l]

2nd query is not wrong it has been supposed that all attributes are from same table. But as you said in examination they were in another table then yes we will have to join tables. Actually these questions were provided by students they didn't shared schema of table. If you can share schema of table I will be happy to assist you.

[@kyaswanth4584]

​@@RimjhimKumari-i6lhoo yes it's correct. I am thinking that schemas are same but question is different. Actually both schema and questioning also different.

[@rkdivyaroheith7850]

Would we get qualified for interview round if we solve 2 SQL questions and 1 coding question (all 10 test cases passed) correctly, so 3 out of 5 questions completely correct?

[@RamRam-hz9em]

@@rkdivyaroheith7850 Same doubt

[@xiaojunseyebrows8451]

can somebody please tell do we have to give technical assessment according to our 1st preferred cluster?

[@Myself_Karan]

She is improving her English communication skills 😅😅 if am i right 👍👍

[@shreyakumthekar7015]

I have forgotten that which clusters I have chosen in cognizant registration... . Can I check now? Plz reply....

[@kathiharini491]

You will get a mail or else your college placement authorities will inform

[@rajithakitchen01]

Are there any chances for the repetition of questions since i have technical assessment on 27th ?

[@adivyajain4216]

can you please share your questions, i have my exam on 30th

[@ExcitedCamera-dy1io]

Mam,I Have one doubt,Today while I taking the technical test,I talked with my mom,whether this will make me eliminate ?

[@sagar1808]

What about cluster 3

[@l.s.radhika9909]

Mam I have got mail for cognizant aptitude assessment of 80 minutes is it contains only aptitude or technical assessment is also included?? Can you please clarify so that i can start preparing according to that my exam is on 25

[@arjitgautam365]

I also have the exam on 25th. This is only the Aptitude round, the technical round will be later

[@l.s.radhika9909]

​​@@arjitgautam365When will be technical round will they give time gap or not

[@arjitgautam365]

@@l.s.radhika9909 they won't give much time, at max 1-2 days gap will be there

[@srijitadas5483]

hey anyone knows if aptitude and coding round will be held in same day?

[@trivenikakarla9646]

No

[@punitha928]

Totally how many questions will be there in each section, java/ C#, sql and html, CSS, javascript.

[@RimjhimKumari-i6l]

There will be 2 coding questions and 2 SQL queries

[@OnlineStudy4u]

Cluster 1 5 questions 2 Java 2 SQL 1 HTML,CSS,JS

[@prema-h6o]

@@OnlineStudy4u madam i cleares 2/5 share ur thoughts on my next step, can i get any chance

[@prema-h6o]

@@punitha928 plz reply madam

[@RamRam-hz9em]

​@@prema-h6osame here bro,I solved only 2

[@teerathkundu559]

The coding Questions are from which cluster.. please mention it .

[@RimjhimKumari-i6l]

Most probably cluster 1

[@38_rahulshaw48]

can we change languages during the session

[@ehteshamulhassan1122]

The Cluster that you have selected you have to do in that language only. i.e. Cluster 1- Java , Cluster 2- Python , Cluster 3- C#

[@samamadhu5085]

I lost my 😢 exam

[@bharathmanismart9347]

What happened

[@prema-h6o]

2 cleared on one java and one sql any chance of next step?

[@RimjhimKumari-i6l]

Nothing is fixed like this. It depends on cutoff marks of exams, how many questions other have solved comparatively, and company's requirements

[@poojabiradar5192]

In HTML or CSS what type they. Ask

[@studytable2060]

was the test taken from room or college?

[@vimal7750]

​@@studytable2060 Room

[@prema-h6o]

@@studytable2060 room

[@AkkiYadav-u6d]

Time waste.....

[@nithyalakshmi5689]

Would i qualified i did 1 sql , 2 java , and half html css . I qualified for hr round i am cluster 1

[@marishettyeesha4455]

Can please say.. what was the process writing code how u wrote What the major problems u have faced,how u wrote code in java...? Did test cases have passed..?

[@amogu_07]

Same

[@prema-h6o]

5 question java and sql 2 question both, 1 html they will give half code​@@marishettyeesha4455

[@ankitagrahari7453]

U got the output in html css section?

[@adhibalaji560]

this video questions you got ah?

[@sayandutta8071]

Agar dono preference me same cluster 1 dale toh wo reject kar dega application

[@pavithraramineni6897]

No, you will be given cluster1. Because I did the same, I selected cluster 2 for both the preferences and I got cluster 2 and my assessment is today at 2 pm.

[@sayandutta8071]

@@pavithraramineni6897 sure

[@thesaniyaatar1142]

Hi can you share me question​@@pavithraramineni6897

[@hr03creation14]

@@pavithraramineni6897 how did it went

[@pavithraramineni6897]

@@hr03creation14 I messed up sql and couldn't meet any test cases but I met all the test cases for both the python coding questions.I did pretty well in cloud fundamentals MCQs too but couldnt answer one question because the time was up.