Ciena Software Developer interview questions

There were 3 written rounds before interview The first round had 3 questions - First and second questions were from data given in a table. We had to give the data structure that can be used to access the data from table. The second question was a SQL query from that table. The third question was java code for identifying a prime number Then there were 2 more coding rounds.

First: discussion about my work history, motivation and expectation. Then something about job in question, company requirements, projects, products. Then after some time another interview with different interviewers, similar topics.