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!
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 .
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
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
Implicit cursors are automatically created when select statements are executed. Explicit cursors needs to be defined explicitly by the user by providing a name.
@@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.
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]
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
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..
@@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.
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.
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
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...
@@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 .. 🙏🙏🙏🙏🙏
@@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 :)
@@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
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
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.
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.
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
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
If you choose DBMS only then the deeper knowledge questions would be asked... But if you're from data science so it will include the languages that are used within data science. Because DBMS means managing a database and to manage that database A structured query language (SQL) is used... Same goes with the Data Science domain... If you mention that you're into database or might have been using a database to store your data and use the CRUD and other options on it then some of these questions are for sure to be asked about.
i want to ask a question that , fluent english is mandatory for interview bcoz sometime candidates has knowledge but they don't express front of interviewer bcoz he don't speak english fluently. bcoz i am one of them😊
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
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...
How to learn? I am jobless since 2018. I was trying to get a job in core sector but couldn't get any. Is it possible to get one in IT sector provided I learn the skills?
@@divyanshushankar8134 Han bhai learn from you tube take 1 language and then start practising it on geeks for geeks and sort by easiest ones in GFG and SQL . Later if you’re okay with basics start learning DS and take some project
Sir/madam, My final round was happend in 3-4 day's ago. When shall I get the final selection information from the side of TCS? If selected what shall I have to do before joining as practice? Are there any option to select own choice of location? I am waiting for your valuable response.
@@jyotirmoyhati7724 yes ,you will be offered to choose a location plus now you just have to wait for their reply mail with offer letter . Most probably the training will be online. Learn python or java plus sql and some bash shell language as it helps in the obtaining the extra 60k bonus on joining. (IPA Exam)
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
Sql is not an program language which doesn't have any conditional and loop statements and logical operations it can't be used anything other than data manipulation
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!
thank you
very helpful
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 .
Yup Master data file ,userdefined data file ..
@@maheshtiwari2297ddl also can be rollbacked
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
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
from my experience he dosen't have a clear understanding of sql concepts but the questions asked by the senior is great
Who asked you to judge? Keep your thoughts, it's precious it will help you to judge yourself.
@@LuciferMorningstar-tf5ls rightfully said
Everyone don't know everything also sql is not that mumbo jumbo any one can learn it on the job
Who asks Commands on T-SQL in an interview? so you're wrong dude
@@sulaimansheik4591 go home and sleep
Implicit cursors are automatically created when select statements are executed. Explicit cursors needs to be defined explicitly by the user by providing a name.
Not only select , for update and delete as well..
Correct after any DML operation.😊
DDL (Create, Alter, Drop, Truncate ) DML (Insert, Update, Delete, Lock) DCL(Grant, revoke) DQL(Select) TCL(commit, Saveponit, Rollback, Set Constrain, set transection)
He wants more understanding about reality of DB,RDBMS &SQL. But I can't believe it's from TCS. He tried well.
It's mock interview bro. It's is not real interview.
mock interview, but as a college instructor of RDBMS, if a student of mine gave such answers, they would immediately fail the course...
@@ioannischristou2362 that shows how bad the college instructors teach
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.
@@anchalpandey9074 yeah they just see graduation & what kinda skills you have ..
Alter command is a DDL command
For editing column name using alter command only using Alter table tablename change column old_name new_name;
Delete is DML (Can be rolled back)command but truncate is DDL(auto commit) command
Yes
@Rohit Rahane use delete if u want to rollback the command to the before deletion state, use truncate if its for a permenant deletion
@Rohit Rahane learn sql before comment
@@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.
When we use Delete command to delete all records from Table Identity column retain
But when truncate command use identity column reset
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]
please tell that can alone SQL lands you a job in any IT company.
Actually I want to join IT sector that's why.
@@harshitverma2707 ok,
Also plz tell complete free bootcamp for SQL.
@@entertainingshorts24 you can get this from TH-cam/Google just by searching
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
It will throw error in plsql
It will work in TSQL
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..
True. We can query database in multiple ways SQL is one of the way
DBMS is not like a UI.
Don't behave as if you know everything You don't know anything
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.
@@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.
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.
As a fresher , he has good knowledge for TCS
😂
Joke of the day 😂
i am ux designer he is dumb and fit for TCS
😂
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
But I think this could be understood as a interview for someone who has around 1-2 years of experience
@@sanmanbhusari496 what is duration of tcs interview
@@sanatanihindu3089 15 -30 mins on average
@@sanatanihindu3089 12 to 20 min
I've given interview trust me it was for 5 minutes😂
Being in college I would like to say he is just asking simple and medium level questions of SQL like command and etc
TCS ka interveiw hai...google ka nahi🤣😂... What to expect..
INR 25k salary
What are some of the medium and difficult questions that are generally asked.?
As a fresher aur kia puchega bhai?
Thank you so much for this amazing interview video, you are doing great help to students
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...
Is it true ???
Why do you need to know CEOs name ? Is this private company or poltical dynasty where you have to lick your leader's boots ?
He just trying to give answers like a fresher
@@bendover-bz4bc true brother why would we care who the hell they are. we just want to work and get some money... #shitcorporate
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.
Hello bro please answer
U were selected in TCS digital?
On campus or Offcampus?
@@Ak-um1yg off campus
@@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 .. 🙏🙏🙏🙏🙏
@@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 :)
@@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
Delete data can perform rollback , but truncate is auto commit, only dba can get back from back end.
Thanks
lol
Is he fresher?
Look like fresher
I like it sir
And very very helpful videos
Isi trah ka video de har syllabus pe..
Candidate has good articulation but needs more practice on SQL commands.. I don't think he has cleared this round.
It is mock round only
Update table name set salary = 1000 after that you must commit else it will not be committed unless you set auto comit in settings
Interviewer is expecting more from a fresher
But the interviewee is not able to list the DDL Dml commands...and he was answered all questions wrong.
@@AIBot354 that's the mistake freshers do. quality over quantity
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
You are wrong, Truncare deleted just only data not schema..
But drop deleted data as well as schema
@STANDARD DEVIATION 🤣🤣🤣🤣🤣
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.
Really helpful 👍
Thanks for sharing 🤝
Kal hi interview hua tha mera 2 hours
Jisme Query or practical 80% and 20% theory
So Query likhna sikhe
Unlimited practice kriye
Kis cheez ka interview tha bhai..?
package is 15 years old and questions are also of same era
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.
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
Hi, same question..kindly help
TCS interview are so detailed I did not know this
I think its for experienced 1-3 yrs
No yarr I have just learn all this in my BCA 4th sem and I can answer maximum questions
Good improve pooja
@@HiteshSote are u sure??
very helpful.....please do video On only SQL interview for freshers
Sir, this is very helpful...Thanks a lot...please make a video on MEAN stack then it will be very helpful for us...
Good initiative .. Very Helpful for Job seekers ..
thank you panel for making out 0:42
🤣
@14:19 the answer shocked Mr. Srinivas
Yes because of group by
Delete maintains transaction logs but Truncate can't.
Yes
Stored programs date functions , char, numeric functions will be used in sql
Everytime the interviewer says "aienn".. he means it and you know that you have made some mistake.
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.
Man this interview is disaster
Interview main English main comfortable ni hai to. Hindi main de skte hai ki ni. Matlab Hindi mix English??????
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
Bhaiya kannad me bhi de sakte ho 😅
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
its from cv and in job description it will be mentioned
The interview is about basic sql command
How to apply for this role?
ALTER and CREATE is DDL command
INSERT,UPDATE AND DELETE are the DML command
Thanks for the video 😀
I think you should add one more thing after interview you should send mail to person you are selected or not , who gave interview
In real-time they will get back to you on Monday
Technical round- he already gone wrong..
Procedure is numerical method functions is varchar
Its too much 51min interview aah...OMG
Ss
How to apply TCS fresher Oracle developer job
Thank u for this video..its very helpful to prepare for interview
Alter =DML command 6:50😂
He's naive, these questions are extremely basic is it for fresher?
Are these questions asked for everyone common for all computer streams or only those who choose data science stream
If you choose DBMS only then the deeper knowledge questions would be asked... But if you're from data science so it will include the languages that are used within data science. Because DBMS means managing a database and to manage that database A structured query language (SQL) is used... Same goes with the Data Science domain... If you mention that you're into database or might have been using a database to store your data and use the CRUD and other options on it then some of these questions are for sure to be asked about.
@@tanyasingh5453 noted thanks 🙏🏻
helpful video ☺️
i want to ask a question that , fluent english is mandatory for interview bcoz sometime candidates has knowledge but they don't express front of interviewer bcoz he don't speak english fluently. bcoz i am one of them😊
it depends you just need to convey the things properly to the interview about the concept or answer thats enough
I think it is implicit or explicit cursor not commit
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
You can't ask scenarios in an interview that came across in your work
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...
Is that possible to change or alter the data type suppose varchar2(50) was created intially can we alter it to varchar2 (70) later
@revathysubramani6891 yes. We can change the datatype
What a mess bro 😳.. I m from Civil Engineering, and in 2 months I learned Python,SQL,Excel . Probably more than him🙄..
U get any interview?
How to learn? I am jobless since 2018. I was trying to get a job in core sector but couldn't get any. Is it possible to get one in IT sector provided I learn the skills?
@@divyanshushankar8134 mechanical ?
@@divyanshushankar8134 Han bhai learn from you tube take 1 language and then start practising it on geeks for geeks and sort by easiest ones in GFG and SQL . Later if you’re okay with basics start learning DS and take some project
@@adityab.k7286 civil
My Question is that he is selected or not?
finished watching
thanks bro nice video
Update
tablename
Set
Salary=1000
Where
catageroy=departmentname
Truncate basically remove indexs also but delete don't
No truncate removes only table data it's constraints, indexes etc will still be retained.
Neither delete nor truncate will remove index
The alter table is DDL comand in sql
:') These qualifications woun't even give me chance to be in an internship in Bangladesh :')
Under how many days TCS inform as mail after final examination? Please reply.
2 months
Sir/madam,
My final round was happend in 3-4 day's ago. When shall I get the final selection information from the side of TCS? If selected what shall I have to do before joining as practice? Are there any option to select own choice of location? I am waiting for your valuable response.
@@jyotirmoyhati7724 yes ,you will be offered to choose a location plus now you just have to wait for their reply mail with offer letter
. Most probably the training will be online.
Learn python or java plus sql and some bash shell language as it helps in the obtaining the extra 60k bonus on joining.
(IPA Exam)
@@pushp99 how long it will going to take for examination conduction mail? I have applied on 20th of this month still no updates yet
@@kirannaik8898 are you asking for NINJA?
10:18 no we will use LIMIT for deleting one record from the table like 'LIMIT 1'
a limit clause justs limit the number of rows shown using select statement, does not delete anything
@@kingmakerzz123 😂😂true
@@calmspace8221what is there to laugh. Everyone is a learner here, we can't laugh in someone's lack of knowledge.
Keep in the loop
All hierarchy answers through based on your TH-cam video may be zigzagged
Please tell me only oracle(sql/plsql)can we get the job
Please make a video on Oracle SOA Developer
More informative.... thanks for plenty of efforts...
No dil will be rolled back
You must drop table
very good vedio helpful.
Sir jst could I ask a question can we explain something like definations in Hindi .
Bocz
e many candidate are can't fluently English
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
Truncate basically drops the table and creates the structure back ..so it is ddl and dml both
Make a vedio of. Net developer
Is there any demand for plsql developer ?
Future is all about data....so yes
Is it confirmed ?
@@himanish2006 Ya it's confirmed. We have received the future letter along with offer letter
Yes
We can use sp.rename to rename a column
It seems like fresher interview
That's why I use prisma for database interaction
TR interview duration is just 30min
mera bhi kra do tcs m interview
ALTER is DDL
Where is implementation
they asking hard questions to freshers
Rajesh gobinath ceo in tcs
Hello sir, if possible can you please arrange real interview for me
Is SQL a programming language??
Sql is not an program language which doesn't have any conditional and loop statements and logical operations it can't be used anything other than data manipulation
@@nayudug8407 you are wrong it is a programming language and it does have conditional statements
@@MrBlue-qe7yl pl/sql is procedural language
@@nayudug8407 the question is not about plsql being procedural language. it is about whether sql is a programming language.
Rajesh Gopinathan ceo of TCS
Alter table customer modify(address char(10),
Phone N(20));
We have delete , truncate, drop command to delete data , table..
This interview for freshers or experienced?
Very nice interview questions 👌🏻
Sir can I get good job after the bcs
Truncate command delete Identity but not delete command.