Take FREE!! Online AMCAT Mock Test to Crack Wipro NLTH, Capgemini, etc.
Get Off-Campus Placement Jobs Info !!!
Practice Given Here Wipro NLTH Practice Q&A

Siemens Interview Questions

1.01K

Total Set :1



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?