Deloite_USI_interview_Questions

Download as pdf or txt
Download as pdf or txt
You are on page 1of 3

1 : What is the difference between stored and trigger procedures?

2. What is backpropagation?
3: What is the difference between a crossover and a
straight-through?
4: What is SMTP?
5. What is clustering support?
6. What is the role of IEEE in computer networking?
7: What made you apply for a position at Deloitte?
8 : What do you know about Deloitte?
9: What is C programming language?
10: What is the difference between C and Java?
11:. What is polymorphism in programming?
12: How can you create and use threads in Java?
13: What is the difference between char and varchar in DBMS?
14: What is an implicit cursor?
15. What is a proxy server?
16. What do you know about machine learning?
17: Can you explain function overloading?
18. What do you know about the Python language?
19. What do you understand about tunnelling protocol in
Computer Networks?
20. What are the pros and cons of star topology in Computer
Networks?
21. Discuss the physical layer of the OSI (Open Systems
Interconnection) :Model in the context of Computer Networks.
23. Differentiate between hierarchical database models and
networks in DBMS.
24. Explain the DDL (Data Definition Language), DML (Data
Manipulation Language) and DCL (Data Control Language)
statements in SQL.
25. What is a Kernel in OS?
26. What are the advantages and disadvantages of using threads
in context to the OS?
27. How does reference counting deal with objects that are
memory allocated in context to OS? When doesn't it get things
back?
28. Explain transaction atomicity in context to OS
29. What is the difference between a declaration and a definition
for a variable or a function in C?
30. What are the different storage classes in C?
31. What is generational garbage collection in the context of
Java? What makes it so popular?
32. What are access specifiers in C++?
33:Explain OOPS with real time example

34: SQL vs NOSQL

35: Theoretical questions on stacks and linked lists

36:SQL query for displaying two highest salaries in an employee


table

37: Joins, procedures, indexes, and views (theory)

38: A simple query on joins

39: 1 How can a number be expressed as a sum of two prime


numbers?.
40 : How to Check Whether a Number is a Perfect Number or
not? Write a Program.

41: Can You Write a program that takes a string containing


multiple words as input? Sort these words in ascending order
alphabetically. Then, print all the words that start with a vowel,
along with their positions in the sorted list

42 : Find K’th Character of Decrypted String


You have been given an Encrypted String where repetitions
of substrings are represented as substring followed by the
count of substrings.
Example: String "aabbbcdcdcd" will be encrypted as "a2b3cd3".

You might also like