Siemens Interview Questions

Question: 1 / 10

Can you Introduce Yourself briefly?

Question: 2 / 10

Let say you have some Record like below in the table.

         Id	Name
1	Ram,Shaym
  2   Â	Mohit,Arvind,Neelam

How you will convert this record into rows on the basis of ids, like below:

Id	Name
1	Ram
1	Shyam
2	Mohit
2	Arvind
2	Neelam

Question: 3 / 10

Can you again convert the above-converted table into comma separated value record in one column like below:

Ex.

Id	Name
1	Ram,Shaym
2	Mohit,Arvind,Neelam

Question: 4 / 10

Can we return more than one value using the function? If Yes then How?

Question: 5 / 10

What is the use of pipelined function?

Question: 6 / 10

Can you write one small Pipelined function?

Question: 7 / 10

Find 3^rd highest Salary from Emp. table (5 Way ).

Question: 8 / 10

Can you write a simple select Query that returns counting from 1 to 50?

Question: 9 / 10

Let say one string 'anayana' in this string how many times a occurs find using SQL query.

Question: 10 / 10

What is rollup and cube function in SQL?