TCS SQL/ PLSQL Real Interview BY TCS Team Interview Recording Simulation SQL TCS Ninja Interview

[niranjanbhosale]

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!

[SupeSaiyan]

*Simple English NO CONFUSION !!* 11:00


Drop : Deleting entire table (DDL), no more evidence of table.
DROP table <table_name>;

Truncate: deletes all the rows of a table (DDL), structure of table is still available.
TRUNCATE table <table_name>;

Delete: delete one or more rows of a table (DML), commit is required.
DELETE FROM table_name WHERE condition

[sarojrajah]

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

[viratchintu_]

Really helpful 👍
Thanks for sharing 🤝

[anantthakur]

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

[abdulrashidkadri]

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

[Amar_Feb]

Good initiative .. Very Helpful for Job seekers ..

[krishnendudeb]

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

[only_for_funr]

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

[dheerajkoranga]

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

[AjayRana-gcgl]

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

[jayaghate]

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

[souravbhowmickn]

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.

[hellocartoons]

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

[dipjoytidebnath]

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

[raghavverma]

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..

[xploreindiawithsandhya]

very do video On only SQL interview for freshers

[MrSarath]

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

[neeraj_ydv]

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

[vasusharma]

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