Print this info in your brains for DROP vs TRUNCATE vs DELETE DROP: Deletes the entire table along with its structure TRUNCATE: Deletes the entire table but not the structure DELETE: Deletes the entire table but the changes are not saved until you perform COMMIT. So basically, if any DDL command like DROP or TRUNCATE is executed an auto COMMIT is performed but we have to explicitly run the COMMIT command to save the changes permanently after we have executed a DML command. No other thing is required and interviewer will be satisfied. Thank you!

@vijayXvirat

11 ай бұрын

thank you very helpful

@maheshtiwari2297

10 ай бұрын

In case of ddl we don't have to use commit statement. But in case of dml we have to do the commit to save the changes in tha databases. Also dml can be rollback but ddl can not .

@adnanhussain9276

10 ай бұрын

Yup Master data file ,userdefined data file ..

@closed482

10 ай бұрын

​@@maheshtiwari2297ddl also can be rollbacked

@AmolGautam

10 ай бұрын

Thanks for this. But depending on the DB engine, this might not be true. example : In postgresql, the default setting is 'autocommit : on' . So every statement ( irrespective of DDL or DML ) is a transaction, unless specified otherwise.

*Simple English NO CONFUSION !!* 11:00 Drop : Deleting entire table (DDL), no more evidence of table. DROP table ; Truncate: deletes all the rows of a table (DDL), structure of table is still available. TRUNCATE table ; Delete: delete one or more rows of a table (DML), commit is required. DELETE FROM table_name WHERE condition

I like it sir And very very helpful videos Isi trah ka video de har syllabus pe..

Really helpful 👍 Thanks for sharing 🤝

Thanks for the video 😀

Thank you so much for this amazing interview video, you are doing great help to students

Implicit cursors are automatically created when select statements are executed. Explicit cursors needs to be defined explicitly by the user by providing a name.

@punnareddy8835

Жыл бұрын

Not only select , for update and delete as well..

@supriyokumar8802

Жыл бұрын

Correct after any DML operation.😊

Difference between Delete, Drop and Truncate Delete * delete is a dml command that is why it is used to delete values from table only not the structure * delete is used to delete either single row or all rows from the table based on some specific conditions * delete command doesn't deallocate the space used by the row and hence this memory cant be used to store other values * delete can be rollbacked to previous savepoints syntax: delete from table_name delete from table_name where roll_no = 15 Truncate * Truncate is a DDL command which is used to delete all the records from the table * it delete all the rows from the table * it do not delete the structure of the table * it deallocate the memory assigned to the rows and this freed space can be used to store other values * it cant be rollback * it is usually faster than delete syntax: truncate table table_name Drop * Drop is a ddl command which is used to delete the already existing database object such as table, database * drop delete the whole table and it remove the structure as well * it immediately release the space * it cant be rollback * it is fastest syntax: drop table table_name drop database database_name

thanks bro nice video

Good initiative .. Very Helpful for Job seekers ..

from my experience he dosen't have a clear understanding of sql concepts but the questions asked by the senior is great

@LuciferMorningstar-tf5ls

2 жыл бұрын

Who asked you to judge? Keep your thoughts, it's precious it will help you to judge yourself.

@killerdroid99

Жыл бұрын

@@LuciferMorningstar-tf5ls rightfully said

@sulaimansheik4591

Жыл бұрын

Everyone don't know everything also sql is not that mumbo jumbo any one can learn it on the job

@ceylongamersleague9733

Жыл бұрын

Who asks Commands on T-SQL in an interview? so you're wrong dude

@sudarshanpatil2227

Жыл бұрын

@@sulaimansheik4591 go home and sleep

helpful video ☺️

Keep in the loop

He wants more understanding about reality of DB,RDBMS &SQL. But I can't believe it's from TCS. He tried well.

@hrishikeshkumar7433

Жыл бұрын

It's mock interview bro. It's is not real interview.

@ioannischristou2362

Жыл бұрын

mock interview, but as a college instructor of RDBMS, if a student of mine gave such answers, they would immediately fail the course...

@pranav288

Жыл бұрын

@@ioannischristou2362 that shows how bad the college instructors teach

@anchalpandey9074

Жыл бұрын

nah bro the candidate really holds a good knowledge as being a fresher and REAL interview r not even 20% of it lol they just made it look too serious.

@satibomofficial5200

Жыл бұрын

@@anchalpandey9074 yeah they just see graduation & what kinda skills you have ..

very good vedio helpful.

Alter command is a DDL command For editing column name using alter command only using Alter table tablename change column old_name new_name;

finished watching

Sir, this is very helpful...Thanks a lot...please make a video on MEAN stack then it will be very helpful for us...

More informative.... thanks for plenty of efforts...

Delete command is used to remove the rows from the table but it's not clear the table space. For trunc it will also remove the rows from the table but it's clear the table space. Drop command used for removing the entire table structure.

Good 👍

very helpful.....please do video On only SQL interview for freshers

Dbms is a management system that helps in managing ,retrieving data from a database .. it like a ui that helps customer interact with the underlying database system.... whereas sql is a query language..

@bhaskarm632

Жыл бұрын

True. We can query database in multiple ways SQL is one of the way

@josejayant3127

Жыл бұрын

DBMS is not like a UI.

@idriveridesharing6493

Жыл бұрын

Don't behave as if you know everything You don't know anything

@entertainingshorts24

Жыл бұрын

Anyone please tell that can alone SQL lands you a job in any IT company. Actually I want to join IT sector that's why.

@maheshtiwari2297

10 ай бұрын

​@@entertainingshorts24 learn SQL with Excel that would be helpful for business analyst job also you can learn power bi which is just required 3-4 months.

Thank u for this video..its very helpful to prepare for interview

Everytime the interviewer says "aienn".. he means it and you know that you have made some mistake.

Delete is DML (Can be rolled back)command but truncate is DDL(auto commit) command

@theengineersdesk7930

2 жыл бұрын

Yes

@kingmakerzz123

2 жыл бұрын

@Rohit Rahane use delete if u want to rollback the command to the before deletion state, use truncate if its for a permenant deletion

@dassundaram

Жыл бұрын

@Rohit Rahane learn sql before comment

@pasinduekanayaka8023

Жыл бұрын

@@samsungtv2911 TRUNCATE doesnt delete the whole table, DROP deletes the whole table. As someone pointed it out, the DELETE can be rolled back while the TRUNCATE cannot.

@mushu8432

Жыл бұрын

When we use Delete command to delete all records from Table Identity column retain But when truncate command use identity column reset

Begin Select * from tablename; End it should work..some times sp have no parameter and not requured declare any variable.interviewer concept also not clear

@dineshchandrag2640

2 жыл бұрын

It will throw error in plsql It will work in TSQL

good interview

Being in college I would like to say he is just asking simple and medium level questions of SQL like command and etc

@nationalist3662

Жыл бұрын

TCS ka interveiw hai...google ka nahi🤣😂... What to expect..

@floridan1238

Жыл бұрын

INR 25k salary

@carcrazynishant

Жыл бұрын

What are some of the medium and difficult questions that are generally asked.?

@sourjadhar9332

Жыл бұрын

As a fresher aur kia puchega bhai?

Please make a video on Oracle SOA Developer

Stored programs date functions , char, numeric functions will be used in sql

Very nice interview questions 👌🏻

Make a vedio of. Net developer

Is he fresher? Look like fresher

As a fresher , he has good knowledge for TCS

@MrGoodLuck

10 ай бұрын

😂

@nishanthbunnu2582

10 ай бұрын

Joke of the day 😂

@views-re2om

7 ай бұрын

i am ux designer he is dumb and fit for TCS

@rd-rams2193

6 ай бұрын

😂

Look like simulation of TCS Fresher interview: Overall all it is good simulation but TCS Interview will not be this long for Fresher also Fresher will not be evaluated just on topic e.g. SQL etc as your specialized area will be choosen once you join TCS and you will only expected to know basics here lots of advance questions were asked

@sanmanbhusari496

2 жыл бұрын

But I think this could be understood as a interview for someone who has around 1-2 years of experience

@sanatanihindu3089

2 жыл бұрын

@@sanmanbhusari496 what is duration of tcs interview

@sanmanbhusari496

2 жыл бұрын

@@sanatanihindu3089 15 -30 mins on average

@techkumar9760

Жыл бұрын

@@sanatanihindu3089 12 to 20 min

@shazzl

Жыл бұрын

I've given interview trust me it was for 5 minutes😂

Thanks

Update table name set salary = 1000 after that you must commit else it will not be committed unless you set auto comit in settings

TCS interview are so detailed I did not know this

@HiteshSote

2 жыл бұрын

I think its for experienced 1-3 yrs

@ankshi80

2 жыл бұрын

No yarr I have just learn all this in my BCA 4th sem and I can answer maximum questions

@vijaybhaskar0777

Жыл бұрын

Good improve pooja

@Somnath-je9nd

Жыл бұрын

@@HiteshSote are u sure??

package is 15 years old and questions are also of same era

An SQL UPDATE statement changes the data of one or more records in a table. Either all the rows can be updated, or a subset may be chosen using a condition. The UPDATE statement has the following form: UPDATE table_name SET column_name = value [, column_name = value ...] [ WHERE condition]

@entertainingshorts24

Жыл бұрын

please tell that can alone SQL lands you a job in any IT company. Actually I want to join IT sector that's why.

@entertainingshorts24

Жыл бұрын

@@harshitverma2707 ok, Also plz tell complete free bootcamp for SQL.

@Manojkumar__

Жыл бұрын

@@entertainingshorts24 you can get this from KZread/Google just by searching

That's why I use prisma for database interaction

How to apply for this role?

Delete data can perform rollback , but truncate is auto commit, only dba can get back from back end.

@hellocartoons1735

2 жыл бұрын

Thanks

@rahulvani5969

Жыл бұрын

lol

The alter table is DDL comand in sql

Alter =DML command 6:50😂

:') These qualifications woun't even give me chance to be in an internship in Bangladesh :')

My tcs interview is very easy, just asked about my project and some questions. Just 20 minutes. It is very easy to clear the round.

@Ak-um1yg

2 жыл бұрын

Hello bro please answer U were selected in TCS digital? On campus or Offcampus?

@jaideeplobo6096

2 жыл бұрын

@@Ak-um1yg off campus

@Ak-um1yg

2 жыл бұрын

@@jaideeplobo6096 Bro please tell the procedure .. I am in Third Year of my Computer Engineering ...I need some guidance .... Had u done any industrial internship ? .I think u had given TCS NQT ?? how much was your score ..and what is the procedure after that ...What did they ask in the interview ..In the interview did they ask U to code??? Or only theoretical questions based on Project / intership . Did they ask about Machine Learning/ Ai/ Cloud/SQL like technologies?? If u take some minutes and answer these questions it will be really helpful .. 🙏🙏🙏🙏🙏

@jaideeplobo6096

2 жыл бұрын

@@Ak-um1yg these type question asking only in product base company like Amazon. It is tcs they need 100k employees this time, so whoever clears the first round then think they are selected in the company same for wipro also (i got placed in 3 companies). In tcs they asked about my project only no coding and questions. In wipro 2 coding questions like sorting (wipro taken 5 minutes interview to me). Don't worry bro better good in communication first and use hackerearth platform to practice ur coding skill. This much enough to crack any interview. All the best :)

@Ak-um1yg

2 жыл бұрын

@@jaideeplobo6096 Thank you so much ... 🙏🙏 Please answer this last question ... Did u do any Internship ?? And I think u r in Fourth year ...For TCS NQT Third Year students are also eligible I am thinking to give that test ...How much was your Percentage?? Bro my senior told to do intership for better job offer...But industry intership demands too much Congratulations for getting selected ...All the best for your Bright future

The interview is about basic sql command

He has joined TCS three months back and even he doesn't know the services provide by the tcs , and name of CEO .... also he does not prepared very basic queries...

@vinaylanjewar7210

2 жыл бұрын

Is it true ???

@bendover-bz4bc

2 жыл бұрын

Why do you need to know CEOs name ? Is this private company or poltical dynasty where you have to lick your leader's boots ?

@santoshtale1243

2 жыл бұрын

He just trying to give answers like a fresher

@try3825

Жыл бұрын

@@bendover-bz4bc true brother why would we care who the hell they are. we just want to work and get some money... #shitcorporate

SQL plus means user practice compiler...

i used to take interview for TCS.. actual tcs interview for fresher need not be like this

@learnenglish699

2 жыл бұрын

kya salary dete hai ?

@josesantana7085

2 жыл бұрын

What is TCS

@dpu11

2 жыл бұрын

@@josesantana7085 its an Indian IT services consulting company

@dpu11

2 жыл бұрын

@@learnenglish699 check glassdoor

@josesantana7085

2 жыл бұрын

@@dpu11 thanks

Man this interview is disaster

Procedure is numerical method functions is varchar

mera bhi kra do tcs m interview

Rajesh Gopinathan ceo of TCS

Interviewer is expecting more from a fresher

@AIBot354

2 жыл бұрын

But the interviewee is not able to list the DDL Dml commands...and he was answered all questions wrong.

@utkarsh_108

2 жыл бұрын

@@AIBot354 that's the mistake freshers do. quality over quantity

basics should be brushed up well here ...

It seems like fresher interview

thank you panel for making out 0:42

@bottomfraggergg

Жыл бұрын

🤣

You can't ask scenarios in an interview that came across in your work

Truncate basically drops the table and creates the structure back ..so it is ddl and dml both

ALTER and CREATE is DDL command INSERT,UPDATE AND DELETE are the DML command

You must drop table

We can use sp.rename to rename a column

My Question is that he is selected or not?

thanks for interview panel

How to apply TCS fresher Oracle developer job

Delete maintains transaction logs but Truncate can't.

@mitunarine6268

4 ай бұрын

Yes

He's naive, these questions are extremely basic is it for fresher?

Truncate deleted the entire data, drop deleted in the data from the table, it was auto commit so we can't retrieve. delete option in dml so we can rollback if before commit and we need to use save point

@DhavalAhir10

2 жыл бұрын

You are wrong, Truncare deleted just only data not schema.. But drop deleted data as well as schema

@DhavalAhir10

2 жыл бұрын

@STANDARD DEVIATION 🤣🤣🤣🤣🤣

@cktech9

2 жыл бұрын

Ever since table structure remained same, schema will not be deleted only if we use truncate. But drop deletes data along with table structure, we could expect shema would also be deleted.

Candidate has good articulation but needs more practice on SQL commands.. I don't think he has cleared this round.

@epsilon5437

Жыл бұрын

It is mock round only

How panel select the subject for the technical round? Is it from the skills mentioned on cv or it can be anything? Plz I want to know

@makenowacademy

Жыл бұрын

its from cv and in job description it will be mentioned

Where is implementation

Acc he got nervous

We have delete , truncate, drop command to delete data , table..

Useful..how much experience he hace?

I have been doing sql for years and sometimes I forget the actual definition of things, but I know how to use them. This is why for interviews I would just go over a DBMS cheat sheet.

@ankitgupta3604

Жыл бұрын

Hi there, do u have any cheat sheet with u. I need to appear for the interview but finding the preparation a bit difficult. Any help will be highly appreciated. Thanks

@itsme_notbatman

9 ай бұрын

Hi, same question..kindly help

TR interview duration is just 30min

Kal hi interview hua tha mera 2 hours Jisme Query or practical 80% and 20% theory So Query likhna sikhe Unlimited practice kriye

@ashugoswami1263

Жыл бұрын

Kis cheez ka interview tha bhai..?

All hierarchy answers through based on your KZread video may be zigzagged

Passport services

Basically !!

Procedure performance an action and function returns one value and if you want to retrieve more values use loops and cursors

@easha30

Жыл бұрын

Answer for that question is to use OUT parameters while calling a procedure or function to return more than one value.

@user-zq3hr5fj8h

Жыл бұрын

Pipeline function

Its too much 51min interview aah...OMG

@k.l3447

2 жыл бұрын

Ss

Implicit cursors and explicit cursors

Anyone please tell that can alone SQL lands you a job in any IT company. Actually I want to join IT sector that's why.

I think it is implicit or explicit cursor not commit

@bhagyasudhir1060

Жыл бұрын

No implicit commit is there ..for DDL commands automatically one implicit commit created,DML not .. actually DDL commands directly interact with database DML commands not Interact with database directly so that's why when we use the truncate (DDL command) the data deleted faster than Delete(DML command)..so the interviewer expecting that

Rajesh gobinath ceo in tcs

Hello sir, if possible can you please arrange real interview for me

DDL (Create, Alter, Drop, Truncate ) DML (Insert, Update, Delete, Lock) DCL(Grant, revoke) DQL(Select) TCL(commit, Saveponit, Rollback, Set Constrain, set transection)

Update tablename Set Salary=1000 Where catageroy=departmentname

Truncate basically remove indexs also but delete don't

@shakiraafshan6544

2 жыл бұрын

No truncate removes only table data it's constraints, indexes etc will still be retained. Neither delete nor truncate will remove index

Dear sir, I am ready to give the interview, if possible please arrange.

@_mafia_gaming2087

Жыл бұрын

Hello

@sushamakumari4886

Жыл бұрын

Do you know ,how we can give this mock interview?

Sir jst could I ask a question can we explain something like definations in Hindi . Bocz e many candidate are can't fluently English

@makenowacademy

Жыл бұрын

no use of hindi . I just want to say that before interview write a scenario and have more and more mock interviews so you can give the same in interview in english . You just need to convey your answer properly

@14:19 the answer shocked Mr. Srinivas

@ManishbihariYT

2 жыл бұрын

Yes because of group by

You can use varchar2(50) type datatype where it will only use needed space , suppose your name has 10 charector then it will automatically del 40 from size 50...

@revathysubramani6891

9 ай бұрын

Is that possible to change or alter the data type suppose varchar2(50) was created intially can we alter it to varchar2 (70) later

@impossible6389

8 ай бұрын

​@revathysubramani6891 yes. We can change the datatype

Interview main English main comfortable ni hai to. Hindi main de skte hai ki ni. Matlab Hindi mix English??????

@ranjanmaithani6263

2 жыл бұрын

That's the issue. You should be able to communicate in English otherwise you won't be able to communicate with your team members only cuz they might be from different part of the country

@omiii5763

6 ай бұрын

Bhaiya kannad me bhi de sakte ho 😅

No dil will be rolled back

Please tell me only oracle(sql/plsql)can we get the job