[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.

CenturyLink Interview Questions

Submit :: Share your Interview Experience / Placement Papers / Exam Pattern
7.19K

Total Set :1

    CenturyLink
    Interview Q&A Set : 1

    Total Round : 1
    Asked @ Exp. : 5 Years.

    Posted By : Adiitya

    Read Int. Q&A 


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.
topology

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:

topology

Wite query to have output like below:

topology