โ† TCS questions

SQL, OOPS, and Basic Programming Concepts

Filed under TCS

Free read 2 of 3

Explain DELETE versus TRUNCATE distinctions regarding transaction logging and speed. Demonstrate using functions like GETDATE() or NOW() for date retrieval.

The question

Explain key concepts across SQL databases, programming fundamentals, and Object-Oriented Programming (OOP). Topics include SQL query execution and commands (DELETE vs TRUNCATE, fetching current date), standard algorithmic checks (palindromes, leap years), language operators, and core OOP principles as applied in resume projects.

Approach

  1. Explain DELETE versus TRUNCATE distinctions regarding transaction logging and speed. Demonstrate using functions like GETDATE() or NOW() for date retrieval.

Tips

  • What they are testing: Assesses practical understanding of database commands, basic programming logic, and fundamental OOP design principles.
  • Common mistake: Confusing DELETE (DML statement, can be rolled back, supports WHERE clause) with TRUNCATE (DDL statement, resets identity, faster).

Related TCS questions

Collected from public candidate posts and coding forums. Updated Nov 2026.