Basic Interview Questions – Object Oriented Programming
1. What is meant by the term OOPs?
2. What is the need for OOPs?
3. What are some major Object Oriented Programming languages?
4. What are the main features of OOPs?
5. What are some advantages of using OOPs?
6. How many keywords are there in C++, Java?
7. List the keywords in C++, Java?
8. What is a Class?
9. What is an object?
10. What is encapsulation?
11. What is Polymorphism?
12. What are different types of Polymorphism?
13. What is Compile time Polymorphism and how is it different from Runtime Polymorphism?
14. What is meant by Inheritance?
15. What is Abstraction?
16. How much memory does a class occupy?
17. What is a constructor?
18. What are the various types of constructors in C++?
19. What is a copy constructor?
20. What is a destructor?
21. Can we overload the constructor in a class?
22. Can we overload the destructor in a class?
23. What is call by value and call by reference?
24. What are pointers in C++?
25. Are class and structure the same? If not, what's the difference between a class and a structure?
26. Explain Inheritance with an example?
27. What are the various types of inheritance?
28. What is a super class and sub class? OR What is Base class and Derived class?
29. What is an interface?
30. What is meant by static and Dynamic polymorphism?
31. What is the difference between overloading and overriding in Java?
32. What is an abstract class?
33. How is data abstraction accomplished?
34. How is an abstract class different from an interface?
35. What are access specifiers and what is their significance?
PREPARED BY – ASST. PROF. V. S. PRABHAVALKAR DEPARTMENT OF CSE (AIML & DS)
36. What is an exception?
37. What is meant by exception handling?
38. What is meant by Garbage Collection in OOP
39. Can we run a Java application without implementing the OOPs concept?
40. Difference between Procedural and Object-Oriented Programming.
41. What is the virtual function
Basic Interview Questions – Database
1. What is a Database?
2. Explain different languages present in DBMS.
3. What is meant by ACID properties in DBMS?
4. Are NULL values in a database the same as that of blank space or zero?
5. What is Data Warehousing?
6. Explain different levels of data abstraction in a DBMS.
7. What is meant by an entity-relationship (E-R) model? Explain the terms Entity, Entity Type, and
Entity Set in DBMS.
8. Explain different types of relationships amongst tables in a DBMS.
9. Explain the difference between intension and extension in a database.
10. Explain the difference between the DELETE and TRUNCATE command in a DBMS.
11. What is a lock. Explain the major difference between a shared lock and an exclusive lock during a
transaction in a database.
12. What is meant by normalization and denormalization?
13. Explain different types of Normalization forms in a DBMS.
14. Explain different types of keys in a database.
15. Explain the difference between a 2-tier and 3-tier architecture in a DBMS.
16. What does ODBC in a database stand for?
17. Explain the concept of a database schema.
18. What is SQL, and what are its main components?
19. Give an Example of a SQL Query to select all records from a table.
20. Give an Example of a SQL Query to select records from a table based on a criterion.
21. Give an example of a SQL Query to insert a value in a table.
22. Give an example of a SQL Query to insert a value in a table.
23. Give an example of a SQL Query to update an existing value in a table.
24. What is a join in SQL, and what are the different types of joins?
25. Explain the use of indexes in a database.
26. Describe the difference between the HAVING and WHERE clause.
27. What are stored procedures, and what are their advantages?
28. What is a database transaction?
29. What is concurrency control, and why is it important?
30. What are deadlocks, and how can they be avoided?
31. What is a two-phase commit protocol?
32. Describe the role of a transaction log in a DBMS.
33. What are savepoints in a transaction?
34. What is rollback for transactions?
35. What is a distributed database, and what are its advantages?
36. Explain the concept of database replication.
37. Explain the role of caching in database systems.
38. What are the common security threats to a database?
39. What is a database backup, and why is it important?
40. How do you restore a database from a backup?
41. What is Serializability?
42. What are – validation based, timestamp based, granularity-based protocols?