Syntel Technical Round Questions

Which type of questions asked in Syntel Technical Round interview, please provide here???

[Raman Vij]

Following type of questions asked in Syntel Technical Round interview:

1.What are the 4 basics of OOP?
Abstraction, Inheritance, Encapsulation, and Polymorphism.
2.What you mean by Object Relational DBMS?

3. Structural difference between bitmap and b-tree index ?

4.what is database Schema?

5.what are the different levels of database schema?

6. what is difference between foreign key and reference key ?

7. Tell me about DSN?

8.Difference between Clustered index and non clustered index ?

9 What is the difference between an EXE and a DLL?

10.Scenarios in which web application should be used and desktop application should be used?

11.Tell how to check whether a linked list is circular.

12.What is the difference between an EXE and a DLL?

13.Tell how to check whether a linked list is circular.

14.How can u increase the heap size in the memory?

15.Why is it difficult to store linked list in an array?

16.Different types of keys in SQL?

17.Explain about Joins, Views, Normalization, Triggers?

18.what is the difference between socket and session?

19.What is a default gateway?

20.Given an array of 1s and 0s arrange the 1s together and 0s together in a single scan of the array. Optimize the boundary conditions.

void main()
{
int A[10]={'0','1','0','1','0','0','0','1','0','1','0','0'} ;
int x=0,y=A.length-1;
while(x<y){
if(!A[x])
x++;
else if(A[y])
y--;
if(A[x] && !A[y])//here we are checking that stating index is having 1 and last index having 0 than swap values

A[x]=0,A[y]=1;
}
getch()
}

21.Define Data Abstraction. What is its importance?