SQL, OOPS, and Basic Programming Concepts
Filed under TCS
Free read 2 of 3Explain 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
Explain DELETE versus TRUNCATE distinctions regarding transaction logging and speed. Demonstrate using functions like GETDATE() or NOW() for date retrieval.
Define Abstraction, Encapsulation, Inheritance, and Polymorphism, providing concrete examples of how they were implemented in your resume projects.
Explain logic for palindrome verification using two pointers or string reversal, and leap year validation using divisibility rules for 4, 100, and 400.
Summarize arithmetic, relational, logical, and bitwise operators, clarifying operator precedence and evaluation order.
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.