Get Off-Campus Placement Jobs Info !!!
Programs asked in Mettl Coding Round
Click To Practce List of Programs asked in Nagarro !!!

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: