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
Implicit cursors are automatically created when select statements are executed. Explicit cursors needs to be defined explicitly by the user by providing a name.
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
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]
@@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.
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.
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
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
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.
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.
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...
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
@@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
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
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.
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
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 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...
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😊
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
DDL (Create, Alter, Drop, Truncate ) DML (Insert, Update, Delete, Lock) DCL(Grant, revoke) DQL(Select) TCL(commit, Saveponit, Rollback, Set Constrain, set transection)
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.😊
Thank you so much for this amazing interview video, you are doing great help to students
Alter command is a DDL command
For editing column name using alter command only using Alter table tablename change column old_name new_name;
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.
@@WebDevAnjali yeah they just see graduation & what kinda skills you have ..
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
I like it sir
And very very helpful videos
Isi trah ka video de har syllabus pe..
Really helpful 👍
Thanks for sharing 🤝
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 for the insight
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 RUclips/Google just by searching
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
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.
Good initiative .. Very Helpful for Job seekers ..
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
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😂
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.
Thanks for the video 😀
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?
helpful video ☺️
thanks bro nice video
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??
As a fresher , he has good knowledge for TCS
😂
Joke of the day 😂
i am ux designer he is dumb and fit for TCS
😂
Delete data can perform rollback , but truncate is auto commit, only dba can get back from back end.
Thanks
lol
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.
@14:19 the answer shocked Mr. Srinivas
Yes because of group by
very good vedio helpful.
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.
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
Keep in the loop
Sir, this is very helpful...Thanks a lot...please make a video on MEAN stack then it will be very helpful for us...
Delete maintains transaction logs but Truncate can't.
Yes
Thank u for this video..its very helpful to prepare for interview
very helpful.....please do video On only SQL interview for freshers
More informative.... thanks for plenty of efforts...
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
Update table name set salary = 1000 after that you must commit else it will not be committed unless you set auto comit in settings
Is he fresher?
Look like fresher
Stored programs date functions , char, numeric functions will be used in sql
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 😅
Alter =DML command 6:50😂
How to apply TCS fresher Oracle developer job
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
thank you panel for making out 0:42
🤣
😂😂😂😂
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
finished watching
How to apply for this role?
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
Procedure is numerical method functions is varchar
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
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 🙏🏻
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.
package is 15 years old and questions are also of same era
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
The alter table is DDL comand in sql
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?
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..?
Good 👍
ALTER and CREATE is DDL command
INSERT,UPDATE AND DELETE are the DML command
Please tell me only oracle(sql/plsql)can we get the job
Thanks
Very nice interview questions 👌🏻
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
good interview
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
We can use sp.rename to rename a column
Everytime the interviewer says "aienn".. he means it and you know that you have made some mistake.
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
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..
Make a vedio of. Net developer
Please make a video on Oracle SOA Developer
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
Man this interview is disaster
You can't ask scenarios in an interview that came across in your work
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
Its too much 51min interview aah...OMG
Ss
He's naive, these questions are extremely basic is it for fresher?
That's why I use prisma for database interaction
35:30
Procedure performance an action and function returns one value and if you want to retrieve more values use loops and cursors
Answer for that question is to use OUT parameters while calling a procedure or function to return more than one value.
Pipeline function
DELETE
Deletes specific rows based on condition
DROP
Deletes the entire table or database
TRUNCATE
Deletes all rows but retains table structure
:') These qualifications woun't even give me chance to be in an internship in Bangladesh :')
We have delete , truncate, drop command to delete data , table..
All hierarchy answers through based on your RUclips video may be zigzagged
Where is implementation
Sir can I get good job after the bcs
SQL plus means user practice compiler...
Useful..how much experience he hace?
My Question is that he is selected or not?
mera bhi kra do tcs m interview
can commerce make career in sql queries
Truncate command delete Identity but not delete command.
Is it tcs digital or codevita interview?
Can anyone help me for a sql unique project ?? It will be a great help
Alter table customer modify(address char(10),
Phone N(20));
Truncate basically drops the table and creates the structure back ..so it is ddl and dml both
basics should be brushed up well here ...
Update
tablename
Set
Salary=1000
Where
catageroy=departmentname
Select from functions. Method