Eurofins Interview Pattern and importants to cover in Interview

Eurofins Interview Pattern:

Those who are going for a Eurofins interview, please refer the below interview pattern for the practicing purpose.

some people got call letter for this.

There were 3 rounds.

1st round - online test (Technical + Quantitative MCQs)
MCQs were asked about basics of C, C++, SQL queries, Quant

2nd round – Technical

There were 2 technical interview rounds - both consisted of in-depth understanding of Data
Structures and DBMS. Also, OOPS concepts.

Questions on OOPs, Normalization, SQL, DBMS, questions on your projects, SDLC, Software EngineeringWrite the code to implement Candy Crush using Data Structures?

Important SQL Questions:

you can refer to  topics of C programming and SQL 

SQL Important Questions: 

This the material for SQL profile. I am assuming this is sufficient material for SQL preparation. All the interview questions can be covered from these questions.

1> What is DBMS?  & What is RDBMS and difference between both.

2> What is the difference between SQL and MySQL or SQL Server?

3> What is the difference between SQL and PL/SQL?

4> What are various DDL, DML, DCL commands in SQL? Give a brief description of their purposes.

5> Is a NULL value same as zero or a blank space? If not then what is the difference?

6> What is constraints in SQL and how many constraints are in SQL
Not Null?
Unique Key (prepare Unique key in details)
Primary Key(prepare Unique key in details)
Foreign Key(prepare Unique key in details)
Check Constraint(prepare Unique key in details)
Index(prepare Unique key in details)
Default(prepare Unique key in details)

7> What is the difference between Delete, drop and truncate

8> What is the difference between where and having a clause

9> What is join and types of join with an example?

10> What is Union and Union ALL, the difference between both

11> What are the properties and different Types of Sub-Queries?

12> Which TCP/IP port does SQL Server run on? How can it be changed? Answer: 1433

13> What is index and types of index

14> What is ACID property in the database?

15> What is the difference between NULL value, zero and blank space?

16> Which are the different case manipulation functions in SQL?

17> What is the usage of NVL function?

18> Which function is used to return the remainder to a division operator in SQL?

19> What is the usage of the DISTINCT keyword?

20> What is Normalization and type of normalizations?

21> What is SQL Injection?

22> What is denormalization?

23>  What is a View?

24> What is a Cursor? And type of cursor

25> What are local and global variables and their differences?

26> . What is Datawarehouse?

27> What is OLTP and OLAP and difference between both?

28> What is Star Schema and Snowflake Schema and the difference between

29>  What is Union, minus and Interact commands?

30> What is an ALIAS command?

31> What are aggregate and scalar functions?

32> What is the command used to fetch first 5 characters of the string?
Answer: Select SUBSTRING(StudentName,1,5) as student name from student

33> How to fetch alternate records from a table?

Answer: Select studentId from (Select rowno, studentId from student) where mod(rowno,2)=0

34>  How to fetch common records from two tables?
Answer: Select studentID from student. <strong>INTERSECT </strong> Select StudentID from Exam

35> How can you create an empty table from an existing table?
Answer: Select * into studentcopy from student where 1=2

36> SQL Query to find second highest salary of Employee ?
Answer: select MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) from Employ

37> SQL Query to find Max Salary from each department.

Answer: SELECT DeptID, MAX(Salary) FROM Employee  GROUP BY DeptID
38> Write SQL Query to display the current date.
Answer:SELECT GetDate();

39>  Write an SQL Query to check whether date passed to Query is the date of given format or not.
Answer: SELECT  ISDATE('1/08/13') AS "MM/DD/YY"; 

40>  Write an SQL Query to print the name of the distinct employee whose DOB is between 01/01/1960 to 31/12/1975

Answer: SELECT DISTINCT EmpName FROM Employees WHERE DOB  BETWEEN ‘01/01/1960’ AND ‘31/12/1975’;

41> Write SQL Query to find duplicate rows in a database? and then write SQL query to delete them?

Answer: SELECT * FROM emp a WHERE rowid = (SELECT MAX(rowid) FROM EMP b WHERE a.empno=b.empno)

And To delete:
DELETE FROM emp a WHERE rowid != (SELECT MAX(rowid) FROM emp b WHERE a.empno=b.empno);

42> What is a Composite Key?

43> What are COMMIT and ROLLBACK in SQL?

44> What is a RANK function?

45> What is a materialized view?

46> What is the difference between the NVL and the NVL2 functions?

47> What is the difference between cross joins and natural joins?

48> What is the purpose of the MERGE statement in SQL?

49> What is the difference between VARCHAR2 AND CHAR datatypes?

50>  What is clone Table

51> What is the difference between the RANK() and DENSE_RANK() functions? Provide an example.

C Programming:
C programming : you can get 1-2 C program in any technical interview.

1> Write a program to print next to last word of a sentence

2> Write a program to remove the vowels from the input string.

3> Write a Program to convert uppercase to lowercase and vice versa of a given string or sentence

4> Write a program to reverse the string 

5> Write a program to print a desired character from string 

6> wap to enter a string then convert it into upper case

7> .wap to enter a string then convert it into lower case

8> wap to enter the String then remove vowels from the string.

9> wap to enter the string remove the blank spaces from the string.

10> wap to enter a sentence then find 2 last word of sentence

11> wap to enter a string then convert the string into reverse order.

12> wap to enter the string then find the respective ascii value of the string.

13> wap to enter the string then count the length of the string.

14> wap to enter the sentence then find the word from the sentence.

15> wap to enter the string then delete the vowels from string.

16> wap to enter the string then count the length of string.

17> wap to enter the sentence then print it in reverse order

18> wap to enter a string then count the no. of vowels in the string.input:-ABCD, output:-BCDE

19> wap to enter a string then print the longest String in java string array

20> WAP to remove comment lines .

21> WAP to reverse the string like i love india so output will be - india love i

22> WAP to find string is palindrom or not.

23> WAP to find the length of string.

24> WAP to find the number is power of 2 or not.

25> WAP for string comparision.

26> WAP of Bubble sort.

27> WAP to find the LCM nd GCD.

28> WAP to find the sum of digits in number like 245 so output will be 2 + 4 + 5 = 11

29> Wap for fibnocci series for n number :0 1 1 2 3 5 8 13 21….

30> wap(write a program ) to find out the highest number in given numbers 

31> .WAP to reverse the string using linked list

32> wap to remove the blanck space from the string without using built in function

33> WAP for 2^n like 2^3..(search on google u will get answer)

34> write a program to find out the sub string of a string without using built in function 

35> wap for bubble sort, insertion sort, selection sort

36> write a recursive function to find the length of the of string 

37> write a recursive function to find the factorial of a number

Data Structure: you should prepare few data structure concepts like:
LinkedList
Queue
Searching
Sorting
Queue
Array.
Oops Concepts:
Prepare Opps concept with live examples

4th round - HR
Questions like why Eurofins IT Solution, puzzles, describe your project, few questions based on resume