Sample Questions for Test
1. Difference between Array and linked list
Q2. Difference between DBMS and RDBMS.
Q3. Abstract class can be defined or not?
Q4. Define Joint. What are types of join
Q5. Define Polymorphism + Example
Q6. Define Abstraction
Q7. Define Encapsulation
Q8. What is Inheritance? What types of Inheritance
Q9. Define Data Structures
Q10. What are fundamentals of OOP?
Q11. Define Database.
Q12. Linear and non-linear Data structure
Q13. What is polymorphism with any real life example
Q14. Method overloading and overriding
Q15. Write a program that have an array and count the number of pairs by the sum of the number
Q16. Write a program to inverse an array
Q17. What are procedures
Q18. What are type of SQL. What is DML
Q19. What is your final year project, tell detail and draw a database diagram of your FYP project
and also define the relationship among them?
Q20. Write a query to fetch data from your FYP and Diagram
Q21. In what field do you want to pursue?
Q22. What is indexing
Q23. You have unsorted array and find median of array
Q24. Write a query on find which customer place the order
Q25. How to optimize a query in accounts table?
Q26. Write a query to find average of salaries
Q27. Bubble sort technique. How it works
Q28. Merge and sort
Q29. Swap two numbers without using third variable
Q30. What is number of loops in bubble sort
Q31. You have a list of integers select second highest value
Q32. Select first name, average of amount from another table
Q33. Write a code which tells us that the given string is palindrome (i.e. madam) or not?
Q34. Write a query that shows the details of customer whose age is greater than 25
Q35. Write a query that show first Name, last Name and average order Quantity from table
customer and orders
Q36. We have1 million record of login. When we query the login its get slow how we can
optimize the query so that we can login quickly?
Q36. Why do we need polymorphism? Example of polymorphism in this room?
Q37. What do you know about diamond problem?
Q38. Code of diamond problem
Q39. Which language does not support multiple inheritance
Q40. Sorting techniques
Q41. Binary tree
Q42. Queue and stack
Q43. Write a code which will show maximum numbers of characters which are multiple times
Q44. Write a query that you have three table (customer, order and shipping) show all customer
whose shipping is pending? Show all customers whose order amount is greater then 500
Q45. Method vs function
Q46. Argument and parameter
Q47. Closure
Q48. Scope
Q49. Which is fast link list or array?
Q50. Paging
Q51. Margin bootstrap class
Q52. Html vs xml
Q53. CSS internal vs external
Q54. Class vs index
Q55. Count the repetition of letter ‘’a’’ in a given string
Q56. In a given array of integers find number whose sum is greater than 7
Q57. Write a query to fetch customer and shipping details from Customer and Shipping table
Q58. Sort a linked list of n length in reverse order.
Q59. Worst case scenario complexity level in single list in terms of big O
Q60. Constructer + types and destructor with example
Q61. Types of sorting techniques
Q62. Difference between inner join and outer join
Q63. Reduce number of iteration (first priority -> solution, second priority -> efficiency)
Q64. Difference between queue and stack
Q65. Difference between Binary search tree and binary heap
Q66. Difference between Primary and foreign key
Q67 Give a string to check it is palindrome or not
Q68 Write SQL query to check which customer place order
Q69 Write a sorting algorithm of your choice
Q70. Write a program which print only target value from array (target is 9, array=[2,7,9,11,15],
printed=[2,7])
Q71 Given a binary tree. Write a function to find maximum depth of tree. As tree’s node have
farest have longest path.
