Siemens Interview Questions
Top 10 Siemens Interview Questions With Answer
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 3rd 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?