Another very common variation is how to store a tree data structure in a database.
Be prepared to answer this question even if you are applying for U ...
Search results for delete
Insert and Remove operations on single linked list based on the Node value
Posted by CommonInterview
“Write functions Insert and Remove which add and remove nodes from ordered single linked list based on the Node value”
Operations of insertion ...
What is a performance consideration of having too many indexes on a production online transaction processing (OLTP)table
Posted by Devin
You are looking for the applicant to make some reference regarding data manipulations. The more indexes on a table, the more time it takes for the dat ...
DELETE TABLE is a logged operation, so the deletion of each row gets logged in the transaction log, which makes it slow. TRUNCATE TABLE also deletes a ...
A question where every coder/DBA/QA and Tester should now about
Task is to write a function which removed words "INSERT" and "DELETE" from the input string
string Clean(string input)
Result of function clean sh ...
What is the difference among dropping a table, truncating a table and deleting all records from a table.
Posted by Devin
Dropping : (Table structure + Data are deleted), Invalidates the dependent objects ,Drops the indexes
Truncating: (Data alone deleted), Performs a ...
Use the DELETE statement to remove records or any particular column values from a database.
[Source: JAGAN MOHAN "Interview questions bible"] ...
« previous1 next »