TCS SQL Real Interview BY TCS Team! SQL Interview Questions and Answers

TCS SQL Real Interview BY TCS Team! SQL Interview Questions and Answers | TCS Ninja Hiring

Рет қаралды 848,549

Күн бұрын

Пікірлер

@naagarhive6581 10 ай бұрын

00:03 Understanding basic concepts of databases and database management systems 02:26 SQL is a query language for database operations 07:16 Case sensitivity and constraints in SQL 09:45 Foreign key linking and CRUD operations 14:42 Difference between Drop, Delete and Truncate in SQL 16:56 Understanding SQL commands and concepts 21:01 Using aggregate functions and joining tables in SQL 23:30 Understanding Inner Joins in SQL 27:51 Interest in Development Role 30:15 Teamwork is essential for success 34:37 Utilize online tutorials and organizational resources to learn quickly. 36:46 Effective communication and learning during the managerial and technical rounds. 41:15 Importance of technology interest and communication skills 43:19 Confidence and communication skills are crucial for interview performance. 47:15 Clear concepts in English for better communication Crafted by Pradeep Naagar

@Rockstar.919 10 ай бұрын

Its good to have ppl like u on KZbin 😊

@IfNotMe 10 ай бұрын

Thank you bro

@SanjaySanjay-rw6lr 9 ай бұрын

Thank you

@India_Asks 8 ай бұрын

❤ thanks

@brownerjerry174 7 ай бұрын

Bro wrote crafted by his name as if he has written a world disrupting novel.

@SatyarthRanjan-lt1tz 6 ай бұрын

because of this interview i got a chance to revise my sql concepts

@rajatrahangdale869 Ай бұрын

But the table name is case sensitive

@yashpatil6706 26 күн бұрын

@@rajatrahangdale869nope wrong answer

@imranrmd1552 9 ай бұрын

21:49 select count(*) and select count(field_name) difference is select count(*) will count null values but count(fieldname) will not count null values that is difference

@nareshnani608 8 ай бұрын

True not count null values with field count

@consoledoterror971 6 ай бұрын

Thanks

@hrishikeshXXV 6 ай бұрын

ustadi nhi dikhao

@rameshgoud2986 5 ай бұрын

Thank you man

@datalover120 10 ай бұрын

Primary key is combined of unique key & not null that means we can't leave that column blank as well as that record will be unique

@muhammadaknan6023 10 ай бұрын

Primary key is minimal key which satisfied Entity integrity constraint

@babadeepa2011 10 ай бұрын

Beautiful interview and very confident participant

@KingJagguYT 11 ай бұрын

Its a very good interview, very informative...

@ManuHere-fy5jv 6 ай бұрын

This is Helpful For So Many people Thank You For Given your experience to us 🙏❤

@mohdshahzad8856 10 ай бұрын

Great. The way she decribed all the things. Her presence of mind and communication was great.

@TheRealSaviour 2 ай бұрын

Database is not organisation of the structure😂,it is organised collection of data stored electronically

@seansanwhybaptisingmakesch1930 2 ай бұрын

what kind of horrible black dress by the candidate..

@musichd4you Ай бұрын

Even there are many people who speak well in BPO or recruitment side 😅

@Tumharaabbu-xn6cd Ай бұрын

Tere kom ko he toh appreciate toh karega 😂😂😂😂

@syedmajidahmed8292 9 ай бұрын

One of the best interview I have seen... She calmy answered all questions which such grace & confidence.... This is next level 💯 we all should master our communication skill it's extremely important..... Best of luck to her🎉 👑

@murlidhardubey9296 2 ай бұрын

but why she is in black tent

@Danish_khan123 2 ай бұрын

@@murlidhardubey9296Mere muh se English he ni nikalti ideas bahut acche ate hai 😢😢 84% btech mai hai 6 sem tak,interview kiase nikaelga mere muh se English ni nikalti meri bahut khosis ki 😢😢

@mujibultanim 15 күн бұрын

@@murlidhardubey9296 she had no problem with it then why are you bothering? what if we asked you about why you worship elephant, monkey, pig and 69+ crore others? what if we asked you about casteism, sati daha and other women treatments in your religion?

@mdammar 10 ай бұрын

@ar_editz 8 ай бұрын

14:02 The Command is used to insert the multiple columns at a time is wrong because we should not use values keywords multiple times.

@zubershaikh2900 4 ай бұрын

Aap TCS me ho kya bro???

@nitinchauhan6549 10 ай бұрын

generally sql is not case senstive

@SabinPoudel 10 ай бұрын

Yeah in terms of syntax its not case sensitive because Select and SeLect both will work.

@shubhamroy7510 10 ай бұрын

Yes, we should care abt small letters word and capital letters word because it provides readability.

@mahimaprasadnayak7256 10 ай бұрын

but while defining a table name it is

@ravishmahajan9314 10 ай бұрын

Sql is not case sensitive but the data in tables is case sensitive. SELECT & select are same. Table name, index name all are case insensitive. But data in table columns "SQL" is different from "sql"

@gstylegaming8658 9 ай бұрын

Correct so it will not create a new table it will give an error that the table already exists

@Bagad_billa24no 9 ай бұрын

SQL is not a case sensitive language but for table name , column name, e.g it depends on case ❤

@hiteshrs4457 7 ай бұрын

Case-Insensitive: MySQL and SQL Server (when not configured otherwise) typically treat identifiers as case-insensitive. This means that "Table1" and "table1" would be considered the same. Case-Sensitive: PostgreSQL and Oracle (when not configured otherwise) treat identifiers as case-sensitive. So "Table1" and "table1" would be considered as different.

@Shyam_1567 16 күн бұрын

@@hiteshrs4457interviewer told me at the end of my interview Good I will share your details with hr This means?

@prasadjoshi9368 8 ай бұрын

Must appreciate the way she is giving answers superbb👌👌

@ShaikMuzammil-n4r 10 ай бұрын

Excellent and awesome performance Good one🎉

@RiyaSingh-ty2cu 3 ай бұрын

at 21:49 Count(*) will count total number of rows from a table be it null or not null where as Count (attribute_name) will count no of rows in that particular attribute(column) ignoring null rows.

@evilhunter662 Ай бұрын

But here we applied a constraint that primary key exist in table so any null record who if have primary key value not null and all other values null will be counted and if primary key is also null then we cannot add that null record as we already specified primary key not while defining table so in both cases number of records should be same what do you think

@Shyam_1567 16 күн бұрын

@@evilhunter662interviewer told me at the end of my interview Good I will share your details with hr This means?

@piyush42962 10 ай бұрын

Excellently handled the questions.

@simplyanup9658 8 ай бұрын

SQL isn't case sensitive. When you try to to create another table with name of any case of existing table name, it won't create.

@RS-3_roses 8 ай бұрын

Yes, you're correct.

@ellenmarygeorge8130 6 ай бұрын

Mysql databases are not case sensitive...if you create a table with tablename EMPLOYEES and create another table with tablename employees .Both will be different tables.

@dhikeshmm620 5 ай бұрын

Basic logic...u cannt give same name to multiple tables...irrespective of case sensitive

@faisalchauhan6380 6 ай бұрын

the question which was asked i find it very easy becz i had sql in my previuos semester

@dsa-j8x 5 ай бұрын

having in semester is completetly different when it comes to nterview i hope you understand it when you face the inrerview

@zidhas546 10 ай бұрын

very nice interview....had an exposure of the interview environment

@naveen_maddela 10 ай бұрын

Very usefull 🎉 Very good one

@saralachattar8243 10 ай бұрын

It's very beautiful interview and so more helpful to everyone

@smita1668 7 ай бұрын

Quite informative and helpful video.

@_MSTHAKUR 6 ай бұрын

at 19:50 when we are using a temp name for a column to hide the orginal name then what if someone see's that query there you are pitting na its orginal name like (roll no as ROl)

@sanjaybhandari2144 5 ай бұрын

Output Table won't have the original column name, but If u want to hide it from developer than DBA can use views to create an abstraction.

@pandu7820 9 ай бұрын

i think in sql table names are not case sensitive

@Par_323 8 ай бұрын

Yes

@svbhomesproperties4958 3 күн бұрын

Very informative interview and useful for freshers and experience person's

@krishnaRaog21 6 ай бұрын

Candidate has done very well in the interview ..Congratulations

@abhishekchauhan2601 4 ай бұрын

You should also learn sql

@seansanwhybaptisingmakesch1930 2 ай бұрын

what kind of horrible black dress by the candidate..

@Shyam_1567 16 күн бұрын

@@abhishekchauhan2601interviewer told me at the end of my interview Good I will share your details with hr This means?

@MasterMinds-pk7vp 7 ай бұрын

DDL does NOT required commit, auto commit, delete can be rolled back.

@sanjaybhandari2144 5 ай бұрын

DDL is mostly auto commit ,but is configurable in some databases.

@srikanthsri85 5 ай бұрын

Yes you said the answer ddl commands like create alter drop truncate rename once used these commands fetched the data auto commit.

@wobaidurrobtareq3941 9 ай бұрын

She is so confident best wishes for her.

@saidinesh4397 7 ай бұрын

@7:50, tables,databases are not case sensitive. in sql, nothing is case sensitive.

@suhailshaikh1771 6 ай бұрын

it is case sensitive though

@magxbeats 6 ай бұрын

Create table Student & student as table name will create 2 different table man it's case sensitive as for queries it's not case sensitive

@saidinesh4397 5 ай бұрын

@@magxbeats sql throws an error . a database should have an unique table_name. it doesnt create a new table if you change the case. sql stores tablenames in lower case only.

@Tussu17 5 ай бұрын

Not sure about other but in Postgres it is case sensitive.

@mr_affan15 10 ай бұрын

Informative interview excellent ❤

@heebakouser4529 11 ай бұрын

Very useful 👌

@mohammadjaved4044 10 ай бұрын

Good interview and confident participant

@shabbir.j.kholiya9886 10 ай бұрын

It's informative

@asceticadarsh8284 10 ай бұрын

22:21 With agg function we need to use group by function

@dhanushreddy4367 8 ай бұрын

Yes. But it is not mandatory. When the query is simple there is no need to use aggregate function. It all depends on the condition.

@abdulkafeel2849 10 ай бұрын

please upload interview for cloud engineer

@TTT-oj1mj 10 ай бұрын

Hi are you Embedded Systems engineer?

@muhammadrezaulkarim5850 10 ай бұрын

She is excellent

@frozenlove3198 10 ай бұрын

Non Madarsachap.

@trueworld3604 10 ай бұрын

Excellent👍

@ishraquekhan2058 2 ай бұрын

Very confident candidate

@123....infinityanish2 11 ай бұрын

Excellent❤

@TusharPatil-fu1qg 4 ай бұрын

Excellent 👌

@gouravshaw6939 6 ай бұрын

wonderful interview!

@muskan2651 10 ай бұрын

Very informative

@GB-fn2to 6 ай бұрын

She is very confident. Good interview 😊💯👍

@naimahmad3615 10 ай бұрын

She handled the interview very well👍👍

@chaitraram4992 10 ай бұрын

Easy n basic interview

@laxmanbudhewad7611 10 ай бұрын

Yes too easy questions 😂

@thariq94__ 9 ай бұрын

Good For freshers

@vivekgodse3685 8 ай бұрын

@@laxmanbudhewad7611 yes SQL is easier than programming language :)

@shaiksajid613. 8 ай бұрын

Easy 😂😂😂

@prakharsrivastava6571 9 ай бұрын

select name , max(rollno) from student group by name ???

@PreetBhanushali1234 6 ай бұрын

The answer of the name of student with maximum marks can be done using a sub query. The answer is : Select name from student where marks =( Select max(marks) from student); Here the query inside round brackets is knows as inner query which will be executed first which will be used as a parameter for where clause for outer query. I hope this helped you .😊😊😊😊

@nawelfardeheb5657 9 ай бұрын

very useful, thank you

@advocatemz3152 10 ай бұрын

Great session

@salmanshaikh-zj1cg 10 ай бұрын

Great and confident 👍

@vivektarab16 3 ай бұрын

0:50 - Database Management Q 1:32 - RDBMS 2:55 - What is SQL 5:18 - Create Table 10:58 - Select Query

@techwitharbaz4506 5 ай бұрын

ITS WAS INFORMETIVE

@youtubveeru 10 ай бұрын

useful.. nice,good,

@Savethetigerr 6 ай бұрын

Excellent 👌👍

@sumaiyashaikh4286 10 ай бұрын

Excellent,superb 👍

@haariskhan5307 10 ай бұрын

in which domain you are preparing?

@jblseng 10 ай бұрын

@@haariskhan5307AI/ML

@vaishnavikodag2966 10 ай бұрын

Nice interview 😊

@animeshbiswas2754 8 ай бұрын

🎉 thank you

@mohimakhter6597 3 ай бұрын

SQL is not case sensitive

@m.kirubakaran6564 10 ай бұрын

Nice👏👏👏👏👏👍👍

@Mahesh-rt4jg 7 ай бұрын

In depth answers!

@cherrytales7617 4 ай бұрын

Useful

@siddheshpatil1271 6 ай бұрын

that is girl so much talented

@souravtewari4597 7 ай бұрын

Really Very Helpful

@Musakhan-g1k9c 7 ай бұрын

Very good answer ... Confidence level 👍

@rameshgoud2986 5 ай бұрын

Very useful

@askgaming99-cq6rr 6 ай бұрын

Excellent 🥰

@SaiVlog_9 9 ай бұрын

Sql is cas insensitive student and Student is same

@user-rg9kx7ibccd 10 ай бұрын

The interview is too easy and basic even for a fresher. 😂

@StartreckTu 9 ай бұрын

First of all understand that the interview questions depends on the level of the candidate. For junior levels we just only need to cover the basics and they will anyways to be guided by senior developers.