CenturyLink Interview Questions
Total Set :1
Top 10 CenturyLink Interview Questions With Answer
Question: 1 / 10
What is JOIN in sql? How JOIN work in SQL?
Question: 2 / 10
You have two table a and b and table a column name are a1 and b1,like below.
How many rows for inner join?
How many rows for left Join?
How many rows for Right join?
How many rows for full outer join?
Question: 3 / 10
If any column in the table having a primary key then index needs to be created or not?
Question: 4 / 10
How to optimize sql Query?
Question: 5 / 10
How to use of Hints?
Question: 6 / 10
How to handale exception in collections ?
Question: 7 / 10
Can we write return in a procedure? if so can you explain with example?
Question: 8 / 10
if in procedure I will write exception, when other then "Exception No Data Found". Will Procedure Compile?
Question: 9 / 10
How materalized view different from table ?
Question: 10 / 10
Let Say you have Emp. Table like below:
Wite query to have output like below: